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

in

> C:\wamp\www\testing\db_connect.php on line 19
>
>
> ******************************************************
> this is my code
> ******************************************************
>
>
> <?php
> $host = 'localhost:/testing/t1.fdb';
>
> $dbh = ibase_connect($host, 'dbname', 'password');
> if (!$dbh)
> {
> die('Could not connect: ' .ibase_errmsg());
> }
> else
> {
> echo 'connection established';
> }
>
> $stmt = 'select * from albums';
>
> echo $stmt;
> $sth = ibase_query($dbh, $stmt);
> //echo $stmt;
> echo "<table border='1'>
> <tr>
> <th>ARTIST</th>
> <th>TITLE</th>
>
> </tr>";
>
> while ($row = ibase_fetch_object($sth))
> {
>
> echo "<tr>";
> echo "<td>" . $row->ARTIST. "</td>";
> echo "<td>" .$row->TITLE. "</td>";
> echo "</tr>";
> //echo $row->, "\n";
> //echo $row->;
> }
> echo "</table>";
> ibase_free_result($sth);
> ibase_close($dbh);
> ?>
>