Blue
White
Purple
Green
Red
Orange
Blue Light
White Light
Purple Light
Green Light
Red Light
Orange Light
Hihow to make a list that only displays the SELECT DATE, for exemple 09-01-2010 to 09-15-2010This is the tableSELECTupcomingevent.EventID,upcomingevent.userID,upcomingevent.StartDate,upcomingevent.EndDate,upcomingevent.EventSubject,upcomingevent.EventDetail,upcomingevent.StatusFROM upcomingeventPlease HelpThanks
any body help
You need to add a WHERE clause to your SQL query in order to restrict date range.http://www.google.com/search?q=mysql+slect+date+range&ie=utf-8&oe=utf-8&aq=t&client=firefox-a&rlz=1R1GGGL_en#hl=en&client=firefox-a&hs=OU1&rlz=1R1GGGL_en&&sa=X&ei=Z2SGTKTeAoGClAfJ0pHsDg&ved=0CBIQvwUoAQ&q=mysql+select+date+range&spell=1&fp=d331bd8e2d0de10c