Is it possible to call odbc_fetch_array funtion two times on the same result set? Id like to be able to query the db, loop through the result, and then be able to loop through the result again later in the page.
$rs= odbc_exec($conn,$query);
while($row = odbc_fetch_array($rs))
{
//do something
}
//do some other stuff
// then loop through same recordset again
while($row = odbc_fetch_array($rs))
{
//do something else
}
Not sure if this is possible or not. Only way i can get this to work is to actually query the db again and i don't think i shoul have to do this so im sure there is another way.
Thanks in advance
