MySQL Query Error: Unknown column 'author.php' in 'where clause'<BR><BR>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 = author.php AND
					bitPublish = 1 AND
					dtmPubDate <= CURDATE() AND
					(dtmExpDate >= CURDATE() OR dtmExpDate IS NULL)