Order mysql output by date

[phingoc]

Hi.

 

How can i order the news that gets viewed by date? newest first.

 

<?php
include ('mysql_connect.php');
$query = "SELECT id, title, author, post, DATE_FORMAT(date, '%M %d, %Y') as sd FROM news_posts";
$result = @mysql_query($query);

if ($result) {
while ($row = mysql_fetch_array($result, MYSQL_ASSOC)) {
$url = 'comments.php?id='.$row['id'];
echo '<p><b>'.$row['title'].'</b><br />
'.$row['sd'].'<br />
Skrevet av : <b>'.$row['author'].'</b><br /><br />
'.$row['post'].'<br /><br />
<a href="javascript:openComments(\''.$url.'\')">Legg til eller les komentarer.</a></p><br /><hr>';
}
} else {
echo 'Det er for tiden ingen nyheter';
}
?>

 

[Maq]

http://dev.mysql.com/doc/refman/5.0/en/sorting-rows.html

[phingoc]

thanks.. changed this line

 

"SELECT id, title, author, post, DATE_FORMAT(date, '%M %d, %Y') as sd FROM news_posts ORDER BY DATE DESC";

[Maq]

thanks.. changed this line

 

"SELECT id, title, author, post, DATE_FORMAT(date, '%M %d, %Y') as sd FROM news_posts ORDER BY DATE DESC";

Sure no problem, so is everything working for you now?  If so, you can mark this topic solved.