Hi all,
I have been developing in PHP/Interbase for about 2 years, and have just
started a new PHP aplication.
I wanted to use PEAR's DB abstraction, but am running into (big) problems. I
am sure I am doing something really stupid, but let's try anyway
External .inc.php file containing the following:
require_once("DB.php");
Function Connect_DB() {
$dbname="c:\www\support\database\support.gdb";
$dbuser="SYSDBA";
$dbpass="masterkey";
$dbhost="localhost";
$db=DB::connect( "ibase://$dbuser:[EMAIL PROTECTED]/$dbname" );
return $db;
}
Function Disconnect_DB($db) {
$db->disconnect();
}
I include this file, and then have the following code:
$db=Connect_DB();
$sql = 'SELECT NAME, DESCRIPTION FROM MENUITEM';
$demoResult = $db->query($sql);
if (DB::isError($demoResult)) {
die ($demoResult->getMessage());
}
$count = 0;
$demoResult->fetchInto($row);
if ($row = $demoResult->fetchRow()) {
$count ++;
echo "Line $count";
echo $row[0] . $row[1]. "\n";
}
Disconnect_DB($db);
The database Seelct statement should return 2 populated rows (and does in
other app)
The problem is that this section is either totally ignored, or it returns
millions of lines with blank $row resurls (ie lines of "Line1\nLine2\n, etc)
Where am I going wrong?
Thanks in advance...
David R
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
