$sth = $dbh->prepare("SELECT * FROM products WHERE ? IN (prod_name,prod_desc) LIMIT 0,?"); $sth->execute($search_term,$max_recs1); #### DBD::mysql::st execute failed: You have an error in your SQL syntax near ''10'' at line 1 at /home/user/path/to/pages/products.dat line 1826.