Find names of every table in a DB using PHP

[bubbles19518]

Hey,

I have a database where each username has their own table, and Im making it so that instead of a ba-zillion tables, there will be just two. But I need a way to find the names of every table in my MySQL DB. I searched google and came up empty handed. Anyone know how I can do this?

[Fumigator]

Execute the following query:


SHOW TABLES FROM databaseName


MySQL manual Reference:

http://dev.mysql.com/doc/refman/4.1/en/show-tables.html