how to import tables and their respective fields from mysql ??

[PHPycho]

Hello forums !!
I am wondering to know-
how to import name of the tables and their respective fields(ie name of columns not the values) from the database of mysql ?? (obviously using php)

Awaiting for your great help.
Thanks in advance to all of you.

[Piranha]

I think the best thing you can do is to google for a tutorial to understand the basics. You can of course also look in the database part of these forums, there are tons of code that show how to do this, although most of it is in code parts of other problems.

If you need more specific help when you have done this please don't hesitate to post again.

[bradgrafelman]

So you want a list of tables in a certain database, and then you want a list of columns for each of those tables?

If so, SHOW TABLES should give you the list of tables, and SHOW COLUMNS should give you column information for each table.