Show tables and show fields

I use mysql database and i need to show the tables, the fields and the types of the fields. How do i do it?

http://sunsite.mff.cuni.cz/MIRRORS/ftp.mysql.com/doc/en/SHOW_DATABASE_INFO.html

That link should help. You would then need to pass the results to an array before then merging the array into your template.

A good example of the actual php code you would need -- look at the phpMyAdmin application.

Install it and use it to do MySQL stuff the easy way -- and then learn from their code tp produce the pages you want in TBS.

http://www.phpmyadmin.net/home_page/index.php

HTH