logic thinking about calendar schedule

[Anon]

I'm pretty good with add/modify/delete stuff where php and mysql are concerned, but now I'm tasked with creating a scheduling system for people on-call.

I'm trying to think of the logical flow that a schedule should take, and the only stumbling block I have so far is displaying a calendar that might have one event stretch up to 4 weeks at a time.

Any suggestions on where to start with such a task? I already have the ability to write items to the database, and for those items to show up. But this requires a user to insert a record for each day... pretty inefficient when you consider they will want to insert items up to 4 weeks in advance.

Any advice or help is greatly appreciated!

[crusty_php]

If this is a non-profit outfit then please see if my site will be of any use.
www.knabba.com

[Anon]

Though I appreciate the offer, I'd rather build code myself instead of ripping down someone else's. That way I not only learn, but can ensure that all security issues are created and handled by me.

martin wrote:

If this is a non-profit outfit then please see if my site will be of any use.
www.knabba.com