No what I meant was that I have created a Database with a table called
test and in that table I have a field called text and I have already
put data in it.

Now I want to get the data out of this table with the select stuff and
I want to do this with PHP. So I wanted to do some testing but I cant
get the data out of it.

I can connect over PHP with the Database but I am having some problems
executing the select statement in PHP the same statement in ISQL works
fine.
I hope that you can help me now.

Regards

Rob

--- In firebird-php@yahoogroups.com, "Didier Gasser-Morlay"
<Didiergm@n...> wrote:

> 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@y...>
> > 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);
> > ?>
> >