Dropdown Displays Available Dates Based on Database Fields
Project ID: 1329946729
Project Details
- Status: Closed (Chosen Programmer: vryllesche; Paid; Rated 10 out of 10)
- Posted: 2/22/2012 at 16:38 EST
- Closed: 2/23/2012 at 2:54 EST
- Project Creator:
- Budget: N/A
- Description: 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 of the week and true/false status described above, and beginning today (February 22nd), the dropdown would show, in order,
February 22
February 24
February 25
February 29
March 2
March 3
March 7
March 9
March 10
The dates must only show current and future dates, not dates previous to the day the viewer is coming into the site. - Tags:
| Project Bids |






