...

View Full Version : Find names of every table in a DB using PHP



bubbles19518
01-25-2007, 09:05 PM
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
01-26-2007, 12:50 AM
Execute the following query:



SHOW TABLES FROM databaseName


MySQL manual Reference:

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



EZ Archive Ads Plugin for vBulletin Copyright 2006 Computer Help Forum