How to Format Business Hours of Operation from mySQL Table

[connexsux]

Having looked at other questions that may already have my answer I thought to poise this question for some help. I have a template website for a bunch of business, most of which have the same start and end times - Mon. - Fri., Closed Weekends. BUT, some might close early on Friday, and be open on Saturday. I believe ALL are closed on Sunday.I created a table as such - CREATE TABLE \[code\]Shop_Hours\[/code\] ( \[code\]shop\[/code\] mediumint(8) unsigned NOT NULL default '0', \[code\]d1s\[/code\] time NOT NULL default '08:00:00', \[code\]d1e\[/code\] time NOT NULL default '17:00:00', \[code\]d2s\[/code\] time NOT NULL default '08:00:00', \[code\]d2e\[/code\] time NOT NULL default '17:00:00',... \[code\]d6s\[/code\] time NOT NULL default '00:00:00', \[code\]d6e\[/code\] time NOT NULL default '00:00:00', \[code\]d7s\[/code\] time NOT NULL default '00:00:00', \[code\]d7e\[/code\] time NOT NULL default '00:00:00') ENGINE=MyISAM DEFAULT CHARSET=utf8;Here are a few records:INSERT INTO \[code\]Shop_Hours\[/code\] (\[code\]shop\[/code\], \[code\]d1s\[/code\], \[code\]d1e\[/code\], \[code\]d2s\[/code\], \[code\]d2e\[/code\], \[code\]d3s\[/code\], \[code\]d3e\[/code\], \[code\]d4s\[/code\], \[code\]d4e\[/code\], \[code\]d5s\[/code\], \[code\]d5e\[/code\], \[code\]d6s\[/code\], \[code\]d6e\[/code\], \[code\]d7s\[/code\], \[code\]d7e\[/code\], \[code\]Comments\[/code\]) VALUES(104, '08:00:00', '17:00:00', '08:00:00', '17:00:00', '08:00:00', '17:00:00', '08:00:00', '17:00:00', '08:00:00', '16:00:00', '08:00:00', '12:00:00', '00:00:00', '00:00:00', '');INSERT INTO \[code\]Shop_Hours\[/code\] (\[code\]shop\[/code\], \[code\]d1s\[/code\], \[code\]d1e\[/code\], \[code\]d2s\[/code\], \[code\]d2e\[/code\], \[code\]d3s\[/code\], \[code\]d3e\[/code\], \[code\]d4s\[/code\], \[code\]d4e\[/code\], \[code\]d5s\[/code\], \[code\]d5e\[/code\], \[code\]d6s\[/code\], \[code\]d6e\[/code\], \[code\]d7s\[/code\], \[code\]d7e\[/code\], \[code\]Comments\[/code\]) VALUES(105, '08:00:00', '17:30:00', '08:00:00', '17:30:00', '08:00:00', '17:30:00', '08:00:00', '17:30:00', '08:00:00', '17:00:00', '00:00:00', '00:00:00', '00:00:00', '00:00:00', '');INSERT INTO \[code\]Shop_Hours\[/code\] (\[code\]shop\[/code\], \[code\]d1s\[/code\], \[code\]d1e\[/code\], \[code\]d2s\[/code\], \[code\]d2e\[/code\], \[code\]d3s\[/code\], \[code\]d3e\[/code\], \[code\]d4s\[/code\], \[code\]d4e\[/code\], \[code\]d5s\[/code\], \[code\]d5e\[/code\], \[code\]d6s\[/code\], \[code\]d6e\[/code\], \[code\]d7s\[/code\], \[code\]d7e\[/code\], \[code\]Comments\[/code\]) VALUES(106, '08:30:00', '17:30:00', '08:30:00', '17:30:00', '08:30:00', '17:30:00', '08:30:00', '17:30:00', '08:30:00', '17:30:00', '08:30:00', '14:00:00', '00:00:00', '00:00:00', '');MY QUESTION relates to how to, using classic ASP, query a record and display as some of these examples:Mon. - Fri. 08:00 AM - 5:00 PMClosed WeekendsORMon. - Th. 8:00 AM - 5:00 PMFri. - 8:00 AM - 4:00 PMSat. - 8:00 AM - 12:00 PMORetc... I would think there are multiple ways to do this I am jus curious to know if (A) my database structure is ok? (B). WHat is the most effecient way to get my targeted end result?Sure would appreciate some help on this.