hi
XP+IIS5.1+PHP4.3+ORACLE9.2(client)
<?php
if (empty($offset) || $offset < 0)
$offset=0;
}
$limit = 3;
$conn = OCILogon("userid", "userpasswd", "SID");
if (!$conn)
echo "<h1>ERROR - Could not connect to Oracle</h1>";
exit;
}
$sql = "Select count(*) from t1";
$stmt = OCIParse($conn, $sql);
if(!$stmt)
echo "<h1>ERROR - Could not parse SQL statement.</h1>";
exit;
}
OCIExecute($stmt);
OCIFetchInto($stmt, &$total_rows);
if ( !$total_rows[0] )
echo "<h1>Error - no rows returned!</h1>";
exit;
}
echo "There are $total_rows[0] results.<br>\n";
echo "Now showing results $begin to $end.<br><br>\n";
OCIFreeStatement($stmt);
?>
ERROR REPORT as follow:
Warning: OCIFetchInto: ORA-01002: ???? in C:\MyPHP\test.php on line 18
Error - no rows returned!
thanks!
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
