dreamwest Posted April 20, 2009 Share Posted April 20, 2009 Is it possible to select all table names from the database and echo them in a while loop like you can with rows Quote Link to comment https://forums.phpfreaks.com/topic/154848-solved-possible-to-select-all-tables/ Share on other sites More sharing options...
trq Posted April 20, 2009 Share Posted April 20, 2009 mysql_list_tables. Quote Link to comment https://forums.phpfreaks.com/topic/154848-solved-possible-to-select-all-tables/#findComment-814395 Share on other sites More sharing options...
dreamwest Posted April 20, 2009 Author Share Posted April 20, 2009 Sweet. $sql = "SHOW TABLES FROM $dbname"; $result = mysql_query($sql); while ($row = mysql_fetch_row($result)) { echo "Table: {$row[0]}\n"; } Quote Link to comment https://forums.phpfreaks.com/topic/154848-solved-possible-to-select-all-tables/#findComment-814399 Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.