Human readable alphanum.

[PureEvil]

Trying to pull a ton of data from a database that I would like ordered by a number that has been assigned to that data by the end user. IE 1,2,3,4,5,6

 

I'm using mysql_query("SELECT * FROM BLEH WHERE BLEH='BLEH' ORDER BY NUM ASC");

 

now when it prints out I get 0,1,10,11,12,13,14,15,16,17,18,19,2,20

 

I need to have it read as 0,1,2,3,4,5,6,7 etc etc...

 

Ideas?

 

Thanks in advance...

 

Me.

[kenrbnsn]

Is the field defined as a character (varchar, text, char) or a number? If it is a character that is the correct ascii sort, to get what you want, make the field a number (int).

 

Ken

[PureEvil]

Is the field defined as a character (varchar, text, char) or a number? If it is a character that is the correct ascii sort, to get what you want, make the field a number (int).

 

Ken

301458[/snapback]

 

 

I thought of that but I need it to be alphanumbaric.

 

because it might end up being A1, A7, A2 someday

 

[tharagleb]

So how do you want it to sort these values:

 

1,11,2,20,A1,A20,A2 ?

 

If you have these values you *have* to do an alpha sort. If I were you I would make the field numeric and forget about what it *might* be in the future. Either that or left zero fill your data before sticking it into the database:

 

0001

0011

0002

00A1

 

Etc.

 

Good luck.

[PureEvil]

this was solved by changing ORDER BY NUM to ORDER BY (NUM+0)

 

the varchar field didnt have to be changed...

 

Thanks for the help.

[ryanlwh]

this was solved by changing ORDER BY NUM to ORDER BY (NUM+0)

 

the varchar field didnt have to be changed...

 

Thanks for the help.

301492[/snapback]

but that wouldn't work with A10...