CodeIgniter Forums

Full Version: database SHOW TABLES
You're currently viewing a stripped down version of our content. View the full version with proper formatting.

El Forum

[eluser]Unknown[/eluser]
Hi,

I would like to add an functionality to dbutils for showing all tables for selected database. I'm trying to use similar like in list_databases() function. Data retreived was not contain tables for database. If I try in (SHOW TABLES FROM database_name) phpmyadmin it works properly. Any idea?

Thanks

Marek

El Forum

[eluser]xwero[/eluser]
Maybe the user you added to your database.php config file is not granted to see other databases?

El Forum

[eluser]Unknown[/eluser]
User for mysql database is root, so I suppose ho could do everything Smile.

El Forum

[eluser]xwero[/eluser]
you can use db->list_tables, i did't read your post right the first time.