Parametrize the table of a SELECT

[worldworld]

Is it possible to parametrize the table of a SELECT ?

 

      SELECT * FROM $1  # for example.

 

Thank you for any hint or pointers!   

[skali]

Yes certainly you can.

$table = 'users';
mysql_query("select * from $table");

Or in case of table array:

$tables[0] = 'users';
$tables[1] = 'preferences';
$tables[2] = 'blahblah';

mysql_query("select * from {$table[index]}");