tags:

views:

112

answers:

1
Q: 

PDO Parameterized Query - Reuse named placeholders?

In essence, I have a value that I have to call a couple times in my SQL query. Thus, is it possible to reuse the same named placeholder in the statement e.g. SELECT :Param FROM Table WHERE Column = :Param, then simply bindValue(":Param"), and have the value be there for both :Params?

A: 

PDO::prepare states that "you cannot use a named parameter marker of the same name twice in a prepared statement", so I guess that's a no then.

gamers2000  2010-03-15 07:56:30

related questions

How do I tell Apache which PHP to use?
PDO MySQL Driver on Mac
Named parameters, caching and PDO
How can I convert all values of an array to floats in PHP?
How can I implement commit/rollback for MySQL in PHP?
How do detect that transaction has already been started?
List of PDOStatement::bindParam data_type parameters
Is it possible to rewind a PDO result?
PDO try-catch usage in functions
How to change character encoding of a PDO/SQLite connection in PHP?
Can one convert a MySQL connection to a PDO connection?
Why is PHP PDO DSN a different format for MySQL versus PostgreSQL?
PDO Prepared Statements
Can PHP PDO Statements accept the table name as parameter?
What PHP / MySQL drivers or Database Abstraction Layers Support Prepared Statements?
How do I loop through a MySQL query via PDO in PHP?
Error with bindParam overwriting in PHP
Are PDO prepared statements sufficient to prevent SQL injection?
Installing PDO-drivers for PostgreSQL on Mac (using Zend for eclipse)
SQLite/PHP read-only?
How do you do fuzzy searches using bound parameters in PDO?
How do prepared statements work?
SQL Pagination
Persistent DB Connections - Yea or Nay?
mysqli or PDO - what are the pros and cons?