bpottle
-
Posts
2 -
Joined
-
Last visited
Never
Posts posted by bpottle
-
-
I've got the business hours of several locations that need to be stored in a MySQL database. I'll be using php to display a list of these locations and an image based on whether they are open or closed to indicate such. I figured "hey, this'll be simple," and threw together a table looking something like "sid, sunOpen, sunClose, monOpen, monClose, etc..." planning to simply write a script that got time(); in 24-hour format, checked it against the open and close hours in the database, and display the appropriate image.
...but then I realized that some of the locations are open past midnight on the weekends.
I'm having a real mindblock on this... what would be the most efficient way to do this in a way that accommodates places open into the early hours of the next day?
--Ben
Showing "Open" or "Closed" based on hours in a db?
in PHP Coding Help
Posted
This was easy to code, but i've tried half a dozen times to explain what it does and I can't lol it's hard to explain.
*snip*
[/quote]
Aha! It makes perfect sense! Thanks for your help, this is exactly what I was trying to do :-D
--Ben