Quick mysql_fetch_assoc question 1

[Lochness30]

Just wondering, if I have a block of code to go through a list of records. Say

while ($row = mysql_fetch_assoc($result)) {
        echo $row["userid"];
        echo $row["fullname"];
        echo $row["userstatus"];
    }

Is there a way to reset the list, so I can go through it again? Or do I have to reissue the original select statement??

Thanks

 

[sleipnir214]

You can move the result pointer back to the beginning.

See

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

Want the best answers? Ask the best questions!

TANSTAAFL!!

 

[Lochness30]

That's what I was looking for!
Thanks!

 

[DRJ478]

Generally speaking:
It is not efficient to go through a list multiple times. Try to optimize your code that you just need to iterate the result set once.