I am trying to write a calendar/archive script like the archive calendar featured on scripting.com. I want the user to click on the date in the calendar and query the database for all articles written that day.
The calendar passes the date as $archivedate to the query function.
How do I perfrom this query:
SELECT from stories WHERE date = $archivedate
My problem is that the column date has the format 2001-11-18 12:23:32 but archive date is only 2001-11-18?
I understand LIKE is very slow and should be avioded.
Any ideas?
The calendar passes the date as $archivedate to the query function.
How do I perfrom this query:
SELECT from stories WHERE date = $archivedate
My problem is that the column date has the format 2001-11-18 12:23:32 but archive date is only 2001-11-18?
I understand LIKE is very slow and should be avioded.
Any ideas?