$totalRows in a query

[tom_oliverj]

Hi guys,

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.

echo $row_rs_rating['SUM(rate)-($totalRows_rs_rating)'];

The query is as follows

SELECT SUM(rate), employer
FROM `rate`
WHERE employer = 'col1'
GROUP BY employer

Thanx again

Tom

[spikeZ]

Try

SELECT SUM(rate)as rate, employer
FROM `rate`
WHERE employer = 'col1'
GROUP BY employer

along with

echo $row_rs_rating['rate']-$totalRows_rs_rating; 

See what happens

[jito]

try counting feedback when feedback =0 using count()

[r937]

note: if you use a WHERE clause to restrict the employer to one value, you don't need GROUP BY

try this:

SELECT SUM(rate)            as positive
     , COUNT(*) - SUM(rate) as negative 
  FROM `rate`
 WHERE employer = 'col1'

then just display the columns called positive and negative

[tom_oliverj]

Thats magic, thanx guys

Tom