Re: [PHP] suming up in MySQL

2001-09-11 Thread David Otton 

On Tue, 11 Sep 2001 11:51:05 +0200, you wrote:

 How to sum up all the values from a MySQL row ex.
id - price
1 1000
2 300
3 200

How to sum up price row ?

SELECT SUM(price)

unsurprisingly enough...

djo


-- 
PHP General Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]

Re: [PHP] suming up in MySQL

2001-09-11 Thread Andrew Perevodchik 

TM id - price
TM 1 1000
TM 2 300
TM 3 200

TM How to sum up price row ?

This can be done by MySQL rather than PHP.

mysql_query ("SELECT SUM (price) FROM table");

-- 
Andrew Perevodchik
[EMAIL PROTECTED]


-- 
PHP General Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]