Re: [PHP] how to reinitialise an MySQL_fetch_array

2001-12-16 Thread Frederick L. Steinkopf 

Use the function mysql_data_seek(result variable, row number)
so in your case it would be: mysql_data_seek($result2, 0);
You should also consider suppressing the warning for an empty set by placing
a '@' in front of the function

- Original Message -
From: Ivan Carey [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Saturday, December 15, 2001 7:32 AM
Subject: [PHP] how to reinitialise an MySQL_fetch_array


Hello,
I would like to reinitialise an MySQL_fetch_array. That is, once it has gone
through I would like to be able to go back to the start again.

for eg
while ($myrow=MySQL_fetch_array($result2))
{
 $befid=$myrow[beforeid];

 while($myrow5=MySQL_fetch_array($result5))
 {
  $aftid=$myrow[afteridid];
  if ( $befid == aftid)
  {
  do something;
  }
 } //while($myrow5=MySQL_fetch_array($result5))

//now that the inner loop has finished I would like to be able to
restart the inner loop by reinitailsing the MySQL_fetch_array

} //while ($myrow=MySQL_fetch_array($result2))

Regards,
Ivan





-- 
PHP General Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]

[PHP] how to reinitialise an MySQL_fetch_array

2001-12-15 Thread Ivan Carey 

Hello,
I would like to reinitialise an MySQL_fetch_array. That is, once it has gone through I 
would like to be able to go back to the start again.

for eg 
while ($myrow=MySQL_fetch_array($result2)) 
{
 $befid=$myrow[beforeid];

 while($myrow5=MySQL_fetch_array($result5))
 {
  $aftid=$myrow[afteridid];  
  if ( $befid == aftid)
  {
  do something;
  }
 } //while($myrow5=MySQL_fetch_array($result5))

//now that the inner loop has finished I would like to be able to restart the 
inner loop by reinitailsing the MySQL_fetch_array

} //while ($myrow=MySQL_fetch_array($result2)) 

Regards,
Ivan