Hi, Friday, August 30, 2002, 3:10:09 PM, you wrote: J> I am still very new to PHP so things are still a little foreign to me - what J> exactly is the SUM finction - I tried to locate one on both the PHP and J> MySQL site but found nothing! J> Thanks ~ John
J> "Volve" <[EMAIL PROTECTED]> wrote in message J> 02d901c24fd5$aba46020$7800a8c0@idiom">news:02d901c24fd5$aba46020$7800a8c0@idiom... >> What database are you using? >> >> MySQL has a SUM function which automatically selects the total of a J> column. >> >> -VolVE >> >> ----- Original Message ----- >> From: "JohnP" <[EMAIL PROTECTED]> >> To: <[EMAIL PROTECTED]> >> Sent: Thursday, August 29, 2002 21:25 >> Subject: Re: [PHP] Average Number For Math Functions >> >> >> > Ok so how do I sum up an entire column in my db? >> > For example if one row is : 1 , the next is 2, and the next is 1 - I J> need >> to >> > have a total of 4 and the be able to divide by the num_rows >> > >> > The problem I ma having is the "inside" row addition >> > >> > >> > >> > >> > "Martin Towell" <[EMAIL PROTECTED]> wrote in message >> > [EMAIL PROTECTED]">news:[EMAIL PROTECTED]... >> > > just sum them up and divide by the count - making sure to deal with a >> > count >> > > of zero >> > > >> > > -----Original Message----- >> > > From: JohnP [mailto:[EMAIL PROTECTED]] >> > > Sent: Friday, August 30, 2002 10:56 AM >> > > To: [EMAIL PROTECTED] >> > > Subject: [PHP] Average Number For Math Functions >> > > >> > > >> > > Ok I looked at all the math functions for PHP but saw no way of >> returning >> > > the average of a set of numbers - I plan on using this for a rating >> > system - >> > > any help? >> > > >> > > -- >> > > John >> > >> > >> > >> > -- >> > PHP General Mailing List (http://www.php.net/) >> > To unsubscribe, visit: http://www.php.net/unsub.php >> > >> Try this replacing field and table as needed $result = mysql_query("SELECT SUM(field) AS fsum, AVG(field) AS favg FROM table WHERE field='whatever'"); -- regards, Tom -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
