Hi all,

I want to grab the resul from a db query and store it in an array so that I
can selectively grab the data later.

This is what I'm doing:

$dbRowCount = mysql_num_rows( $result );
for ($i = 1; $i <= $dbRowCount; ++$i) {
        while ($row = mysql_fetch_array($result, MYSQL_ASSOC)) {
                $dbRow['ev_id']    = $row["id"];
                $dbRow['ev_uid']   = $row["user_id"];
                $dbRow['ev_title'] = $row["name"];
                $dbRow['ev_cat']   = $row["category"];
                $dbRow['ev_sd']    = $row["start_day"];
                $dbRow['ev_ed']    = $row["end_day"];

In my sample database, I have two records which are both found with the
query (tested in MySQLFront) but the array ends up with 3 rows each with the
last record in it.

Any suggestions?



George Pitcher
HERON Technical Manager
Ingenta plc
23-38 Hythe Bridge Street, Oxford, OX1 2ET
T  +44 (0)1865 799137 direct
T  +44 (0)1865 799000 switchboard
F  +44 (0)1865 799134

Ingenta: Empowering the exchange of academic and professional content

PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

Reply via email to