German date in phpMyAdmin?
===

I get the date with this code:

    <?php $query = "SELECT `news_id`, `headline`, `category`, `body`, `date` FROM `news` ORDER BY `news_id` DESC"; $news_resource = mysql_query($query) or die(mysql_error()); ?>

The date looks now like this (2012-07-24), but I need it as 24.07.2012

I already searched for a solution and tried things like this:

    $mysql = "SELECT DATE_FORMAT(date, „%d.%m.%Y”) AS date FROM news;";

I don't know where to add this and what I have to change in my old code. Hope you can help.
EDIT: In phpMyAdmin the row is called 'date' and as type i use 'date'...

Bye!