-2

i have a query here, and I am trying to sort the order they output by the column "rank", what would i add to my query exactly to do this? here is my code:

$query = $pdo->prepare('SELECT * FROM leaderboards WHERE game_id=2 AND mode_id=1 and map_id=15 LIMIT 0, 100'); 
1

2 Answers 2

2

If you want to order by a specific column, use the ORDER BY clause.

$query = $pdo->prepare('SELECT * FROM leaderboards WHERE game_id=2 AND mode_id=1 and map_id=15 ORDER BY rank LIMIT 0, 100'); 
Sign up to request clarification or add additional context in comments.

Comments

1

you even can use more that one field to sort, See below

$query = $pdo->prepare('SELECT * FROM leaderboards WHERE game_id=2 AND mode_id=1 and map_id=15 ORDER BY rank, rank2 LIMIT 0, 100'); 

Comments

Start asking to get answers

Find the answer to your question by asking.

Ask question

Explore related questions

See similar questions with these tags.