PHP/PDO: Prepared statements don't work when creating a table?

Abdul Nealious

New Member
When I am using a PDO prepared statement, and use it to plug in a table name to the query it fails, a quick example:\[code\]$stmt = $dbh->prepare("CREATE TABLE ? (id foo, int bar,...)");$stmt->execute(Array('table_foobar'));\[/code\]All it does is replaces \[code\]?\[/code\] with \[code\]'table_foobar'\[/code\], the single quotes don't allow creation of the table for me!I end up needing to do a \[code\]sprintf\[/code\] on TOP of the prepared statement to add in a predefined table name.What on earth am I missing here?
 
Back
Top