|
|
Posted by Johan van Zyl on 03/26/05 21:43
Hi All
This code:
<?
print "Connected to: ";
print " ";
$host = "10.0.0.3:employee.fdb";
//$host = "10.0.0.6:testfb";
print_r($host);
$username = "SYSDBA";
$password = "masterkey";
$dbh = ibase_connect($host, $username, $password);
if (!$dbh)
{
exit ("Unable to establish a connection - please try later.");
}
else
{
$stmt = "SELECT FIRST_NAME, LAST_NAME FROM EMPLOYEE ORDER BY LAST_NAME
DESC, FIRST_NAME DESC";
$result = ibase_query($stmt);
//$row_array = ibase_fetch_row($result);
//$row_array = ibase_fetch_row($result);
//print_r($row_array);
?>
<TABLE BORDER=0 BGCOLOR='#55BFFF' CELLSPACING=6 CELLPADDING=0 WIDTH='100%'>
<TR>
<TD><P><B>First Name</B></P></TD>
<TD><P><B>Last Name</B></P></TD>
</TR>
<?
While ($row = ibase_fetch_assoc($result))
{
echo "<TR>";
echo "<TD><SPAN STYLE= 'font-size: 11px;'>";
echo $row["FIRST_NAME"];
echo "</TD>";
echo "<TD><SPAN STYLE= 'font-size: 11px;'>";
echo $row["LAST_NAME"];
echo "</TD>";
echo "</TR>";
}
echo "</table>";
ibase_free_result($result);
}
?>
gives me this error:
Connected to: 10.0.0.3:employee.fdb
First Name Last Name
Fatal error: Call to undefined function: ibase_fetch_assoc() in
/home/e-smith/files/ibays/Primary/html/html/untitled17.php on line 209
How do I slove this?
Thx
----------------------------
Johan van Zyl
JVZ Systems CC/realcorp.net
Customised Software
http://www.jvz.co.za
johan@jvz.co.za
021 851 7205
082 875 4238
--
No virus found in this outgoing message.
Checked by AVG Anti-Virus.
Version: 7.0.308 / Virus Database: 266.8.1 - Release Date: 2005/03/23
Navigation:
[Reply to this message]
|