On 2/26/2013 4:33 PM, Daniel Brown wrote:
On Tue, Feb 26, 2013 at 4:27 PM, Curtis Maurand <curtis@xxxxxxxxxxx> wrote:
I have the following:
$dsn = "mysqli://$username:$password@$hostname2/$database";
$options = array(
'debug' => 3,
'result_buffering' => false,
);
$dbh =& MDB2::factory($dsn, $options);
if (PEAR::isError($mdb2))
{
die($mdb2->getMessage());
}
function tallyCart($_u_id,$dbh){
while($row = $result->fetchrow(MDB2_FETCHMODE_ASSOC)) {
$_showCheckOut=1;
$_pdetail=new ProductDetail($row{'product_ID'},
$row{'product_Quantity'}, $_u_id);
$_getSubTotal += $_pdetail->_subTotal;
$_counter++;
}
}
I'm getting: Call to undefined method MDB2_Error::fetchrow()
anyone have any ideas? Can I not pass a database handle to a function?
Thanks,
Curtis
Hate to answer a question with a question, but:
1.) Do you have the PEAR package MDB2 installed?
2.) Where is $result defined? I don't see it in your code snippet here.
Sorry,
$myquery = "SELECT * from tbl_Cart where u_ID='$_u_id'";
echo $myquery;
$result =& $dbh->query($myquery);
I then tried setting the buffering to true and did a
if($result->numrows() >0) and wrapped it around the entire fetchrow loop
and I still get the same thing.
I just took a look and the libraries are installed if not a bit
outdated, but they are there.
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
