Jump to content

Archived

This topic is now archived and is closed to further replies.

imateacher

Shopping Cart Quantity Problems

Recommended Posts

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.
Imateacher

Share this post


Link to post
Share on other sites
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:

[code]$result = dbQuery($sql);
$totalquantity = mysql_result( $result, 0, 0);[/code]

In the general case, use mysql_fetch_assoc(), and iterate properly.

Share this post


Link to post
Share on other sites

×

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.