Ordering tables in descending order?

[Anon]

I'm working on a forum right now and the way I have it set up is every new post creates a new table, and subsequent replies create new values in the newly created table.

So my problem is this - while replies work fine because they naturaly come below the original post, I have a problem order tables instead of fields within the tables.

The only table commands in SQL I know of are:
ADD TABLE
DROP TABLE
SHOW TABLE
ALTER TABLE

But I'm not sure of any way to get this (psuedo code):

SHOW TABLES ORDER BY DESC;

How would I do this?

Ben

[[deleted]]

EEW! tables are meant to HOLD data, not BE data!

What you should do is create one table that holds all the posts and replies for that particular forum.

On phpbuilder, you'd have one table for "general" one table for "database talk" etc.

Then you'd use queries to get the posts and replies to the posts.

[Anon]

I don't think you can do that. You are probably going to have to gather all of the information from SHOW and manipulate it in your PHP code.