=:status and lower(term) = :search order by term asc EOS; $termstmt=$dbh->prepare($termnamesql); $termstmt->execute(array(":status"=>"0",":search"=>$search)); $terms=array(); $row=$termstmt->fetchObject(); $id=$row->id?$row->id:0; if ($id) { header('location: /list.php?id='.$id); } else { header('location: /index.php'); }