PHP Problem - Getting Ranked users from DB

[djmike]

Hi,

I have slowly been building a site and have got a database full of user details. I have produced a script which ranks thems based on a number of things. Each users has their own rank, and rank 1 is the highest. However, I now need to produce a script that just displays the Top 10 people. However, I don't really know where to go on this. This script will be run automatically on a server and I cannot seem to find code that will work. I had this as an idea, but it didn't work:
"
$rankquery = "SELECT * FROM users WHERE rank == 1";
echo("" . $rankquery["user"] ."");
"

Any Ideas?
Thanks

[JPnyc]

SQL doesn't use double ==. Remove one.

[xblue]

Might be also an improvement to execute the query and fetching a result set before trying to display it?

About the query itself, are you after something like

SELECT * FROM users ORDER BY rank LIMIT 10