Order BY

[ollmorris]

Hi everyone.

I was updating my content on my local site and I noticed a weird thing. I have a simply query along the lines of "SELECT * FROM table ORDER BY order_id ASC". Order_id is a field I use which can be changed so that records can vary in the order they are displayed. Trouble is when I get passed 10 records it no longer works. The order is as follows:

1,
10,
2,
3,
4,
5,
6,
7,
8,
9.

Does anyone know what can be done to stop this?

[mrhappiness]

ollmorris wrote:

Does anyone know what can be done to stop this?

don't use varchar as column type but a numeric type like int...

[TobyRT]

I'd be inclined to agree - it's happening because it's not seeing it as a number

It thinks one is the same as 10. The way it will work normally is if the other numbers are also two digits ie
01
02
03
04
05
06
07
08
09
10

[ollmorris]

Yeah I will try that. I should have said it was a varchar column type.

Thanksa lot guys

[ollmorris]

Yep you guys were spot on. Thanks a lot.