Hello, this is my first attempt to query and print a result coming from a
database, in this case interbase6.
I got the following error: InterBase: Dynamic SQL Error SQL error code =
-504 Cursor unknown in maingeral.htm on line 8
Here's the code:
<? include("php/header.php");
ibase_pconnect(BANCO,DBUSER,DBPASSWD)
or die ("<script language='javaScript'> alert('" . ibase_errmsg() .
"'); </script>");
$stmt = "select count(*) from soldcars";
$query = ibase_query($stmt) or die ("<script
language='javaScript'>alert('" . ibase_errmsg() . "'); </script>");
$result = ibase_fetch_row($query); // THIS IS LINE 8
$TOTSOLD = $result;
ibase_free_result($query);
$stmt ="select Total from monthsold";
$query = ibase_query($stmt) or die ("<script
language='javaScript'>alert('" . ibase_errmsg() . "'); </script>");
$result = ibase_fetch_row($query);
$TOTMONTH = $result[0];
ibase_free_result($query);
$stmt = "select count(*) from deal where available = 1";
$query = ibase_query($stmt) or die ("<script
language='javaScript'>alert('" . ibase_errmsg() . "'); </script>");
$result = ibase_fetch_row($query);
$TOTAVAIL= $result[0];
ibase_free_result($query);
ibase_commit();
ibase_close();
?>
I have 3 query blocks. the result shows the contents of 2nd and 3rd block
variable:TOTMONH and TOTAVAIL but nothing from the first block, TOTSOLD.
If I comment the first block entirely, I got the same error
(ibase_fetch_row line) on the 2nd block and the only result that appear is
from the 3rd block.
What I am doing wrong?
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]