|
James Simon
|
November 25, 2013 at 8:33 am
I have modified espresso table so that it returns the data and takes users to an alternative registration page. However, I need to be able to modify the SQL so it only returns DISTINCT class names. Anotherwards if I have a class where it is running for 20 different dates I only want it to be returned once. The reason is the alternative registration page will show all the dates that they can pick from.
Does anyone know how to modify the SQL so it returns DISTINCT events based on name of class?
|
|
James Simon
|
November 25, 2013 at 9:46 am
Figured it out. For anyone interested I guess you don’t use DISTINCT in mysql it is GROUP BY.
SELECT e . *
FROM wp_events_detail e
WHERE e.is_active = ‘Y’
AND e.start_date >= ‘2013-11-25’
AND e.event_status != ‘S’
AND e.event_status != ‘D’
GROUP BY (
e.event_name
)
|
