I have single database with multiple tables named, c1, c2, c3, and so on. I'm trying to access a certain table with the following query:
PHP Code:
$query="SELECT * FROM c'$id'"; 
in which $id determines which table to access.

This throws "Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource".

I've also tried it two other ways:
PHP Code:
$query="SELECT * FROM c.'$id'"; 
PHP Code:
$query="SELECT * FROM c+'$id'"; 
Is it possible to do this, or is there another way to get around it?

Thanks.