tristeve

Hoping I can get some advice/pointers here. I've inherited a fairly basic MySQL where the date of an event is stored in 3 fields: day [tinyint(2)] - example: 19 month [varchar(20)] - example: November year [year(4)] - example: 06 I'm having no problems retrieving all events from the database, but I'd like to somehow sort them in ascending order from today's date. Thanks in advance, Steve