Portland Web Development™

Reset a result source in PHP with mysql_data_seek

$result = mysql_query("SELECT names FROM table;");
while($row=mysql_fetch_array($result,MYSQL_ASSOC)) {
//procedure
}
mysql_data_seek($result,0); // Reuse your recordset
while($row=mysql_fetch_array($result,MYSQL_ASSOC)) {
//procedure
}

This entry was posted on Tuesday, August 28th, 2007 at 10:41 pm and is filed under ASP, Code Examples, MySQL, PHP, typography. You can follow any responses to this entry through the RSS 2.0 feed. Responses are currently closed, but you can trackback from your own site.

3 Responses to “Reset a result source in PHP with mysql_data_seek”

cherly Says:
September 15th, 2007 at 10:19 am
Thanks for the special work and information!
Wahoo Says:
October 6th, 2007 at 6:14 pm
Thank you for sharing!
Erik Says:
February 4th, 2009 at 7:42 am
looks to me that $row would be the same everytime.
what’s the point of the first ‘while’ then? why not just use a join?

please, what am i missing? thanks

Pages

Categories

Reset a result source in PHP with mysql_data_seek

3 Responses to “Reset a result source in PHP with mysql_data_seek”