To find the number of Columns in a table using MySQL query

[Manuz]

SELECT count(*) FROM information_schema.`COLUMNS` C
WHERE table_name = 'your_table_name'
AND TABLE_SCHEMA = "your_db_name"

TABLE_SCHEMA is required only if table name exists in more than one db

[whiteyoh]

Hi,

this should help

$myQuery = "show columns from $my_table_name";
$result = mysql_query($myQuery);
$row = mysql_fetch_row($result);
$columncount = count($row);

[Hemant_4]

it so simple:-
$result=mysql_query("select * from table_name");
echo mysql_num_field($result);

finish....

[Terry_2]

should be:
mysql_num_fields($result);