I've discovered that it is not the pointer in the array that I am having problems with but rather the pointer in the result handle.

From what I gather, when a mysql_fetch function (mysql_fetch_row, mysql_fetch_assoc, mysql_fetch_array) retrieves a row from the result handle (In this case it is $rsCommunitiesServed), the result handle's internal pointer is advanced one position.

The first mysql_fetch function (mysql_fetch_assoc) used in the recordset block causes the result handle's internal pointer to advance to the second record. So, when I later use mysql_fetch_array, the result handle's internal pointer is now on the second row of the results and so it gives me the second record. Actually, I use the mysql_fetch_array function in a while loop so what I get is all the records in the array which includes all records from the result set except for the first record.

So, what I need to do is move the internal pointer of the result handle back to the first row of the result set. How can I do this?

Thank you,
Blaine


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



Reply via email to