Keeping track of dates set on a php calendar

[greens85]

Hi all,

 

I followed a tutorial to get the base of a php calendar done, then added some custom Javascript in order to be able to change the color of the cells.

 

The calendar can be seen here:

 

http://www.education-world.co.uk/Education%20World%20Site/calendar.php

 

The problem is now, that I need to integrate a SQL database to keep track of what was set for certain dates.

 

I'm not sure of how to even begin this, all i need to do is keep track of if the candidate is available, not available or working for a specific day. The calendar is submitted to an email but this means when they return at a later date (availability may change) their previously set availability will have been wiped!

 

I can provide code if needed.

 

Can anyone help me out here, really struggling with this!

 

Many thanks,

 

Greens85