bendavies2k Posted September 24, 2009 Share Posted September 24, 2009 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 Link to comment https://forums.phpfreaks.com/topic/175425-change-status-with-specified-time/ Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.