Table Names in a Chronologically descending table

[ArizonaJohn]

Hello,

 

I think the query below returns the names of the last 25 tables added to the MySQL database "bookfeather."  How would I print these 25 table names out in a 1-column, 25-row table, with the table names descending from the most recently created on top down to the 25th-most recently created on the bottom?

 

Thanks in advance,

 

John

 

 

$index = mysql_query("select TABLE_NAME from INFORMATION_SCHEMA.TABLES where TABLE_SCHEMA='bookfeather` order by CREATE_TIME desc limit 25");

[smerny]

Hello,

 

I think the query below returns the names of the last 25 tables added to the MySQL database "bookfeather."  How would I print these 25 table names out in a 1-column, 25-row table, with the table names descending from the most recently created on top down to the 25th-most recently created on the bottom?

 

Thanks in advance,

 

John

 

 

$index = mysql_query("select TABLE_NAME from INFORMATION_SCHEMA.TABLES where TABLE_SCHEMA='bookfeather` order by CREATE_TIME desc limit 25");

 

echo "<table>";
$index = mysql_query("select TABLE_NAME from INFORMATION_SCHEMA.TABLES where TABLE_SCHEMA='bookfeather` order by CREATE_TIME desc limit 25");
while ($row = mysql_fetch_array($index))
{
  echo "<tr><td>".$row['TABLE_NAME']."</td></tr>";
}
echo "</table>";

 

although with one column you don't really need to use tables

 

[ArizonaJohn]

It says:

 

Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource