MYSQL select date format query

[eluser]learning_php[/eluser]
I copyed can pasted it again but get another error:

A PHP Error was encountered

Severity: Notice

Message: Undefined property: stdClass::$date

Filename: views/homepage_view.php

Line Number: 70


Here is what I have and line 70 is <h1>&lt;?=$row->date?&gt;</h1>


&lt;?PHP
$sql="select news, DATE_FORMAT(date, '%d%m%y') FROM news";
$Q = $this->db->query($sql);
?&gt;

&lt;?PHP foreach ($Q->result() as $row):?&gt;
<h1>&lt;?=$row->date?&gt;</h1>
<h1>&lt;?=$row->news?&gt;</h1>
<hr />
&lt;?PHP endforeach;?&gt;