i'm having a problem. i have the following:
------------------------------
$sql_count = "select count(*) from spr_problemdata";
$row_count = OCIParse($conn, $sql_count);
OCIExecute($row_count);
OCIFetch($row_count);
$num_rows = OCIResult($row_count,1);
echo $num_rows + 1;
------------------------------
the problem is that the sql query seems to be caching.. I'm using an oracle 8 database.
how do i stop it from caching?
------------------------------
$sql_count = "select count(*) from spr_problemdata";
$row_count = OCIParse($conn, $sql_count);
OCIExecute($row_count);
OCIFetch($row_count);
$num_rows = OCIResult($row_count,1);
echo $num_rows + 1;
------------------------------
the problem is that the sql query seems to be caching.. I'm using an oracle 8 database.
how do i stop it from caching?