bpottle

[!--quoteo(post=364337:date=Apr 13 2006, 06:06 AM:name=wisewood)--][div class=\'quotetop\']QUOTE(wisewood @ Apr 13 2006, 06:06 AM) [snapback]364337[/snapback][/div][div class=\'quotemain\'][!--quotec--] 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

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