Re: [PHP] MySQL Schema

This will give you the description $table = 'table_name'; $sql = "desc $table"; $r = mysql_query(); while($row = mysql_fetch_assoc($r)) { echo implode(' :: ',$row); } This will give you the dump: $mysqldump = '/usr/local/mysql/bin/mysqldump'; $dump = `$mysqldump -u $user -p $pa

Re: [PHP] MySQL Schema

Hmmhow you mean schema? you can always list all databases then recurse into tables and fields and display them as however you want! see: mysql_list_dbs(), mysql_list_fields(), mysql_list_tables() <[EMAIL PROTECTED]> wrote in message [EMAIL PROTECTED]">news:[EMAIL PROTECTED]... > Hi, > > Is t

[PHP] MySQL Schema

Hi, Is there any way in PHP to print out the schema of my database tables? Cheers Ade -- PHP General Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]