I think this is mostly a syntax problem but I'm not sure. I have the following code on my page which is attempting to show the number of negative feedback a user might have. Posative feedback has a value of 1 and negative feedback 0. Therefore Total Rows Minus the Sum of Ratings gives the number of negative results.
The query is as follows
Thanx againCode:SELECT SUM(rate), employer FROM `rate` WHERE employer = 'col1' GROUP BY employer