How to count fields in a table?

[Replika]

How to get num of fields in a table?

[trexx]

what do you mean with "fields"? columns or rows or cells?

[Replika]

what do you mean with "fields"? columns or rows or cells?

=>that's column

[trexx]

In MySQL:

$q = 'SHOW COLUMNS FROM my_table';
$rs = mysql_query($q);
echo 'column count: ' . mysql_num_rows($rs);
while ($r = mysql_fetch_row($rs)) {
  print_r($r);
}