I need a query for populating a activity/participant list for printing. The list is feeded by two url variables:
activity_id and activity_date
The format (through my serverside scripting) for the activity_date in the drop down is:
dd mmm, yyyy
I only have know idea how to translate the Url.dateformat in to the right format in the where clause in my query. This is what I have so far:
What would be the right format?Code MySQL:SELECT AL.activity_id , AL.activity_name_home_language , AD.activity_date , AP.bookings_number , P.persons , COUNT(persons) AS total_persons , P.first_name , P.last_name , P.telephone FROM activity_list AL INNER JOIN activity_dates AD ON AL.activity_id = AD.activity_id INNER JOIN activity_participants AP ON AL.activity_id = AP.activity_id INNER JOIN participants P ON AP.participant_id = AD.participant_id WHERE AL.activity_id = 'Url.activity_id' AND AD.activity_date = ?????