The way my calendar is set up depends on the individual month, year, and day being pulled from the database. Then it pulls the individual days events and displays them on the page.
Jake ----- Original Message ----- From: "Dave Reed" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Monday, February 11, 2002 9:18 PM Subject: Re: MySQL Question > > From: "Jake McHenry" <[EMAIL PROTECTED]> > > > > 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 > > Why don't you use the SQL types for dates and times and then MySQL > will give you the correct ordering of times when you do an "order by" > clause. > > Dave > > > > _______________________________________________ > Redhat-list mailing list > [EMAIL PROTECTED] > https://listman.redhat.com/mailman/listinfo/redhat-list > > _______________________________________________ Redhat-list mailing list [EMAIL PROTECTED] https://listman.redhat.com/mailman/listinfo/redhat-list