Jump to content

Archived

This topic is now archived and is closed to further replies.

PureEvil

Human readable alphanum.

Recommended Posts

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.

Share this post


Link to post
Share on other sites

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

Share this post


Link to post
Share on other sites
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

 

Share this post


Link to post
Share on other sites

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.

Share this post


Link to post
Share on other sites

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.

Share this post


Link to post
Share on other sites
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...

Share this post


Link to post
Share on other sites

×

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.