1. Advertising
    y u no do it?

    Advertising (learn more)

    Advertise virtually anything here, with CPM banner ads, CPM email ads and CPC contextual links. You can target relevant areas of the site and show ads based on geographical location of the user if you wish.

    Starts at just $1 per CPM or $0.10 per CPC.

PHP / MySQL for Recursive Calendar Appointments

Discussion in 'PHP' started by koolsamule, Jul 19, 2012.

0
  1. #1
    Hi Chaps,

    Apologies if this topic should be in MySQL...I wasn't sure.

    I'm trying to create a MS Outlook-style Appointment application with Recurrence for a PHP calendar.

    I've got all the same options that Outlook gives, e.g.:

    Daily - every DAY, or every WEEKDAY
    Weekly every X WEEK(S) on X DAYS
    Monthly - on DAY of every X month or Nth DAY of every X MONTH(s)
    Yearly - recur every X YEAR(S) on DAY of MONTH or Nth DAY of every X MONTH(s)

    My question is what is the best way to store the recursive appointment information in MySQL Database (Columns, etc), so I can then use a PHP algorithm to calculate whether an appointment is within a calendar view, or if reminders need to be sent.

    Any advice will be a great help.
     
    koolsamule, Jul 19, 2012 IP