Group and sum

[Anon]

Hi I would like to know how I can use a Field called "Form" to group "NoOfSheets" and total each one (Form and NoOFSheets are in the same table)

For example form 1 5000
form 2 4000
form 1 2000

I want to see total form 1 7000
total form 2 4000

$Slip = mysql_query("SELECT SUM($NoOfSheets) AS Total FROM Slip WHERE QuoteNumber=\"$QuoteNumber\" ");
$row = mysql_fetch_array($Slip);
$Total=$row["Total"];
echo"$Total";
Thanks
Carmine

[[deleted]]

use the GROUP BY clause to group the results by whatever you need. Sum() operations are then performed on each group selerately, and you get one result for each group.

SELECT Form, sum(noOfSheets)
FROM table
[WHERE statements]
GROUP BY Form;