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 = SHOW CREATE TABLE update_list; $result_id = mysql_query($sql,$connection); then what, if (mysql_num_rows($res...)) ??? or while ($rows = mysql_fetch_array()...) There's only one row... $row = mysql_fetch_row($result_id); echo $row[0]; or echo mysql_result($result_id,0); ---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
RE: [PHP-DB] Get MySQL table schema for a dump
I never thought of mysql_fetch_row. What I ended up using was $row = mysql_fetch_array($result_id); echo $row[1]; I'll probably use fetch_row as it makes more sense. Thanks. --- Jonathan -Original Message- From: John W. Holmes [mailto:[EMAIL PROTECTED] Sent: 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 column. 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()...) There's only one row... $row = mysql_fetch_row($result_id); echo $row[0]; or echo mysql_result($result_id,0); ---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 -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
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
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:[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