MySQL Question

[Jake McHenry]

I know this isn't the right place for this, but I'm hoping someone can help me out.  I have created a database, basically an online calendar, and I have the following fields in my table..   id  int(10)  auto_increment year  int(4) month  varchar(10) day  int(2) time  varchar(5) ampm  char(2) event  varchar(255)   Where I'm running into a problem is on the output screen. I've tried sorting by day, time, and ampm, and all of these, but I'm still running into the same problem. The problem is that an entry of time 10:00 am is coming before 10:00 pm, it's because of the 1 in the entry, I think. Anyway, can anyone tell me how I can get the entries to be listed in sequential order by time and ampm?   I've also tryed putting the year, month, day, and time into a datetime field, but I still have the same problem.   Thanks, Jake