Total or Sum

[billcoker]

Hi all,

I have a table named cart with these rows:

cart_id
product_id
product_name
product_price
uid
order_notes

I am trying to get and dispaly to total for all the product_price rows that have the same uid.

But I just can't seem to get it right. Hope someone will not mind guiding the blind 🙂

Thanks,

Bill

[hometoast]

If you just want to get a total right from the database you can run a simple sql query.

$cnn = mysql_connect(host,user,pass);
$sql = "SELECT SUM(product_price) AS total FROM cart WHERE uid=$uid";
$qry = mysql_query($sql,$cnn);
$row = mysql_fetch_array($qry);
print $row["total"];

But if you're displaying the cart to the user, you can increment a variable after printing each item in the cart, then just print that variable at the end.
while($res=mysql_fetch_array($qry)) {
print stuff;
$var+=$res["product_price"];
}
then print $var;

good luck.

[billcoker]

Dan thanks for your help but I seem to be missing somthing.

Here is my code:

<?

$cnn = mysql_connect('','','');
$sql = "SELECT SUM(product_price) AS total FROM cart WHERE uid=$uid";
$qry = mysql_query($sql,$cnn);
$row = mysql_fetch_array($qry);

print $row["total"];

?>

I am getting this error:
Warning: Supplied argument is not a valid MySQL result resource in C:\apache\htdocs\shoptest\total.php on line 6

Line 6 being:
$row = mysql_fetch_array($qry);

Any thoughts. I and under the gun. 🙁

Bill

[billcoker]

Dan,

Ok I got it to work. Thanks so much for your help!

Bill