Robert,
probably a silly question but

1) I would have thought that Text was a reserved word anyway => you might
not be able to create a table with that name

2) have you created a table in your database called "table_name" ?

if not then look at the create table syntax where you define the fields etc...

If I am stating the obvious, then accept my apologies

Didier



Date: Mon, 28 Mar 2005 19:19:10 -0000

> From: "nn33dl3" <nn33dl3@...>
> Subject: -204 Table unknown
>
> 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);
> ?>
>