Hi all
how would i go about reseting the internal pointer in a mysql_query result
I use a loop to display the results of a colom in a select box
here is the loop
-
$i=1;
-
while ($i<=$row)
-
{
-
$row2=mysql_fetch_row($result);
-
echo '<option value="', $row2[1], '">', $row2[2], '</option>';//outputs the unique login name
-
$i++;
-
}
-
now i resuse this code with different variables here it is
-
$k=1;
-
reset($result);
-
while ($k<=$row)
-
{
-
$msrow=mysql_fetch_row($result);
-
echo '<option value="', $msrow[1], '">', $msrow[2], '</option>';//outputs the unique login name
-
$k++;
-
}
-
as you can see i've used the reset() function but it dosen't seem to work
thanks for any help
eric
