PHP script to output the structure of a MySQL database?

[mugs]

Is there something out there already written that will take a MySQL database and output the structure neatly formatted for printing or whatnot? PHPMyAdmin does something similar with the Print View button on the Structure tab, but it only does it for one table at a time. I want to be able to do the whole database at once.

 

[Beau]

I have one that dumps the structure to an XML file. If you knew XSL, you could easily make it output the XML into an HTML page, formatted for printing.

 

[Armitage]

Can you just run the qurey "DESCRIBE tablename" , and do what you like with the output?

 

[Beau]

Here's a small PHP script that dumps it to XML. Here's an example of the output