mysql_fetch_array, starting over

[dwessell]

When using mysql_fetch_array, if I loop through the contents of it, to the end, say:

while($row = mysql_fetch_array($result,MYSQL_NUM) ){
$gameUpdateQuery = "UPDATE GameInformation SET State = 1 WHERE GameNumber = $row[0]";
mysql_query($gameUpdateQuery);
}

How can I reset that pointer, so that it's back at the beginning, as if I had never iterated through the array?

Thanks
David

 

[dwessell]

Ah.. I think I found it:

mysql_data_seek($result,0);