--- new.php 2001/02/23 15:23:32 1.5 +++ new.php 2001/02/23 15:42:52 1.6 @@ -50,6 +50,8 @@ if (isset($type)) { if ($type == "n") { $sql_where .= " and type='n'"; + } elseif ($type == "e") { + $sql_where .= " and type='e'"; } } @@ -64,8 +66,8 @@ $sql="select id,upper(title) as title,town_date,body,more,pdf, (date-now()::date) as comming - from news $sql_where order by date desc $sql_limit"; -# print "$sql"; + from news $sql_where order by priority desc,date desc $sql_limit"; + print "$sql"; $sth = $dbh->prepare("$sql"); $sth->execute(); while ($row=$sth->fetchrow_hash()) {