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 -> URL

how the flash calendar looks (with the old system)-> URL

how the (old) php conversion was done -> URL

what the flash format looks like -> URL

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...

Good luck

http://freshmeat.net/projects/date_calc/