[Resolved] Show Tables Question

kenhess

Is there a way in show tables (MySQL) to order that show in any way, like an ASC or DESC???

Or if not in the query...how about the presentation?

stolzyboy

you could give this a read, it will get you thinking in the right direction

http://www.php.net/mysql_list_tables

kenhess

The page you referred me to says don't use that function because it is deprecated.

stolzyboy

no, it says that

mysql_listtables()

is deprecated, not

mysql_list_tables()

notice the extra "_" in the second function

kenhess

ah, subtle difference.

but list_tables doesn't give me any advantage over what I am doing...still listing rows from the db as

while ($row = mysql_fetch_row($result)) {
print "Table: $row[0]\n";
}

which is the same way I do it now with sql that says show tables.

I still need some way of ordering the list that is returned.

barand

Could put them in an array, sort then print.

$tables = array();
while ($row = mysql_fetch_row($result)) { 
   $tables[] = $row[0]; 
}
sort ($tables);
foreach ($tables as $table) {
   echo "Table : $table<br>" ;
}

kenhess

You are the man! You old Cheshire Cat!!!

sort and rsort will do the trick.

many thanks.

Marking it resolved.