Using php and mysql I'm keeping track of people's availability. Someone's availability can be set to July 6, 3pm to 5:30 pm for example. Of course it could change, so we allow them to change it.
The question is what is the best way to store the info? Should I use two timestamps, and use php to chop them into pieces to re-populate the form fields for modification? Use date/time fields? Use text fields? What is the easiest/most efficient/ and or most common?