top ten referrers

[doobster]

Hi what would be the best way to make a list of the top 10 referrers.

My members will be promoting a page for me. So in my table it will record which user id referred the person and where the person was referred from.

So when user id 1 logs in, i want to display user ids 1 list of his top ten referrers.

The table has the following fields. uid, ip, time, referrer.

any help appreciated.

[planetsim]

you should add to the table hits. So if they have been referred by a page thats already been done you update it. else insert a new row for them.

Then its just a simple SQL query

"SELECT * FROM mytable WHERE uid = '$uid' ORDER BY hits DESC LIMIT 10"