Mysql('mydb", "SHOW TABLES FROM mydbname") ???

I’m trying to display the tables in my database using $tables = mysql(‘mydb”, “SHOW TABLES FROM mydbname”) but this statement doesn’t seem to behave like selecting records from a table. Does this query return an array of table names? If I use something like $records = mysql(‘mydb”, “SELECT * FROM sometable) everything works fine. There must be something I’m missing about the SHOW query. Thanks Chris Williams