Dropdown Displays Available Dates Based On Database Fields

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 …

Leave a Reply

Your email address will not be published. Required fields are marked *