watch out mysql (or whatever db you have) for SUM() and AVG functions, 
make sure you understand what a GROUP BY clause is.


> 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?
> I know this is pretty simple but.....
> Any help appreciated,
> -Kim.



LoRd, CaN yOu HeAr Me, LiKe I'm HeArInG yOu?
lOrD i'M sHiNiNg...
YoU kNoW I AlMoSt LoSt My MiNd, BuT nOw I'm HoMe AnD fReE
tHe TeSt, YeS iT iS
ThE tEsT, yEs It Is
tHe TeSt, YeS iT iS
ThE tEsT, yEs It Is.......

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

Reply via email to