DB question
| From: | Dennis Craig | Date: | Thu, 16 Nov 2000 19:54:50 +0000 |
| Subject: | DB question | ||
| Groups: | php.pear | ||
| Request: | Send a blank email to php-pear+get-451@lists.php.net to get a copy of this message | ||
I'm kind of new to OOP in PHP and I'm having a little problem - mainly
with Oci8.
When I use the below code with Oracle, I get "Warning: OCIFetchInto:
ORA-01002: fetch out of sequence in DB/oci8.php on line 206" after it
has unloaded everything in the "$row" array. The same code works fine
against mysql though?
$db = DB::connect("oci8://login:password@c1sc.world");
$sql = "SELECT username FROM userlogin";
if (DB::isError($result = $db->query($sql))){
echo "error";
} else {
while ($row = $result->fetchrow()){
echo $row[0]."<br>";
}
}
$db->disconnect();
Thanks,
Dennis