I have array of columns which I want to search from table.
I am looking to use SQL something like :
$columns = array('a', 'b', 'c');
$sql = "select $columns from table";
Is this possible? How can we perform such action?
I have array of columns which I want to search from table.
I am looking to use SQL something like :
$columns = array('a', 'b', 'c');
$sql = "select $columns from table";
Is this possible? How can we perform such action?
A part of it is possible:
$columns = array('a','b','c');
$sql = "Select ".implode(",", $columns) . " from table....";
EDIT
I'm afraid, it is not possible to exclude the table-name! But you can query first all table names and then select from those.