1. No Profile Picture
    Junior Member
    Devshed Newbie (0 - 499 posts)

    Join Date
    Jan 2002
    Rep Power

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

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

    how the (old) php conversion was done ->

    what the flash format looks like ->
  2. #2
  3. funky munky
    Devshed Beginner (1000 - 1499 posts)

    Join Date
    Jul 2001
    Rep Power
    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


IMN logo majestic logo threadwatch logo seochat tools logo