Question about "ORDER BY row ASC"...

[zakfox1986]

I have a calender that gets events from a database. The db has a table for each month. I was wondering how to have it export each month and list each event by the day. Here's the structure of each table:

1 - day (as in the date, i.e.: the 22, or 28, etc.)
2 - yyyy (for the year)
3 - event (for the name of the event)
4 - name (of contact person)
5 - email (address of contact person)
6 - other (for additional info)
7 - location (location of event)

so shouldn't I use 'SELECT * FROM mar ORDER BY day ASC' to order the list by the day of the event? I tried this and it seems to list it by alphabet or something. What am I doing wrong? I'd really appreciate your help, very much!

Thanks in advance!

Zak

Let me know if you need any more info, or a clearer explanation, I tend to do a poor job at being clear on my questions, sorry.

[Sxooter]

Sounds like each of those fields is a text / varchar field.

You should abandon this design and store the information for dates / times in the proper field types, specifically, date and or timestamp types.

[zakfox1986]

Thanks, a ton! That did the trick!

Zak