a-z now z-a sql

[sheephat]

Dear Fellow PHP Users,

I am once again in need of your assistance. I have a script on my site which lists the tables for a database, of course my script does more than this but I want to make my explanation as basic as possible.

In my script I have the SQL query “SHOW TABLES FROM dbase”

This lists the databases and it all work perfectly. But it lists them in alphanumerical order 123...789abc..xyz

Is there any way I can change this sql to reverse the order so that the table that would usually be at the bottom is now at the top.

Many thanks
Sheephat

[laserlight]

I am guessing that this is from MySQL? Not sure if any other vendor uses SHOW TABLES. Anyway, the answer is no for MySQL. Just retrieve all, place them in an array, then use [man]array_reverse/man.

[sheephat]

Yes MYsql, and Damn

Oh well ill give the array a go if not ill just have to make do.