Adding DB Values together

[webnoob]

I pull some info out of my DB and store it in a variable called $Price if the user has more than 1 item stored in the DB i want to add the values together, can someone please help.

Thanks in advance

[-Oz-]

in php you could do:

$price=$price + $row['price'] 

where you're fetching an array of the mysql results called row.

In mysql you could:

SELECT sum(price) FROM table WHERE user='$user_id'

[webnoob]

im in your dept, thx.

had to change the mysql code a little to this:

$Result1 = mysql_query("SELECT sum(Price) as Price FROM shoppinglist WHERE UserId = '" . $_SESSION['UserId'] . "'"); 

as you can see i have added "as Price"

Thanks again