>
> 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