ASP Page, Microsoft SQL Server database
I have a music club SQL Server database with 7 true/false fields in each record indicating whether a club is open each day of the week. For example: Monday – False, Tuesday – False, Wednesday – True, Thursday – False, Friday – True, Saturday – True, Sunday – False.
From this data, I need a dropdown (HTML Select box) displaying the dates the club is open for the next 3 weeks, based on the current date, and in correct order. For example, with the days …