$sql_str = "SELECT emp_name, field2, field3 FROM table1 WHERE emp_id=? AND wkday=?"; $sth = $dbh->prepare($sql_str); $sth->execute($emp_id,$wkday);