|
-
Oct 19th, 2005, 01:02 PM
#1
Thread Starter
Fanatic Member
[RESOLVED] [PHP and MYSQL] I need help with ORDER BY command
Hello, I need help as fast as possible. I have my game I programmed in VB to sent the high score to my webserver and add it to a table. That works. My php page pulls the information correctly, almost. I have it sorting the entires by the Score so I can show placing, 1st, 2nd, ect.
$sql = "SELECT Name,Score,Level,DateTime FROM $table_name ORDER BY Score DESC";
My problem is that it puts the score of 600 before the score of 5420, since 6 is bigger than 5. Can someone please help me get this to sort by largest to smallest, so the scores go something like...5000, 4000, 3000 no like 60, 5000, 4000.
Thank you.
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|