Из mysql не выводится дата!

Question

Код:
$query = "SELECT id, title, DATE_FORMAT(date, '%d %M %Y'), content
FROM article
ORDER BY id DESC
LIMIT ".$start.", ".ITEMS_PER_PAGE;
$res = mysql_query( $query );

echo " ";

while($prd = mysql_fetch_array($res)){
echo "". $prd['title'] ."

". $prd['content'] ."

". $prd['date'] ."
";
}

Тип строки: DATE
Помогите пожалуйста решить данную проблему! Заранее спасибо!!!!

Наталья Дёмина · Accepted Answer

$query = "SELECT id, title, DATE_FORMAT(date, '%d %M %Y') AS date_formated, content
FROM article
ORDER BY id DESC
LIMIT ".$start.", ".ITEMS_PER_PAGE;

....

echo " ";

while($prd = mysql_fetch_array($res)){
echo "". $prd['title'] ."

". $prd['content'] ."

". $prd['date_formated'] ."
";
}