Re: Stupid question

On 2/26/2013 4:33 PM, Daniel Brown wrote:

On Tue, Feb 26, 2013 at 4:27 PM, Curtis Maurand <curtis@maurand.com> 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.