Jump to content


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


SUM rows?

Recommended Posts

Is there a way to select a column in a table and sum all of the values? Like.. if I had a column for transactions, and I just wanted the grand total (irregardless of customer ID or any other value) how would I sum that?

Then, how would I sum it be customer ID (regardless of product ID)?

Any help would be appreciated.


$query = "SELECT type, SUM(price) FROM products GROUP BY type";

$result = mysql_query($query) or die(mysql_error());

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.