I can't figure-it out how to count all these dancers columns and echo with total of all dancers

```
id | dancer1 | dancer2 | dancer3 | dancer4, and so on..
---------------------------------------
1     alex     michael    dalm      name
2     clare    rose       test        

```

I have this for the start but is not working:

```
$counter = mysql_query("SELECT COUNT(*) AS id FROM table");

$num = mysql_fetch_array($counter); 
$dancers = $num["id"];

echo "Total dancers: $dancers";

```

Any help is appreciated. Thanks!