Ordering by a number column

@damon2003Nov 12.2003

Hi,
I am querying a database and and returning the results ordered by a column that contains codes(numbers).
However, the results are not being ordered as I want. I get something like this:

1
10
11
2
3

Its only ordering on the first digit. Does anyone know how to resolve this?
thanks

to post a comment

PHP

@Khalid_AliNov 12.2003 — #you may want to use ASCENDING aor DESCENDING commands as well in addition to the ORDER BY

.you will have to look up the corrrect syntax in MySQL for ASCENDING or DESCENDING

@pyroNov 12.2003 — #

[code=php]#ascending
 "SELECT fieldname FROM tablename ORDER BY id"; #default is ASC
 #descending
 "SELECT fieldname FROM tablename ORDER BY id DESC";[/code]

@damon2003authorNov 12.2003 — #I actually had ASC in the original and its still ordering only on the first digit of the number.

I just thought maybe its how the database is set up, could it be that the column is a text column, I dont configure the database

@pyroNov 12.2003 — #Yes, if it is a text column it will not work correctly. You want to make sure that you are using a numeric type for the field (I think varchar will also work).

Ordering by a number column

4 Comments(s) _↴

Also in #PHP _↴

Success!

Social

Version

Ordering by a number column

4 Comments(s) ↴

Also in #PHP ↴

Success!

The web is an endless sea of information. Don't miss the boat... Subscribe!

Social

Version

4 Comments(s) _↴

Also in #PHP _↴