Calendar control and mysql database revamp for adding events to an event listing website with reoccuring and floating events. Php, Mysql, Javascript experts required.

Calendar control and mysql database revamp for adding events to an event listing website with reoccuring and floating events. Php, Mysql, Javascript experts required. I have an event listing website. It runs on php and mysql. It does not have any crucial data in it yet. Registered users to the site can add social events. Each user can edit/delete the social events they added. Other than date, event information has address, info detail, performer. Each event has 1 or more performers and each performer has additinal info such as performer name, performer website. The performers are added via an Ajax control through 1 form. Here are the things that are required now: ## Deliverables Calendar control and mysql database revamp for adding events to an event listing website with reoccuring and floating events. Php, Mysql, Javascript experts required. I have an event listing website. It runs on php and mysql. It does not have any crucial data in it yet. Registered users to the site can add social events. Each user can edit/delete the social events they added. Other than date, event information has address, info detail, performer. Each event has 1 or more performers and each performer has additinal info such as performer name, performer website. The performers are added via an Ajax control through 1 form. Here are the things that are required now: 1) Events that span multiple days: If they add a single non-reoccuring event that starts March 15th at 10am and ends March 18th 10pm, I want this event to be displayed on March 15th, 16th, March 17th, March 18th as well... 2) Reoccuring events: I want users to be able to add reoccuring events. For example, every Tuesday, starting from March 7th , ending in September 28th from 8pm to 11pm. Right now this is done via dropdowns. you select the beginning and ending day, month, year, and hours and am/pm through dropdowns. and there are also 2 additional dropdowns for: "Reoccur xx number of xxx" xxx is the week/month/year selection to define the period of reoccurence xx is the number of reocurence. That does not work well, and dropdowns require too many "clicks" 3)Floating reoccurence events: I want users adding events to be able to add recorruing events that occur on multiple days (floating events). Every Tuesday and Wednesday, from 8pm to 11pm every week. Or every last Friday and Saturday of every month. So the current date selection for the website is a dropdown, I would like to convert this to a full calendar control. Here are my suggestions: 4) Start date calendar control, end date calendar control: there will be two calendars on the form. 1 to select the start date and hour of the event and 2nd one to select the end date and hour. These are dropdowns now. However I would like to convert these to a a full calendar control. The hour selection does not have to be on the calendar control of course. It can be anything other than a dropdown. Maybe a click and choose list-form. Or it can be a combination of this calendar controls 2 variations below: [login to view URL] (this does not has the hour selection on the calendar but you can select multiple dates) and this, (the first example on the page): [login to view URL] (this has the hour selection but you cannot select multiple dates) 5) Start calendar, end calendar syncronization for convenience: Once a start date is selected on the startdate calendar, the enddate calendar for the ending date will syncronize to a day later than the date that is selected on the startdate calendar, since most events end a day later then the start date this is major convenient. You can see an example here: [login to view URL] The problem with the javascript in this example above is, let's say the end date is 4 days after the start date. We are in March and the event starts on July3rd and ends July 7th. Once you select the start the July 3rd, the end date syncronizes to be set a day later than the start July 4th. Great, so you don't have to browse all the way to July in the end date calendar. But after it syncronizes to July 4th, if you change the end date to July 7th in the end date calendar, that also reversely syncronizes to startdate calendar to July 6th... I don't want the end date calendar to syncrnonize start the calendar. 6) Hour selection: there is also an hour selection and this can be converted to anything except a dropdown. it is preferable to apply #2 to the our selection as well. The hour selection does not have to be on the calendar control of course. It can be anything other than a dropdown. Maybe a list-form. [login to view URL] I want the event addition form to be as easy to use as possible. That means, with the least "mouse clicks" possible. That's why I'd rather display a full dhtml calendar (click and choose date(s) and mark them on the calendar) ,rather than dropdowns or popup windows for these controls. If you can, please give me a quote on these. Thank you. ## Platform XHTML. internet explorer, firefox, safari, apple, mac, pc, linux