Sunday, August 28, 2011

Get mysql table column comments using php?

$query = 'SELECT column_comment AS comment FROM information_schema.columns WHERE table_schema = "Database Name Here" && table_name = "Table Name Here" && column_name = "Column Name Here"';

$result = mysql_query($query, $connection) or die(mysql_error());

$comment = mysql_fetch_array($result);

echo($comment['comment']);