Display number of columns in table?

[jamesjmann]

When displaying data from a mysql table, what php code can I use to display the number of columns in said table?

 

Like, say I'm displaying comments by users. I want to be able to put "displaying 'thismany' comments".

 

Any suggestions?

[jamesjmann]

NVM.

 

Just googled it and came up with this:

<?php

$link = mysql_connect("hostname", "username", "password");
mysql_select_db("database", $link);

$result = mysql_query("SELECT * FROM table ", $link);
$num_rows = mysql_num_rows($result);

echo "$num_rows Comments";

?>