Hi. I'm trying to reset the mysql_fetch_array function so that it moves the internal data pointer on the resource back to the beginning. Basically I've got this inside a larger while loop:
while($authorrow = mysql_fetch_array($authorresult))
{
echo "<option value=\"{$authorrow['author_name']}\"";
if (strcmp($authorrow['author_name'], $row['author_name']) == 0)
{
echo " selected=\"selected\"";
}
echo ">{$authorrow['author_name']}</option>";
}
echo '</select><br />';
and it works great the first time around the larger while loop but after that it won't go back to my mysql query and get the same rows again. Thanks.