Jelly and Custard

Getting totals in MySQL

December 21st, 2005

At work recently, I had to grab the sum of totals from multiple rows meeting certain conditions in a mysql table. Rather than get each total and add them in PHP in a loop, I decided to get MySQL to do all the legwork for me:

SELECT sum(amount)
FROM table
WHERE id = '$id'
AND condition = '1'
GROUP BY id;

That should return you a summation of the amount columns for all rows matched in the the WHERE statemtents.

 Add to del.icio.us    Digg this    Technorati

Related Posts:

• MySQL Events
• Dates & MySQL
• ARCHIVE-ing Data in MySQL
• Retrieve valid entries for a MySQL ENUM/SET column
• Count occurence of character (i.e. line breaks) in a MySQL field

Entry Filed under: PHP, MySQL