Best way to automate a mysql query (PHP or ...)
Posted: Wed May 20, 2009 3:44 pm
I have two process I need to automate.
(1) I need to populate my dbase with an entire month of appointments (rows). Each day has multiple appointments and each week is the same (I have the same appointments EVERY Monday).
(2) Every day, I need the appointments for the next day to be updated as "filled" (a field in my table that specifies the appointment is unavailable) so that I don't get appointments scheduled last minute. So today for example, the appointments for tomorrow would be marked as filled.
What would be the best way to automate these processes?
(1) I need to populate my dbase with an entire month of appointments (rows). Each day has multiple appointments and each week is the same (I have the same appointments EVERY Monday).
(2) Every day, I need the appointments for the next day to be updated as "filled" (a field in my table that specifies the appointment is unavailable) so that I don't get appointments scheduled last minute. So today for example, the appointments for tomorrow would be marked as filled.
What would be the best way to automate these processes?