--- community.php	2001/02/21 15:52:31	1.2
+++ community.php	2001/02/22 20:51:10	1.3
@@ -31,7 +31,7 @@
 	$sql_where.="and id=$id";
 }
 
-$sth = $dbh->prepare("select id,title,date,body,pic from news $sql_where order by id desc");
+$sth = $dbh->prepare("select id,title,date,body,pic from news $sql_where order by date desc");
 $sth->execute();
 while ($row=$sth->fetchrow_hash()) {
 	$data[]=$row;