When using a date field the values are stored as 2002-02-11 you should be able to query for a specific date (SELECT * FROM myTable WHERE myDate LIKE "2002-02-%" ORDER BY myDate) or query for specific portions of the date using operators like month(myDate) = 02.
HTH > 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. > > 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. _______________________________________________ Redhat-list mailing list [EMAIL PROTECTED] https://listman.redhat.com/mailman/listinfo/redhat-list
