if you have a table called "ratings" and a field called "score" in it, then doing this will show you the sum of all the scores:
select sum(score) from ratings; eg, if the scores were 5, 2, 5, 8, and 2 then this sql should return 22 (unless I added it wrong... :/ ) -----Original Message----- From: JohnP [mailto:[EMAIL PROTECTED]] Sent: Friday, August 30, 2002 3:10 PM To: [EMAIL PROTECTED] Subject: Re: [PHP] Average Number For Math Functions I am still very new to PHP so things are still a little foreign to me - what exactly is the SUM finction - I tried to locate one on both the PHP and MySQL site but found nothing! Thanks ~ John "Volve" <[EMAIL PROTECTED]> wrote in message 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 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 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 > > > -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
