Cacher is the code snippet organizer for pro developers

<?php
// Open connection to db

$db_connect = mysql_connect("db_host","username","password");
mysql_select_db('db_name',$db_connect) or die("!!!");

// Get tables and loop thru and drop

$num_tables = mysql_list_tables('db_name');

while($row = mysql_fetch_row($num_tables)) {
$delete_table = mysql_query("DROP TABLE IF EXISTS $row[0]");
	if($delete_table) {
		echo 'Successfully removed ' . $row[0] . '<br>';
	} else {
		echo 'Unable to remove ' . $row[0] . '<br>';
	}
}

// Free result set and close db connection

mysql_free_result($num_tables);
mysql_close($db_connect);
?>