order tables by date in PHP

runelore

Hi, I know the following code works in retrieving an array of the tables in a given database..

$posts_result=mysql_query("show tables from $board");

That is the code I use...

what I need to do is order that list of tables by teh date they were created.. please help. I am not sure how to do this..

thanks... -Mo

trooper

The sql you will need is

Show table status from db_name;

That will then return a lot of meta data about the tables in the db

One of these pieces of meta data is the creation date.

HTH

runelore

wow thanks.. I will try it then will nee dto figure out how to use it to order the tables... cheers again...

runelore

Now I am stuck, I can get the dates that the tables were created but howcan I factor that in to ordering the tables. the only way I can think of is to retrieve all the tables dates then put that into an array, organise it that way and then output the data. sounds quite incorrect, is this how I would do it..?? can I not use some kind of an order command within the MYSQL call to order hte tables by creation date..??

trooper

Ok so you can get the dates - well then you will need to convert them into a common format e.g unix timestamp and then you will be able to order them according to that value

HTH