MySQL Query Error: 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
bitPublish = 1 AND
dtmPubDate <= CURDATE() AND
(dtmExpDate >=' at line 14
Query: SELECT
DATE_FORMAT(MediaLibrary.dtmPubDate, "%W, %M %e, %Y") AS PubDate, DATE_FORMAT(MediaLibrary.dtmEventDate, "%b %e, %Y") as eventDate,
MediaLibrary.*,
Users.strFirstName,
Users.strLastName,
Users.strBio
FROM
MediaLibrary
LEFT JOIN
Users
ON
MediaLibrary.intAuthorID = Users.intUserID
WHERE
intMediaID = AND
bitPublish = 1 AND
dtmPubDate <= CURDATE() AND
(dtmExpDate >= CURDATE() OR dtmExpDate IS NULL)