[SOLVED] Display the three latest news post?

[phpcode]

I'm trying to create a news system and I want it to display the three latest news post on the front page but I'm not sure how All the news is arranged by an ID number that starts from 0 for the oldest to how ever many news post there is. I also have a date field so if there's a way to arrange by date could someone tell me?

[daveoffy]

you could try this

 

$qry = "SELECT * FROM `news` LIMIT 3 ORDER BY `id` DESC";
$result = mysql_query($qry)'
while($row = mysql_fetch_assoc($result)){
$newstitle = $row['title'];
$news = $row['news'];
echo $newstitle;
echo '<br>';
echo $news;
}

[Amtran]

<?php
$query = "SELECT * FROM news LIMIT 3 ORDER BY date DESC";
$result = mysql_query($query);

while ($row = mysql_fetch_array($result))
{
//etc...
}
?>

 

Dang, you beat me to it Dave! And, yes, like I was going to say, ordering it by the ID field works just as well.

[phpcode]

Thanks got it working.