What I am trying to do is show a "Top 5" on my website. I have a database which each entry has a username and a int column. The int column refers to how many people they have referred... i want to be able to show the top 5 depending on the # of that int column.

So basically:

#1: Name has Reffered 10 people
#2: Name has Reffered 9 people
#3: Name has Reffered 8 people

and so on...

SELECT username, refercount from table ORDER BY refercount ASC LIMIT 5;

Perfect. thanks!!