> >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 -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php