Foreach Table in a Database -- Is it possible?
Posted: Fri Apr 11, 2008 8:54 pm
Is it possible to do some sort of query of a foreach on a database? Selecting every table name in the database?
A community of PHP developers offering assistance, advice, discussion, and friendship.
http://forums.devnetwork.net/
Code: Select all
if (!function_exists('mysql_list_db_tables')) {
function mysql_list_db_tables($database) {
$tables = Array();
$results = mysql_query('SHOW TABLES FROM ' . $database);
while($row = @mysql_fetch_assoc($results)) {
$tables[] = $row['Tables_in_' . $database];
}
return $tables;
}
}