sum?

How can I do this. I keep getting an error.

SELECT * , SUM( quantity ) AS totalsum
FROM table

SUM() is an aggregate function used with a GROUP BY clause - which you do not have. Read the manual http://dev.mysql.com/doc/mysql/en/group-by-functions.html

Try this..

SELECT SUM( quantity ) AS totalsum
FROM table

pohopo wrote:
Try this..
SELECT SUM( quantity ) AS totalsum
FROM table

Yes, if all he wanted was the total sum of all rows in the table.

But the inclusion of SELECT *, SUM( .... leads me to believe that he's after more than that.

And it's better for someone to read the manual and learn for themself than for us to just write the code.