RE: [PHP-DB] Using A Query Results Multiple Times

2001-10-24 Thread Adam Douglas
Yes, I had the right code just was missing the mysql_data_seek. Thanks for the help. -Original Message- From: Rick Emery [mailto:[EMAIL PROTECTED]] Sent: Tuesday, October 23, 2001 1:09 PM To: 'Adam Douglas'; PHP-DB (mailing list) (E-mail) Subject: RE: [PHP-DB] Using A Query Results

RE: [PHP-DB] Using A Query Results Multiple Times

2001-10-24 Thread Adam Douglas
-General (mailing list) (E-mail) Subject: RE: [PHP-DB] Using A Query Results Multiple Times Hi while(...) { do whatever } mysql_data_seek ($mysqlresultid, 0) while(...) { do whatever } mysql_data_seek ($mysqlresultid, 0) etc will set the pointer back to the beginning

RE: [PHP-DB] Using A Query Results Multiple Times

2001-10-23 Thread Rick Emery
You're on the right track. Did you try?: while( $row[] = mysql_fetch_array($result) ); This should load each result row into a row of a multi-dimensional array. You would then access it with: $row[0]['colname'] -Original Message- From: Adam Douglas [mailto:[EMAIL PROTECTED]] Sent: