Simple online booking system for Beautician?

I would probably use the unix time stamp for the date and time of the appointment as a unique id to store the appointment in the database. That way no double booking. Simplest front-end approach would be to just have a couple of select list's to chose date and time. Put those in a form that posts the info to the server, and then convert the info into a unix time stamp, and check the db to make sure this time is available. Return true for available and false if not. If true, save a new appointment to db and send confirmation. Taken one step farther, you should check the date every time the page loads and query the db for all appointments that day. Use the info to construct the drop downs for that day and remove the times she is not available.

Once you get all that up and running you could go back and pretty up the front end using a jQuery calendar library and AJAX for the form submission. However, I would start simple and work your way up to the more complicated UI.

Yea that was a really good responce Andrew. My girl works in a salon doing nails and all of her friends do hair, skin or nails as well. I could do this for them at the salon as a side project and have something to put in my portfolio.