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:
, COUNT(persons) AS total_persons
JOIN activity_dates AD
ON AL.activity_id = AD.activity_id
JOIN activity_participants AP
ON AL.activity_id = AP.activity_id
JOIN participants P
ON AP.participant_id = AD.participant_id
AL.activity_id = 'Url.activity_id'
AD.activity_date = ?????
What would be the right format?
since this is mysql, you should use the STR_TO_DATE function