> 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
