Displaying Table Names and Column Names...

I looking to make a web interface for mySQL hooked up to ODBC. What I want to be able to do is select a database in dsn and then use SQL to return:

(all table names)
->(all table's column names)

Is there a way of doing this?

Thanks,

Terry Scott

I might be completely misunderstanding what you're trying to do but is it:

SHOW TABLES
SHOW COLUMNS FROM tablename

?

Nope you're right on. I thought it was something like that.

Thank you.