resetting mysql_fetch_array()

[jg]

Is there a way to reset the pointer when iterating through records using
mysql_fetch_array()?

<?php
connect ....

$result = mysql_query("SELECT idno FROM mydata");

// i need the value from the 1st record here
if ($row = mysql_fetch_array($result,MYSQL_NUM)
{
$somevar = $row[0];
}

/// more code

while ($i<10)
{
// i need it again here
if ($row = mysql_fetch_array($result,MYSQL_NUM))
{
//blah blah

TIA,
jrg

[Andy Hassall]

On Mon, 05 Apr 2004 19:17:47 GMT, "jg" <jrg@nospam-weirdcat.com> wrote:

>Is there a way to reset the pointer when iterating through records using
>mysql_fetch_array()?

Go to [url]www.php.net[/url]. Put in the "Search" box at the top:

reset pointer mysql

--
Andy Hassall <andy@andyh.co.uk> / Space: disk usage analysis tool
[url]http://www.andyh.co.uk[/url] / [url]http://www.andyhsoftware.co.uk/space[/url]