help with ordering from bottom up

[Leo_01]

<?

include("--.php");

mysql_connect(localhost,$username,$password);
@mysql_select_db($database) or die("Error : unable to connect to database!");

$query="SELECT * FROM datatable";
$result=mysql_query($query);

$rows=mysql_numrows($result);

mysql_close();

echo "<b>Output</b><br><br>";

$i=0;
while ($i < $rows) {

$id=mysql_result($result,$i,"id");
$title=mysql_result($result,$i,"title");
$notes=mysql_result($result,$i,"notes");

echo "ID : $id<br>Title : $title<br>Notes : $notes<br><br>";

$i++;
}

?>

I am having problems in trying or order it from bottom up.
Can someone give me a clue?

[prpldude]

Try this:

$query="SELECT * FROM datatable ORDER BY COLUMN NAME DESC";

where "COLUMN NAME" is the name of the column you want to sort by

DESC = Descending
ASC = Ascending