Averages based on information from a database

[-Karl-]

I have a table called members, in it I have

 

usernameurlattack

 

An example would be

myusernamewww.google.com99

anotherusernamewww.phpfreaks.com95

 

What I want to do is calculate averages. So select all the information from the members table.

 

Then group the result by their url, and carry out a calculation. The calculation would be easy. Add up all the levels (attack), divided by the amount of users with that url.

 

I'm not sure how to go about getting the data and splitting it however, then I'd carry out the calculation and echo the highest number, followed by the clanurl.

 

Any ideas?

[Mchl]

SELECT url, AVG(attack) FROM members GROUP BY url

[-Karl-]

Oh wow, there's a MySQL function for it? I should do more research. Thanks a lot.

[-Karl-]

Umm, how would I select the max from this result, and the clanurl appropriate to the max?

[Mchl]

SELECT url, AVG(attack) AS attack FROM members GROUP BY url ORDER BY attack DESC LIMIT 1