--- new.php 2001/02/20 12:53:02 1.1 +++ new.php 2001/02/21 15:52:31 1.2 @@ -27,15 +27,15 @@ $smarty->assign( array ( lpic=>$lpic, lext=>$lext, mpic=>$mpic, Section_title=>$title ) ); -$sql_where=""; +$sql_where="where visible is true"; if (isset($id)) { - $sql_where.=" where id=$id "; + $sql_where.=" and id=$id "; } if (! isset($more) || !file_exists("./news/$more")) { -$sth = $dbh->prepare("select id,title,date,body,more,pdf from news $sql_where order by id desc"); +$sth = $dbh->prepare("select id,title,town_date,body,more,pdf from news $sql_where order by id desc"); $sth->execute(); while ($row=$sth->fetchrow_hash()) { $data[]=$row;