RE: [PHP-DB] Get MySQL table schema for a dump
| From: | John W. Holmes | Date: | Thu, 27 Feb 2003 17:14:05 +0000 |
| Subject: | RE: [PHP-DB] Get MySQL table schema for a dump | ||
| References: | 1 | Groups: | php.db |
| Request: | Send a blank email to php-db+get-25962@lists.php.net to get a copy of this message | ||
> 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/