Привет! watch out mysql (or whatever db you have) for SUM() and AVG functions, make sure you understand what a GROUP BY clause is.
пока Альберто Киев [EMAIL PROTECTED] wrote: > 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