Subject | NEW TO FIREBIRD PHP CONNECTION |
---|---|
Author | ghazalravi |
Post date | 2009-01-16T13:53:02Z |
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';
}
$tablename='admins';
$stmt = 'select * from albums';
//$stmt = 'select * from $tablename';
echo $stmt;
$sth = ibase_query($dbh, $stmt);
//echo $stmt;
echo "<table border='1'>
<tr>
<th>ADMIN EMAIL</th>
<th>ADMIN NAME</th>
</tr>";
while ($row = ibase_fetch_object($sth))
{
echo "<tr>";
echo "<td>" . $row->ADMIN_EMAIL . "</td>";
echo "<td>" .$row->ADMIN_NAME. "</td>";
echo "</tr>";
//echo $row->, "\n";
//echo $row->;
}
echo "</table>";
ibase_free_result($sth);
ibase_close($dbh);
?>
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';
}
$tablename='admins';
$stmt = 'select * from albums';
//$stmt = 'select * from $tablename';
echo $stmt;
$sth = ibase_query($dbh, $stmt);
//echo $stmt;
echo "<table border='1'>
<tr>
<th>ADMIN EMAIL</th>
<th>ADMIN NAME</th>
</tr>";
while ($row = ibase_fetch_object($sth))
{
echo "<tr>";
echo "<td>" . $row->ADMIN_EMAIL . "</td>";
echo "<td>" .$row->ADMIN_NAME. "</td>";
echo "</tr>";
//echo $row->, "\n";
//echo $row->;
}
echo "</table>";
ibase_free_result($sth);
ibase_close($dbh);
?>