I have just tried to use the date_format in my query and it doesn't
return anything?
Please can anyone see any obvious errors?

$sql="SELECT DATE_FORMAT(post_date,'%W %b %Y'),post_title FROM mytable
WHERE MONTH(post_date) = 7 ORDER BY event_start";

post_date and post_tile are fields in the db.

I think I have found an answer to this!

I have added the "as col3" bit in here. This works now.

SELECT col1,col2,DATE_FORMAT(col3,'%a %d %M %Y') as col3 FROM mytable