Re: HELP: Re: Table comments

<?php $db = mysql_connect('localhost','user','password'); mysql_select_db('database', $db); $sql = 'SHOW TABLE STATUS LIKE table_name'; $result = mysql_query($sql); // Only returning 1 row, but I put it in a while() loop in case the result is empty // Then I don't get any errors. while ($data = mysql_fetch_array($result)) {

       $table_comment = $data['Comment'];

} mysql_free_result($result); mysql_close($db); echo $table_comment; ?> Mike jtjohnston wrote:

In my phpadmin, I have something called: "Table comments". Can I acccess this somehow? Can't find it in the function database.

I've tried this since, but can't get syntax right: <?php $myconnection = mysql_pconnect("localhost","",""); mysql_select_db("",$myconnection); $rows = mysql_query("SHOW TABLE STATUS from MyTable LIKE Comment"); echo "$rows"; ?> I'm still new to this. A post & reply would be appreciated, Thanks, John