Hi,
I need help in coding a little snippet. The schedule table of MySQL DB has days stored for events in following format:
- Daily
- Weekdays
- Weekend
- Monday
- Tuesday
- Wednesday
- Thursday
- Friday
- Saturday
- Sunday
Column names are: progday1, progday2, progday3, progday4, progday5, progday6, progday7.
If an event occurs daily the value "Daily" is stored into the first column as "Daily".
What I want to do is to on the display page is to recognize such event as occurring on Monday and Tuesday ...... and Sunday.
That is if the value returned from the DB as "Daily", I want to display it in the list of event on Monday and Tuesday and Wednesday ........... and Sunday.
Any assistance would be very much appreciated, thanks!