|
|
| You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 4 SELECT COUNT(*)
FROM events
JOIN eventmembers ON(eID = emEventID)
WHERE ePublished = true AND eEndTime > NOW() AND emMemberID = |
|
My reservations
| Date Time |
Title / Type |
Location |
Age Group |
Details |
Status |
| You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'AND ePublished = true
ORDER BY ePosted DESC' at line 7 SELECT eID, eStartTime, eTitle, eCity, eLocation, eZipcode, eWomenAgeFrom, eWomenAgeTo, eMenAgeFrom, eMenAgeTo, eStatus,
(SELECT COUNT(CASE WHEN mGender = 'Male' THEN true ELSE NULL END) FROM members WHERE mID IN(SELECT emMemberID FROM eventmembers WHERE emEventID = eID)) AS male,
(SELECT COUNT(CASE WHEN mGender = 'Female' THEN true ELSE NULL END) FROM members WHERE mID IN(SELECT emMemberID FROM eventmembers WHERE emEventID = eID)) AS female,
CASE WHEN ePublishPhotos = 'No' THEN 0 ELSE (SELECT COUNT(epID) FROM eventphotos WHERE epEventID = eID) END AS photosCount
FROM events
JOIN eventmembers ON(emEventID = eID) WHERE eEndTime > NOW() AND emMemberID =
AND ePublished = true
ORDER BY ePosted DESC |
|
|
|
