reset result??

[happyme]

I have a sql query at the start of my script which I wish to use the results of twice

$sql="SELECT * FROM $tablename";
$result = mysql_query($sql)or die("Technical error, ".mysql_error());

while ($updaterow = mysql_fetch_array($result))
	{more  code here}

That works fine. I want to use result again later:

while ($myrow = mysql_fetch_array($result)) 
	{code here}

the array $myrow appears to be empty

what happens to result after mysql_fetch_array($result)?

Julia

[nnichols]

Hi Julia,

To use the result a second time you will need to reset the internal mysql pointer like this:

mysql_data_seek($result,0);

After the first loop through.

Hope this helps 😉

[happyme]

thank you, I knew there must be a simple solution, I just couldn't find it

🙂