$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'];

    echo $table_comment;


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

PHP General Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]

Reply via email to