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: 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
