Hello ghazalravi,

> I HAVE TWO TABLES (ADMINS AND ALBUMS) .when i try retrieving from
> one ADMINS table it displays my values, but when i try to retrieve
> from the ALBUMS table it shows an error as below :
> >
> > Warning: ibase_query() [function.ibase-query]: Dynamic SQL Error SQL
> > error code = -204 Table unknown ALBUMS unknown ISC error 336397208

Yes, we've got that. Like Lester suggested, it may have something to do
with the way the table was created - and if it was created at all.

If you run this query:

select rdb$relation_name from rdb$relations
where rdb$relation_name containing 'alb'

the table name should appear, if it exists. Also, if you accidentally
created it as ALBUM instead of ALBUMS, you should see it.

(If you don't have a lot of tables, just leave out the WHERE clause.)

If you see the table name in mixed or lower case, you MUST include it
in double-quotes in your queries, and follow the case letter by letter,
e.g. like this:

$stmt = 'select * from "Albums"';


Hope this helps,
Paul Vinkenoog