ORDER BY desc/asc issue

**kbfirebreather** · 08-06-2008, 07:18 PM

Ok, so I have 5 rows, with a day column and a day set to each row.

it has...10,11,13,20, and 7 in no particular order.

if I do a query on that data, and do

Code:

ORDER BY day DESC

it outputs like this...
7
20
13
11
10

and if I do..

Code:

ORDER BY day ASC

the output looks like...

10
11
13
20
7

I don't want to have to put a leading 0 on 1-9...what can I do to make this work?

**JeremyMiller** · 08-06-2008, 08:14 PM

Sounds like you have the field as a string instead of a number. Check that out. If you're not doing it, then each field type should be chosen for the data that's in there. Some people just make every field a VARCHAR instead of choosing things correctly and then they get errors. (Not saying that that's you, but for those who do do this, then they need to know.)

BTW: Database questions are best asked in the database forum.

**kbfirebreather** · 08-06-2008, 08:18 PM

"BTW: Database questions are best asked in the database forum."

thanks for letting me know, I'm always confused cause of using php with the sql :-x

but regardless...I checked it out, and it was set to text...cause I think I originally was gonna spell out the day with that field, but am now using it as the calendar day of the month.

Before knowing this I decided to have a genius idea of using date(z) to get the day of the year (aug 6th is like..210 or something), and in my query, order by dayYear DESC, year DESC, and that took care of it.

Thanks for the input though...if I hadn't done that, I'm positive your solution would have worked.