[SOLVED] Number of tables in a DB

[ballouta]

Hello

kindly I need some help

 

How can I get:

1) number of tables created in a specific Database

2) their names

 

thank you

 

[trq]

Take a look at mysql_list_tables().

[obsidian]

Take a look at mysql_list_tables().

 

FYI, as the manual suggests, the function is deprecated, but you can still run a mysql_query() function call:

SHOW TABLES FROM db_name

[ballouta]

Hi

the SHOW TABLES FROM db_name is working

 

how do i loop and print the tables names?

 

thank you

[obsidian]

Hi

the SHOW TABLES FROM db_name is working

 

how do i loop and print the tables names?

 

thank you

 

You actually don't need the "FROM" clause, since you would have already selected a DB to use. Try this:

<?php
$sql = mysql_query("SHOW TABLES");
while ($row = mysql_fetch_row($sql))
{
  echo $row[0] . "<br />\n";
}
?>

 

Hope that helps.

[ballouta]

Thanks alot