using mysql_fetch_array multiple times?

Anon

Hello,

I need to loop over $result more than once, yet I can only call mysql_fetch_array($result) once. If I try to use it again in the script, I get nothing. Here is an example:

$result = mysql_db_query($db,$query)
or die("ERROR\n");

while ($row = mysql_fetch_array ($result)) {
echo "$row[foo]";
}
...
(now i need to loop over the same set of data again later on in the script)
...
while ($row = mysql_fetch_array ($result)) {
echo "$row[foo]";
}

What are you supposed to do when you need to loop over your database query results multiple times in a single script?

Anon

I just figured it out - sorry for the useless post.

Anon

How do you do it??

Jason
http://www.hodfords-hosting.com

Anon

You should post your answer because I am sure many people would like to know this as I have had the same problem. I usually adjust the pages for this, but haven't really found anything yet.

Brett

Anon

Good idea, sorry I didn't do this sooner.

If you want to loop over the same result set more than once, you need to reset the internal pointer back to the first item in the array. The function to do this is mysql_data_seek. You can read about it here:

http://www.php.net/manual/en/function.mysql-data-seek.php

Here's an example:
mysql_data_seek($comments_result,0);

this basically just resets the pointer to the first item in the array so when you loop over your result, you are starting with the first item. you will need to do this each time you want to loop over the same result set.

hope this helps,
- Reuben

Anon

Sure does help, thanks.

Wonder why they didn't call it mysql_array_reset . . .

Thanks man.

Anon

hi man,
i got another problem hardly has anything to do with yours, but it was solved coz of your text. thanx.
enjoy,
hackle