Jump to content


Photo

SUM rows?


  • Please log in to reply
No replies to this topic

#1 DaVuLf

DaVuLf
  • Members
  • PipPipPip
  • Advanced Member
  • 124 posts

Posted 19 May 2006 - 04:34 PM

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.

Thanks,
DaVuLf

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

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





0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users