Ok, this is my code :
$cnx = odbc_connect($DATASOURCE,$DBUSERNAME,$DBPASSWORD);
$qrySelectRESULT = odbc_exec($cnx, "Long query here. Takes about 40 seconds to run");
while(odbc_fetch_row($qrySelectRESULT)){
echo "dang.<br>";
}
Now, this should return pages and pages of "dang." Nothing is ever returned. Not even the first row. If, however, I substitute the while loop with
odbc_result_all($qrySelectRESULT);
It will still time out with the whole maximum execution thing, but it will at least give out the entire table, and THEN say it timed out. Not just a portion, the entire thing (204 rows. I never said it was big, just long).
$cnx = odbc_connect($DATASOURCE,$DBUSERNAME,$DBPASSWORD);
$qrySelectRESULT = odbc_exec($cnx, "Long query here. Takes about 40 seconds to run");
while(odbc_fetch_row($qrySelectRESULT)){
echo "dang.<br>";
}
Now, this should return pages and pages of "dang." Nothing is ever returned. Not even the first row. If, however, I substitute the while loop with
odbc_result_all($qrySelectRESULT);
It will still time out with the whole maximum execution thing, but it will at least give out the entire table, and THEN say it timed out. Not just a portion, the entire thing (204 rows. I never said it was big, just long).