Dynamic calendar app

[generalchaos316]

I am designing a website for a new band/artist booking agency. I would like to have a calendar on the site that potential bookers/venues/etc can use to fill their open dates.

It would be nice if they could filter by date/month as well as filter by the bands that they are interested in (I was thinking check boxes so they could check the bands that they want to potentially book.)

I would also like the calendar to automatically default to the correct month so I don't have to edit its page every 30 days as well as purge old dates that are no longer necessary.

Finally, it would be nice if all of the information was in a format/database that I could later use in another web based application. Example: Booking agents call and confirm date X for band Y and enter it in 'the system.' That is immediately visible on the calendar as a date that band Y is no longer available to play.

I know there has to be some language out there that was designed to do exactly what I am talking about (and I also know there is no way in hell it is HTML, lol). What is it? SQL stuff? PHP? Combo? Do tell

[mwa103]

I'd say your best bet would be working with php & mySQL. They work very well together. PHP has many different ways to manipulate dates to get what you want. The best part about using php is that none of your code is visible to the user so it just looks like magic to most of them. There are a lot of good php/mySQL training sites out there (w3schools, php.net, etc..). Also be sure to check out the tutorial section here. There are some really good ones there as well. Good luck with the project, sounds like a really good idea.

-Mike

[generalchaos316]

Awesome, thanks. I'll be sure to post up links to the site when I get it done