January 3rd, 2002, 11:07 AM
range of dates for mysql to flash calendar using php
I have a database that stores records of calendar events that can range in length (eg- from jan 02 to feb 13).
I have a flash web interface that takes in specifically formatted date variables (eg- “&01022002=on this day we go to the park”).
The interface between the two formats the entry. Previously each record from the db could not be a range of dates so it was easy to format. Now, I have to figure out a way to overlap different ranges of dates so it will work.
Can anyone tell me if this has been done before in a similar application I could look at or else point me in the right direction?
some links for reference:
how the mysql db looks -> http://18.104.22.168/gapacc/calendar/
how the flash calendar looks (with the old system)-> http://22.214.171.124/gapacc/cal.htm
how the (old) php conversion was done -> http://126.96.36.199/gapacc/cal.php
what the flash format looks like -> http://188.8.131.52/gapacc/cal.txt
January 5th, 2002, 09:53 AM
This sounds like a tall order from a pre written script or api. However if you haven't looked at the following date api, it might be worth checking out (although to be honest I've never used it and don't think it actually does exactly what you want anyway!). Might make your life easier though perhaps...