--- new.php	2001/02/22 09:51:19	1.3
+++ new.php	2001/02/22 20:51:10	1.4
@@ -47,7 +47,7 @@
 		$sql_where.=" and id=$id ";
 	}
 
-	$sth = $dbh->prepare("select id,title,town_date,body,more,pdf from news $sql_where order by id desc");
+	$sth = $dbh->prepare("select id,upper(title) as title,town_date,body,more,pdf from news $sql_where order by date desc");
 	$sth->execute();
 	while ($row=$sth->fetchrow_hash()) {
 		$data[]=$row;