mysql_fetch_array() question

[Anon]

Why can't I loop through a database record more than once?

First loop:
while ($fetch_extra = mysql_fetch_array($extra_result)) {
echo $fetch_extra["price_information"];
echo $fetch_extra["VAT"];
}

Then I try to loop it again like this:
while ($fetch_extra2 = mysql_fetch_array($extra_result)) {
echo $fetch_extra2["price_information"];
echo $fetch_extra2["VAT"];
}

But the second loop returns nothing.
The mysql_query result is the same in both and this is "fetched different" in both loops.

Why?

[Anon]

You have to "rewind" the php-record counter...

use :

mysql_data_seek($extra_result,0);

where 0 is the first record in your result-array

Good luck!!

[Anon]

...but is this one only possible to use together with mysql_fetch_row() ??
Do you have any example code to show me?

[Anon]

Sorry mate. One CAN use it with mysql_fetch_array as well.

To quick