How can i sort mysql records by year/month/week?
Posted on 2007-10-17
Hello. I made an events system, i add the event in the database with the following fields: id, title, content, date. And on the site i have 3 buttons: week's events, month's events and archive. What i want to do is first to build the archive button, to display year, after i click the year to display the months, after i click the month to display the weeks and after i click the week to list events by title. If i make this i think i can make week's events and month's events by myself. I appreciate your time and i wait for feedback. Thanks in advance.