Query in order!

[Anon]

Hi, i have a list of users that have visited a site a certain amount of times. I can count them no problem, but how do i get a mysql query to output them in order of the most visited first, list them and stop at say 5?

Any help would be greatly appreciated.

Regards
Julian Chamberlain

[Anon]

Use this SQL:

SELECT * FROM tbl_name ORDER BY numVisits DESC LIMIT 5

Diego