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

Thursday, 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 col

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. > For example > > $connection = mysql_connect("localhost","u","p"); > mysql_select_db("killerspin_com", $connection); > $sql = "

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

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]; [E

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

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

on 2/26/03 6:23 PM, Jonathan Villa at [EMAIL PROTECTED] appended the following bits to my mbox: > but what I'm missing is > > CREATE table blah, blah, blah Here you go: SHOW CREATE TABLE $tablename; HTH. Sincerely, Paul Burney Q: Tired of creating admin interfaces t

[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,) VA