Get Total Columns from table in mysql

[vijay]

Hi.. Is there any way in mysql to get total no. of columns from specific table..?you have to not use: mysql_num_fields($result);want to say any special query... or mysql function..Regards,Vijay Prajapati.

[reportingsjr]

well, you could try and do this:

<?php$query = mysql_query("SELECT * FROM `table`");while($row = mysql_fetch_assoc($query)){echo count($row)."<br />";}?>

That should print the no of columns a bunch of times. Thats as close as I can come..

[jesh]

I believe you can do a SHOW COLUMNS FROM mytable query in MySQL. Here's a link for more information:http://dev.mysql.com/doc/refman/5.0/en/show-columns.html

$query = mysql_query("SHOW COLUMNS FROM `table`");

I haven't tested it though.