Ordering results by multiple values

["Leigh Blackwell" <leigh@xxxxxxxxxxxxxxx>]

Hi All

I would like to return results from a table and order them according to a
numeric score value and where there score is the same return them
alphabetically by name. Is it possible to do this without creating a temp
table. I have tried a couple of ways but I just get the results twice...

Many Thanks

Leigh

Coda Commerce Ltd



-- 
---------------------------------------------------------------------
Please check "http://www.mysql.com/documentation/manual.php"; before
posting. To request this thread, e-mail mysql-thread60365@xxxxxxxxxxxxxxx

To unsubscribe, send a message to:
    <mysql-unsubscribe-treed=ultraviolet.org@xxxxxxxxxxxxxxx>

If you have a broken mail client that cannot send a message to
the above address (Microsoft Outlook), you can use:
    http://lists.mysql.com/php/unsubscribe.php