Hello, yes I've thought of using less fields, separated by commas, but I'd like to use much more SQL queries than PHP to process the result.
I have one question : if I go the RestTimes route, that is having a row per day and so 7 row per restaurants : can I, in one SQL request, know if THAT restaurant is open or close now ? I now there are NOW() function in SQL and probably many others, but I am not at ease to use them since I have pretty basic SQL skills. How can I make a query that would return as well an extra field with a boolean flag (open/close) ? Cheers, Damien > -----Message d'origine----- > Have you thought about storing just M/T/W/etc and then storing > the Opening, > Closing times as a comma delimited string? Maybe like > > Monday: 11AM,1PM,5PM,1AM > Tuesday 10AM,1PM,6PM,12AM > > You'll only need 7 fields. --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
