10 before 2

meghatronic · 6 Jul 2007 at 00:11

In my php/mysql, the order is coming literally: 1, 10, 11, 2, 3.... Is there an easy way to prevent this? it is most annoying.

meghatronic · 6 Jul 2007 at 11:35

ORDER BY won't return a natural order.

Augmented said:
There's also natsort() for sorting a PHP array (of strings) as you want.

Worked. I had to change the order of my functions though, cheers!

meghatronic · 6 Jul 2007 at 12:33

It's not an ID column, it's a string e.g. sausage7, I'm sorting by the numbers on the end - but thanks though!

meghatronic · 6 Jul 2007 at 13:05

No - I'm already working on a restructuring, this was just an interim solution. As you pointed out, the more mysqlness... the less phpness which is better and quicker.