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

    Join Date
    Oct 2000
    Posts
    3
    Rep Power
    0
    i am making a web calendar, and i now want to implement recurring events. I store the events in a database, and i wonder if someone could suggest the best way to find out if a recurring event occurs at a certain date.
    Could this be done by a mysql select query?



    ------------------
    yiorgos
    http://geocities.com/sinteknos
  2. #2
  3. No Profile Picture
    Contributing User
    Devshed Newbie (0 - 499 posts)

    Join Date
    May 2000
    Location
    Alkmaar, The Netherlands
    Posts
    123
    Rep Power
    14
    It probably is, but it depends on how you defined your table and especially how you defined the recurring events in you DB.



    ------------------
    Good luck,
    Bas

    ------------------
    E-mail me at: b.vandermeijden@pecoma.nl
  4. #3
  5. No Profile Picture
    Junior Member
    Devshed Newbie (0 - 499 posts)

    Join Date
    Oct 2000
    Posts
    3
    Rep Power
    0
    actually, i each event has an interval (days) in which it occurs, and is marked if it is recurring. I would be interested to hear suggestions.

    ------------------
    yiorgos
    http://geocities.com/sinteknos
  6. #4
  7. No Profile Picture
    freebsd
    Guest
    Devshed Newbie (0 - 499 posts)
    "man 1 cal" might help.
  8. #5
  9. No Profile Picture
    Junior Member
    Devshed Newbie (0 - 499 posts)

    Join Date
    Oct 2000
    Posts
    3
    Rep Power
    0
    in php&mysql please.

IMN logo majestic logo threadwatch logo seochat tools logo