Gossamer Forum
(Advanced Search)
for
Home : General : Internet Technologies :

Ordering MySQL Numerically

Feb 27, 2006, 8:53 AM
JoFrRi
User (81 posts)
JoFrRi's avatar
Feb 27, 2006, 8:53 AM
Post #1 of 3
Views: 4618
Shortcut
Quote Reply
Ordering MySQL Numerically
Is there anyway to order a MySQL Query numerically? I'm grabbing a list from my database and ordering it according to "chapter number". When displayed, I get an "alphabetical" list which doesn't work out:

1
10
2
3
4
5
etc.

I need 10 to come after 9 and 20 after 19, etc.
Any help, much appreciated.
Feb 28, 2006, 6:26 PM
Alex
Administrator (9387 posts)
Feb 28, 2006, 6:26 PM
Post #2 of 3
Views: 4456
Shortcut
Quote Reply
Re: [JoFrRi] Ordering MySQL Numerically In reply to
Hi,

Make sure your column type is a numeric type, not a char or varchar.

Cheers,

Alex
--
Gossamer Threads Inc.
May 6, 2006, 5:40 PM
JoFrRi
User (81 posts)
JoFrRi's avatar
May 6, 2006, 5:40 PM
Post #3 of 3
Views: 4342
Shortcut
Quote Reply
Re: [Alex] Ordering MySQL Numerically In reply to
lol so simple. Thanks that was my problem.