So here's the issue - all other PDO queries are working fine, but this one is giving me trouble. I've tried using
execute(array(':t'=>$table));
but no luck. Any ideas?
public function __construct($table){
try{
$pdocnx = new PDO("mysql:host=localhost;dbname=sigcat",'root','');
$stmt = $pdocnx->prepare('select * from sigcat.:t');
$stmt->bindParam(':t', urldecode($table), PDO::PARAM_STR,45);
$stmt->execute();
$row = $stmt->fetchAll(PDO::FETCH_ASSOC);
var_dump($row);
}catch(Exception $e){
echo $e->getMessage();
}
}
I have a lot of records in 'supplies', but when I run the query it returns array(0) { }. I'm fetching the 'table' parameter using $_GET['table']. No exceptions are being thrown though.