PDO bindParam() with multiple named parameters
mysql, pdo, php, prepared-statement, sql
Solution
See PDO::prepare
You cannot use a named parameter marker of the same name twice in a prepared statement
Problem
Can't PDO bind a value to multiple occurrences of a param in a query with a single bindParam()? I'm surprised, I thought it was possible, but I didn't find any info on php's docs on this, neither on the web. Any clarification / alternative is welcome! Note : I'm using php 5.3.6 / 5.3.8 (dev/prod) Example : Consider this prepared statement : ``` INSERT INTO table VALUES (:param1, 0), (:param1, 1); ``` Now, if I bind values to my query: ``` bindParam(":param1",$my_param1); ``` I have a PDO error : SQLSTATE[HY093]: Invalid parameter number