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 'to-clear.jpg' at line 1<br />select *,DATE_FORMAT(created_on,'%a, %D %b %Y %h:%i %p') as created_on2 from tbl_news where news_id=Sri-Lankas-landmines-will-take-a-decade-to-clear.jpg