I'm in the process of integrating an events calendar into a website. I'm really keen to not resort to a pre-made solution as I'm trying to learn the ropes as I go along.
I've managed to get a simple calendar working and highlighting the current day. I also have an events database table that contains event data.
I would like to have every day in the calendar on which an events falls on to become a link that my users can click to go through to a seperate events page. I have a DW recordset returning the data I need but I am stumped as to the procedure for relating the calendar days to the event (if one exists).
My events table has a fromDate field and a toDate field so I would like any event that covers more than one days to be reflected in the calendar.
Any help would be sincerely appreciated, I have included the code below.