How would i display the table names in my db using php as i only want to display the name of the table and dont want to select any info in the tables. :cheesy:

Recommended Answers

All 4 Replies

The name of a MySQL table should be private, there is no way to display it, as it is a security risk.

ok thx and what i was trying to do is for the admin of the website as i have an field in the admin part that require the name of the table for php to get data for that catagory.

Sp!ke is correct. But of course you could always manually create your own table of table names. It would not be dynamic, but if you don't mind maintaining it for use in your admin app, it would work.

Thanks for helping me i guss i will just have to add it manually as i was hoping it would b easy dynamiclly as my table will change a lot.

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.