>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


Like Music?  http://l-i-e.com/artists.htm

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

Reply via email to