RE: [PHP-DB] Get MySQL table schema for a dump
| From: | Jonathan Villa | Date: | Thu, 27 Feb 2003 17:33:33 +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-25964@lists.php.net to get a copy of this message | ||
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:holmes072000@charter.net]
Sent: Thursday, February 27, 2003 11:14 AM
To: jvilla@isdesigndev.com; php-db@lists.php.net
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