Subject -204 Table unknown
Author nn33dl3
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);
?>