Jump to content


Shopping Cart Quantity Problems

  • Please log in to reply
1 reply to this topic

#1 imateacher

  • New Members
  • Pip
  • Newbie
  • 1 posts

Posted 09 April 2006 - 11:13 AM

I have a table which contains items which people want to buy. It is based on the session ID so that they can be retrieved for the cart. However, I want the quantity to change the amount of postage. This is the code i have written so far:

$sid = session_id();

$sql = "SELECT SUM(ct_qty)
FROM tbl_cart
WHERE ct_session_id = '$sid'";
$result = dbQuery($sql);

$totalquantity = $result;
echo $totalquantity;

However, this just echos 'Resource id #14'. I want the code to add up all the ct_qty values where the ct_session_id is equal to $sid.

I am new to this more advanced coding so any help would be appreciated. Thanks in advance.

#2 fenway

  • Staff Alumni
  • MySQL Si-Fu / PHP Resident Alien
  • 16,199 posts
  • LocationToronto, ON

Posted 09 April 2006 - 06:54 PM

That's because $result in a DB resource -- you need to get at the data inside the recordset. Since you're just returning one record and one column, you can do the following:

$result = dbQuery($sql);
$totalquantity = mysql_result( $result, 0, 0);

In the general case, use mysql_fetch_assoc(), and iterate properly.
Seriously... if people don't start reading this before posting, I'm going to consider not answering at all.

0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users