RE: row totals

2002-04-09 Thread Craig Vincent
> I need to know how many total reviews are in my table for each category > name, im using this query and it doesn't work: > > SELECT SUM(name) AS articletotal WHERE category = 'Processors' Try SELECT count(name) AS articletotal FROM tablename WHERE category = 'Processors' Sincerely, Craig Vi

row totals

2002-04-09 Thread Alex Behrens
Hey Guys, What is the command to add up the amount of rows in a total? I need to know how many total reviews are in my table for each category name, im using this query and it doesn't work: SELECT SUM(name) AS articletotal WHERE category = 'Processors' mysql Thanks! --