affected rows + sum

[sidsel]

If I have a query like this: SELECT SUM(field1+field2) AS mysum WHERE ..something..

The result return one field... mysum, but how do I find out how many rows that was infected?

[liquorvicar]

try:
SELECT COUNT(*),SUM(field1+field2) AS mysum WHERE ..something..

[sidsel]

I already tried that... It gives me an error

[liquorvicar]

what error are you getting?

btw, there was an error in my post, it should have been:
SELECT COUNT(*),SUM(field1+field2) AS mysum FROM table WHERE ..something..