Could anybody give me a little advice as to how I would search the table names from 1 database within a SQL PHP query.

At present this is my not working code.

I have a database named classified with a list of genres ie `computers` `clothes` `cars` `music` etc etc. Within each table is. I'd name price etc etc. I have all that processing correctly and I can use the data in my webpage but I'm a little stuck on the searching. Here's my query code:

```
Select * from $dbname WHERE $results LIKE '%$search%'

```