Order problems.

Hi there all.

I have a script that pulls from a mysql db.

I do a select .. blah. .. order by var1, var2, var3

These are all numbers.

The probem is if I have a vars that look like:

1 14 30
1 4 40

Then I print the results out, the 14 would show as being less then 4.

Anyone know how to get around this?

Thanks.

Just for grins I changed the 4 to an 04 and that worked. Math.. uhg.

Is there a way other then that? I can change all the data to 2 digit but its not my db so I'd rather work around it if possible.

Thanks,

Rob

Take a look at [man]natsort[/man]

edit: PS How are those number fields defined in your database table?

Thanks for the sort func.. I'll see if that might work for me.

They are defined as varchar .. This is normally not my customer. So I am kinda picking at it as I go.

Thanks again,

Rob

is '1 14 30' one field or three fields?

If separate fields, defining as int will sort correctly

They are seperate fields.. (bonking head) .. ya int.. Makes sense.. Damn that math again!

Thanks again. 😃