RE: [PHP-DB] Get MySQL table schema for a dump

Ok, that works great. Now, what is the best way to echo the result. For example $connection = mysql_connect("localhost","u","p"); mysql_select_db("killerspin_com", $connection); $sql = "SHOW CREATE TABLE update_list"; $result_id = mysql_query($sql,$connection); then what, if (mysql_num_rows($res...)) ??? or while ($rows = mysql_fetch_array()...) ???? ---> Jonathan -----Original Message----- From: John W. Holmes [mailto:holmes072000@charter.net] Sent: Wednesday, February 26, 2003 9:49 PM To: jvilla@isdesigndev.com; php-db@lists.php.net Subject: RE: [PHP-DB] Get MySQL table schema for a dump > Is there was to get a database's table schema? > > For example, I want to be able to click on a link and then create a .txt > file of a table (or even better a databases) schema. > > So far, I have a simple function which will output > > INSERT INTO table (x,x,x,) VALUES(x,x,x); > INSERT INTO table (x,x,x,) VALUES(x,x,x); > INSERT INTO table (x,x,x,) VALUES(x,x,x); > INSERT INTO table (x,x,x,) VALUES(x,x,x); > etc. > > but what I'm missing is > > CREATE table blah, blah, blah > > **that is what I want to get. SHOW CREATE TABLE <table_name>; ---John W. Holmes... PHP Architect - A monthly magazine for PHP Professionals. Get your copy today. http://www.phparch.com/