[amykhar]

assuming that you have been counting the profile views, it's simple.

Select profileviews as profileviews from user order by profileviews DESC;

That will order them from highest to lowest. You just grab as many as you need then. If you only need the top 5 or so, you can add a LIMIT 5 at the end.

If you haven't been incrementing that field when somebody looks at a user's profile though, that query won't do anything for you.

Amy