Hi
Is there a way to use bind placeholders also for table names and for column names?
$sql = 'insert into '.$DB->Param('a').' (col1) values ('.$DB->Param('b').')';
$stmt = $DB->Prepare($sql);
$stmt = $DB->Execute($stmt,array('table','value'));
The above code will generate an sql such as this:
insert into 'table' (col1) values ('value')
The embracing apostrophes of 'table' causes an error.
Any ideas?
Thanks in advance |