--- careers.php 2001/03/12 14:01:50 1.8 +++ careers.php 2001/03/18 23:36:26 1.9 @@ -35,7 +35,7 @@ } } } elseif ($part == "OpenPositions") { - $sth = $dbh->prepare("select num,title,job_code,department,location,description,edu_req,qual_req from open_positions where visible is true order by num asc"); + $sth = $dbh->prepare("select num,title,job_code,department,location,description,edu_req,qual_req from open_positions where visible is true and expiration >= date('now') order by num asc"); $sth->execute(); while ($row=$sth->fetchrow_hash()) { $positions[]=$row;