打印出最近添加的25个表

Question

In the code below, I allow users to add tables to a MySQL database. Is there a way to print out the most recent 25 tables added?

Thanks in advance,

John

$table = mysql_real_escape_string($_POST['name']);

$query = "CREATE TABLE `$table` (id INT(11) NOT NULL auto_increment, site VARCHAR(350) NOT NULL, cat1 BIGINT(9) NOT NULL, cat2 BIGINT(9) NOT NULL, PRIMARY KEY(id), UNIQUE (site))";
$result = mysql_query($query) or die(mysql_error());

Answer 1

select TABLE_NAME
  from INFORMATION_SCHEMA.TABLES
 where TABLE_SCHEMA='your_db_name`
 order by CREATE_TIME desc
 limit 25

This is for MySQL version 5 and above. It will list tables created by your users and you, though.