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 'in-one-day.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=Turnover-of-40-million-in-one-day.jpg