count coloumn from database table

[nagasea]

I'm trying to count how many coloumn in my database table and put that into a variable ($countcoloum)
Anybody know how to do it ?

[mhalloran]

There are a bunch of options...

SELECT count(*) as row_count FROM table_name;

You can also get the get a count at the same time as selecting other items by grouping the data -

SELECT count(*) as row_count, first_name, last_name, etc FROM table_name GROUP BY row_count

Even better, you can count the rows or any result set by using mysql_num_rows

[nagasea]

thats for counting row right, not coloumn.. am i right ?
I need it to count couloumns

[mhalloran]

Sorry, I didn't read you post correctly. This should do the trick.

$result = mysql_query("select * FROM table_name LIMIT 1");
$data = mysql_fetch_row($result);
$column_count = count($data);

[LordShryku]

Or try [man]mysql_list_fields[/man], then [man]mysql_num_fields[/man]