resetting the result of a mysql query

[tolkienarda]

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

[ronverdonk]

You have to use the mysql_data_seek() command (reset() is for arrays).
[php]$reset = mysql_data_seek($result, 0);
if (!$reset)
echo 'MySql data seek Error' . mysql_error();
$k = 1;
while ($k<=$row)
{
... etc ...[/php]Ronald :cool:

[tolkienarda]

thanks

and on a side note where can i get the source of functions like reset() and other prebuilt functions. as i learn more about php i would like to start learning the details

thanks again
eric

[ronverdonk]

You better do some PHP tutorials on the web. All the php functions can be found in the standard PHP documentation at www.php.net. Good luck.

Ronald :cool:

[tolkienarda]

I've done several of the tutorals like on w3cschools and here as well as several others and even a lynda.com training video but if there are more you can sugges that would be great

[ronverdonk]

You'll find something here:

http://www.allsyntax.com/tutorials/PHP/
http://devzone.zend.com/node/view/id/627
http://www.tizag.com/phpT/
http://www.phpfreaks.com/tutorials.php
http://www.minitutorials.com/webdesi...trotophp_1.php
http://bmw.ws.utk.edu/nsu/php/
http://www.developer.com/lang/php/article.php/3288671
http://www.w3schools.com

Ronald :cool: