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