> On Sep 13, 2008, at 10:05 PM, Vaibhav Informatics wrote:
> > Please let me know if there is a simple method to total up the  
> > column values
> > in Mysql database tables using php as in excel.
> I believe what you are looking for is count(fieldname)

COUNT returns the number of rows.  I think they're after SUM

SELECT SUM(price) WHERE available = 1;

would total the values in the returned row's price column

Niel Archer

PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

Reply via email to