date_format: sorting problem?!?

[EdMeister]

When I'm using following code to get my date in European format (dd-mm-yyyy), my records get messed up. They are sorted mathematically (or alphabetically if you wish) instead of chronically.

E.g. :
12-09-2002
31-10-2001
29-02-1998
this would be the normal order, but instead, the following happens to me:
31-10-2001
29-02-1998
12-09-2002
...

Code:
<?php
$nieuw_SQL = "SELECT nieuw_header,date_format(nieuw_date,'%d-%m-%Y') as
nieuw_date FROM nieuw ORDER BY nieuw_date DESC LIMIT 5";
$nieuw_result = mysql_query($nieuw_SQL);

while($nieuw = mysql_fetch_array($nieuw_result)) {

echo $nieuw['nieuw_date'];
?>
&nbsp;
<?php
echo $nieuw['nieuw_header'] ?>
<br>
<?php
}
?>

Does anyone have a solution? Thanks in advance!

[examancer]

once you date_format() the date, mysql only understands it as a string, so you should return that string (which I changed to nieuw_date_eu for european) as you did, but order by the original date format, which mysql understands.

another way of doing this would be to change the ORDER BY to ORDER BY nieuw.nieuw_date to specify the column instead of the date_format result.

hope this helps:

<?php 
$nieuw_SQL = "SELECT nieuw_header,date_format(nieuw_date,'%d-%m-%Y') as 
nieuw_date_eu FROM nieuw ORDER BY nieuw_date DESC LIMIT 5"; 
$nieuw_result = mysql_query($nieuw_SQL); 

while($nieuw = mysql_fetch_array($nieuw_result)) { 

echo $nieuw['nieuw_date_eu']; 
?> 

<?php 
echo $nieuw['nieuw_header'] ?> 
<br> 
<?php 
} 
?>

[EdMeister]

Thx! That did the job!
Really appreciate it!
EdM.