Ok, that works great. Now, what is the best way to echo the result.
Just like the result from any other query. The query returns a result of
one row and one column.
For example
$connection = mysql_connect(localhost,u,p);
mysql_select_db(killerspin_com, $connection);
$sql = SHOW CREATE
, February 27, 2003 11:14 AM
To: [EMAIL PROTECTED]; [EMAIL PROTECTED]
Subject: RE: [PHP-DB] Get MySQL table schema for a dump
Ok, that works great. Now, what is the best way to echo the result.
Just like the result from any other query. The query returns a result of
one row and one column
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
...))
???
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