PDOStatement::execute(): SQLSTATE[HY093]: Invalid parameter number

So I’m trying to build a query string based on user input.

So if certain fields are filled out, additional conditions are added to the string.

Here’s what I’ve built up

[code]
SELECT * FROM `mytable` WHERE (rowID IN (:varA) OR row2ID IN (:varB)) AND DATE(:entryDate) BETWEEN ‘:startDate’ AND ‘:endDate’ ORDER BY DATE(entryDate) DESC
[/code]

I’m getting the follow error

>

**Warning**
> : PDOStatement::execute(): SQLSTATE[HY093]: Invalid parameter number: number of bound variables does not match number of tokens in
> **/home2/public_html/mysite/search.php**
> on line
> **116**

When I log this

[code]
error_log($stmt->debugDumpParams() );
[/code]

I get this

>

SQL: [212] SELECT * FROM `table` g WHERE (rowID IN (:varA) OR row2ID IN (:varB)) AND DATE(entryDate) BETWEEN ‘:startDate’ AND ‘:endDate’ ORDER BY EntryDate DESC Params: 4 Key: Name: [7] :varA paramno=-1 name=[7] “:varB” is_param=1 param_type=2 Key: Name: [7] :varB paramno=-1 name=[7] “:hTeamB” is_param=1 param_type=2 Key: Name: [10] :startDate paramno=-1 name=[10] “:startDate” is_param=1 param_type=2 Key: Name: [8] :endDate paramno=-1 name=[8] “:endDate” is_param=1 param_type=2

I’m build the where clause, then entering into the rest of the $SQL string, doing the PDO prepare line and then adding in the params.

Also in #PHP _↴