ORDER BY doesn't like numbers.
Posted: Sat Nov 09, 2002 4:50 pm
I have a MySQL database table with one of the colums names ID.
I do a mysql_query and ORDER BY id.
I'm not getting the expected result as mysql seems to be treating the numbers as strings.
I get something like this..
1, 10, 11, 2, 3, 31, 33.. and so on.
Is there any thing I can do about this?
Thanks for your time.
I do a mysql_query and ORDER BY id.
I'm not getting the expected result as mysql seems to be treating the numbers as strings.
I get something like this..
1, 10, 11, 2, 3, 31, 33.. and so on.
Is there any thing I can do about this?
Thanks for your time.