[Paul M]

Originally Posted by TheSpecialist

For the standings, I don't want it to display people who havn't played any games, or there would be an extra thousand people in there inbetween the good/middle and the lower scored players.

The you should be using OR, not AND - otherwise someone who has never won (or never lost) will not be displayed.

Personally, I would use this ;

[sql]DB_site->query("SELECT * FROM user WHERE wins>0 OR losses>0 ORDER BY rating DESC");[/sql]