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:[EMAIL PROTECTED] 
Sent: Wednesday, February 26, 2003 9:49 PM
To: [EMAIL PROTECTED]; [EMAIL PROTECTED]
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/




-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

Reply via email to