Hi there,
I have a small database, with a table called rooms, in that table is a range of field, one called status ... the status field is either "0" or "1" and is 1 by default ... if the field is set to 1 then it shows as BUSY on the main page, or "0" is EMPTY etc ... I have my PHP for someone manually to change the room status all working fine etc ...
But what i'd like to know is, with PHP/SQL is it possible to create a small add-on that would let a user specify a time such as 22:00 and then at that time, the status auto changes from 0 to 1 etc ...
Do you think that's possible? Would the time entered need to be stored in another table of some kind?
Thanks
Ben