Guys, tell me, please, how can php find out the names (name) of database tables?

    3 answers 3

    $res = mysql_query('show tables'); 

    Study the mysql manual.

       $q = mysql_query("SHOW TABLES FROM `table`;"); 

        Standard remedy:

         select table_name from information_schema.tables where table_type = 'base table' and table_schema='имя базы' 

        Will work everywhere except Orakla. :-)