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

    Join Date
    Jan 2002
    Posts
    2
    Rep Power
    0

    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 -> http://24.222.74.252/gapacc/calendar/

    how the flash calendar looks (with the old system)-> http://24.222.74.252/gapacc/cal.htm

    how the (old) php conversion was done -> http://24.222.74.252/gapacc/cal.php

    what the flash format looks like -> http://24.222.74.252/gapacc/cal.txt
  2. #2
  3. funky munky
    Devshed Beginner (1000 - 1499 posts)

    Join Date
    Jul 2001
    Location
    UK
    Posts
    1,446
    Rep Power
    15
    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/

IMN logo majestic logo threadwatch logo seochat tools logo