I know this is possible, I just don't know how. First off, I am storing several events in a database (date, time, location, etc.). I want to display all of them on my calendar page (not a problem), but only the events that will happen in the next 2 weeks on the main page. Any suggestions of how I should query for this? I know very little about date formatting. Thank you for any help.

The site I'm working on is ncsudrumline.com if you want to check it out.

Something like this should do the trick - if each record takes up a day

SELECT * FROM `table_name` LIMIT 0 , 14

If you aren't storing a day-by-day (which I would advise) then how are you storing the dates? Are you storing them as a timestamp?

If thats the case then you can generate a timestamp for 2 weeks in the future then plug it into your query as a where clause "WHERE dbtimestamp > $now_timestamp AND dbtimestamp < $later_timestamp".

Originally Posted by Tzunami

Something like this should do the trick - if each record takes up a day

SELECT * FROM `table_name` LIMIT 0 , 14

What if there is more than one event per day?