order mysql results problem

Questions about the MySQL, PostgreSQL, and most other databases, as well as using it with PHP can be asked here.

Moderator: General Moderators

Post Reply
User avatar
potato
Forum Contributor
Posts: 192
Joined: Tue Mar 16, 2004 8:30 am
Location: my lovely trailer, next to the big tree

order mysql results problem

Post by potato »

i have a mysql query, where i want to sort the results by score.
But if 2 scores are the same, he sort by the order the lines where inserted in the table.
How can i make such a query where he first looks the score & if the score is the same, he order by name.

somebody can help me?
Unipus
Forum Contributor
Posts: 409
Joined: Tue Aug 26, 2003 2:06 pm
Location: Los Angeles, CA

Post by Unipus »

ORDER BY score, name
User avatar
potato
Forum Contributor
Posts: 192
Joined: Tue Mar 16, 2004 8:30 am
Location: my lovely trailer, next to the big tree

Post by potato »

thax
Post Reply