Re: total (slightly OT)
| From: | Richard Lynch | Date: | Sat, 06 Jul 2002 06:27:07 +0000 |
| Subject: | Re: total (slightly OT) | ||
| Groups: | php.general | ||
| Request: | Send a blank email to php-general+get-105835@lists.php.net to get a copy of this message | ||
>
>Hey everyone,
>Am working late as usual before the weekend and so I fear i'm a bit braindead!
>Anyway,heres my problem
>I have fields named "total" and "avg" and no idea how many records....
>how do I get the total and average?
>Do I use a function?
select sum(foo), average(foo), count(foo) from my_table
http://mysql.com
--
Like Music? http://l-i-e.com/artists.htm