Ok, how do you go back to the first row once you have odbc_fetch_row()'ed until the end? Let's say I want to loop through something twice. Do I have to do the same query again, and then do the second loop, or is there a good way to do this? In ODBC?
SCT
Fetch the whole result into an array - the you can loop the result how many times you want.
/N.B
That's a nasty work around. tsk tsk.
from the manual:
int odbc_fetch_row (int result_id [, int row_number])
how about suppliying a row number of 0 when entering your second loop?
this should reset the internal row counter.
Good idea... when you have like 10.000 records in your resultset.
Indeed. Thank you, I missed that the first time through the documentation. This would nail it.
