Get mysql column comments with php?

[dcgamers]

When you add a new column and you see the comments text box in phpmyadmin or something. How can you retrieve this using php and put it in a variable?

[js_280]

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