[Resolved] Change order of display

[chriswheat]

Hello,

I want to display

id3
id2
id1

currently the following script displays
id1
id2
id3

<?PHP
include ("db_connection.php");
$sql = mysql_query("SELECT * FROM pi_news");

if(mysql_num_rows($sql) > 0) {
while($row=mysql_fetch_array($sql)) {
$title = $row['title'];
$id = $row['id'];
echo "<a href=\"pi_news.php?id=".$row['id']."\">".$row['title']."<br>";
}
}
?>

Any ideas?
Chris

[csousley]

$sql = mysql_query("SELECT * FROM pi_news order by id asc");

ascending = asc
decending = desc (or none in most cases)

Hope this helps

[chriswheat]

Many thanks!!