Here's my question. I want to go through a database query result set using the mysql_fetch_row() function twice.
But the second time I try to use mysql_fetch_row(), it returns false because the function has previously gone through each row and there are now no more rows.
Can I somehow reset the function without having to make a second database query?
thanks
Yep nice easy one the function mysql_data_seek ($queryhandle, 0) will reset the internal pointer of the mysql query back to zero.
P
You should be able to use mysql_data_seek():
<?php
mysql_data_seek( $result, 0 );
?>
Will reset the internal result pointer to the first returned row, so the next mysql result call will act on that row.
You can move around anywhere within the result this way.
See:
http://www.phpbuilder.com/manual/function.mysql-data-seek.php
Hope this helps!
-Rich
Great.
Thank you very much.
This made things a whole heck of a lot easier.
Jonny