Re: [PHP] Searching with Date Ranges

2003-09-12 Thread Marek Kilimajer
John W. Holmes wrote: Seth Willits wrote: If I want to show events (records in a MySQL table) for the next 10 days (and I do), what would be the best approach to searching with this range? (The dates in my table are stored as a string in the format /MM/DD.) And change the column type

Re: [PHP] Searching with Date Ranges

2003-09-11 Thread John W. Holmes
Seth Willits wrote: If I want to show events (records in a MySQL table) for the next 10 days (and I do), what would be the best approach to searching with this range? (The dates in my table are stored as a string in the format /MM/DD.) SELECT * FROM Table WHERE event_date BETWEEN NOW()

[PHP] Searching with Date Ranges

2003-09-11 Thread Seth Willits
If I want to show events (records in a MySQL table) for the next 10 days (and I do), what would be the best approach to searching with this range? (The dates in my table are stored as a string in the format /MM/DD.) Seth Willits