Subject | -204 Table unknown |
---|---|
Author | nn33dl3 |
Post date | 2005-03-28T19:19:10Z |
Hi,
I am very new to Firebird that's why I am using this example to
connect to a Database with PHP but every time when I execute the
Script I get the following Error message:
Warning: ibase_query(): Dynamic SQL Error SQL error code = -204 Table
unknown TEXT At line 1, column 16. in
D:\Projekte\Firebird_php\test_con.php on line 7
I have tried "table_name" but didn't work.
Maybe someone can tell me what I am doing wrong here I am trying this
on a Windows XP maschine with PHP 4.3 and Firebird 1.5.2 installed.
Thanx in advance
Robert
<?php
$dbh = ibase_connect ('localhost:C:/TEST.GDB', 'SYSDBA',
'pommes', 'ISO8859_1', '100', '1' ) ;
$stmt = ' SELECT * FROM text ';
$sth = ibase_query($dbh, $stmt);
while ($row = ibase_fetch_object($sth)) {
echo $row->email, "\n";
}
ibase_free_result($sth);
ibase_close($dbh);
?>
I am very new to Firebird that's why I am using this example to
connect to a Database with PHP but every time when I execute the
Script I get the following Error message:
Warning: ibase_query(): Dynamic SQL Error SQL error code = -204 Table
unknown TEXT At line 1, column 16. in
D:\Projekte\Firebird_php\test_con.php on line 7
I have tried "table_name" but didn't work.
Maybe someone can tell me what I am doing wrong here I am trying this
on a Windows XP maschine with PHP 4.3 and Firebird 1.5.2 installed.
Thanx in advance
Robert
<?php
$dbh = ibase_connect ('localhost:C:/TEST.GDB', 'SYSDBA',
'pommes', 'ISO8859_1', '100', '1' ) ;
$stmt = ' SELECT * FROM text ';
$sth = ibase_query($dbh, $stmt);
while ($row = ibase_fetch_object($sth)) {
echo $row->email, "\n";
}
ibase_free_result($sth);
ibase_close($dbh);
?>