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:
ashneet 0 Junior Poster
Sp!ke 13 Light Poster
The name of a MySQL table should be private, there is no way to display it, as it is a security risk.
ashneet 0 Junior Poster
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.
Troy 35 Posting Whiz
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.
ashneet 0 Junior Poster
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.