86Stang Posted October 27, 2009 Share Posted October 27, 2009 I'm starting over from this thread. I have a client with a preexisting database with events that each have a start date, end date, recurring marker and recurrence frequency which is either daily or weekly. I need to loop through dates that are selected by the user and show any dates that have an event starting or recurring on that date. As an example: 10-28-09 - event 1 10-29-09 - event 1 - event 2 10-30-09 - event 1 - event 3 - event 4 The database schema is as follows: event_id - smallint(4), auto increment start_date - date -- example= 2009-10-27 end_date - date -- example= 2009-12-15 recurring - char(1) -- example= Y recurs - varchar(10) -- example= Weekly title - varchar(150) -- example= Test Event! Again, I started some code on this in the other thread but I don't think I communicated myself well enough. I'm not looking for someone to write this whole thing for me (in fact there is much more to this that needs built then what I'm asking) but some good solid help would be GREATLY appreciated. Link to comment https://forums.phpfreaks.com/topic/179207-dateevent-display/ Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.