I've been successful in creating a BIG calendar and linking a highlighted calendar event to the actual event. I figured that out and it works fine.
My problem is that I am not able to crack how to setup date portion of the SMALL calendar so that when a highlighted event date is clicked it links to the date of the events. My database date is formatted YYYY-MM-DD with a field name of events.eventdate using php. The date is pushed to the showdetailsS.php page as Date=15/05/2005. I could use some help in writing the sql for my showdetailsS.php page. I need to change the database date format to match the EventCalendar’s format and I have tried everything. Here is what I have so far:
SELECT *,date_format(eventdate,'%d/%m/%Y') as eventdate FROM events WHERE
I also noticed that when the SMALL event calendar pushes the DATE the url looks like this:
showdetailsS.php?date=12%2F01%2F2013&dwzMONTHShows=1&dwzYEARShows=2013
Is that correct?
Thanks for any help you may offer in advance, Rudy
|
|
|