This task should be fairly simple for experienced PHP programmers.
I need a function written that will look at a MYSQL table that holds "hours of operation" of a particular store. The table is storing the time the store opens and closes by day of the week.
This function needs create a variable that is a time which is the next business day as it relates the current date and to the store hours stored in the database table.
ie. Customer visits website, fills out credit application and the system sets an appointment for the applicant to go to the store roughly 24 hours from time they are filling out the application.
The application system is already set up. All I need is a function that queries the database table to retrieve an appointment time within the business hours of the store.