[SOLVED] ordering table in MySQL with PHP

[SergeantFlash]

I have this code inside a php file:

$query = "SELECT * FROM {$table} order by kills desc LIMIT 0,12"; 

This code orders the rows in the table from highest to lowest by kills. For example:

Name |  Kills

---------------

Bob        300

Joe        230

Mike      50

Rob        50

 

However, some players would get the same amount of kills, how can I make it so, out of the players with the same kills, it orders them from newest to oldest (order them by emp_id, which is a variable I made that automatically increments by one, so the newest submission would have the higher number). So the table would look like this (since Rob was the newest person to play the game):

Name |  Kills

---------------

Bob        300

Joe        230

Rob        50

Mike      50

 

Any help is appreciated. Thanks in advance!

[Barand]

ORDER BY kills DESC, id DESC

[SergeantFlash]

That works great! Thanks a lot Barand!!