Hi guys,
I know this question isn't specifically CI related, but I hope you'll endulge me a little.
I have two tables:
evenementen:
evenement_id INT (Primary, A_I)
evenement_begindatum DATE
evenement_einddatum DATE
evenement_begintijd VARCHAR(5)
evenement_eindtijd VARCHAR(5)
evenement_vrijwilligers
evenement INT (Primary)
vrijwilliger INT (Primary)
gedeclareerd BOOL
I am trying to get all events where a specific volunteer has gone to, as long as that volunteer has not made a claim for the travel allowance for that event yet. And as long as the event has not been more than 2 months ago. I have the folowing Query, but with the DATE_SUB() part of the query, I get 0 results. Even though I should be getting 2 in this case.
Code:
SELECT
evenementen.evenement_naam,
evenementen.evenement_begindatum,
evenementen.evenement_begintijd,
evenementen.evenement_einddatum,
evenementen.evenement_eindtijd
FROM
evenementen
JOIN
evenement_vrijwilligers
ON
evenementen.id = evenement_vrijwilligers.evenement
WHERE
evenement_vrijwilligers.vrijwilliger
AND
evenement_vrijwilligers.vrijwilliger = 1
AND evenement_vrijwilligers.gedeclareerd != 1
AND
evenementen.evenement_einddatum >= DATE_SUB(NOW(), INTERVAL -2 MONTH)