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: 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
