SELECT *, DATE_FORMAT(pubdate,'%M %d %Y') as prettydate FROM content WHERE catID=999 AND pubdate<=CURDATE() AND (runto='0000-00-00' OR runto>=CURDATE()) ORDER BY pubdate DESC LIMIT 1
SELECT *, DATE_FORMAT(pubdate,'%M %d %Y') as prettydate FROM content WHERE catID=999 AND pubdate<=CURDATE() AND (runto='0000-00-00' OR runto>=CURDATE()) ORDER BY pubdate DESC LIMIT 1
Leave a Reply