[SOLVED] Adding up all the values found in one field

[SirChick]

Ok im trying to work out how to do something along the lines of this:

 

Theres a table with say:

 

item name / user id / quantity

 

now say theres like 7 of these rows in the database. What i want to do is firslty, count how many rows there are and then add up quantity of each of the 7 rows together to equal a total using the userid in a session... is that possible?

 

[AndyB]

count()

sum()

 

www.tizag.com for examples. The manual for details

[SirChick]

thankyou andy!