count row

hello guys..

pls help me on this problem:
[COLOR=Red]i want the output to be the total of the row.what i have to change from this coding? [/COLOR]

$sel = [COLOR=Sienna]“select club from student”[/COLOR];
$sel_res = [COLOR=Blue]mysql_query[/COLOR]($sel) or [COLOR=Blue]die(mysql_error[/COLOR]($sel));

while ($rs = [COLOR=Blue]mysql_fetch_array[/COLOR]($sel_res)){
if ($rs[[COLOR=Sienna]“club”[/COLOR]]==[COLOR=Sienna]“Tennis”[/COLOR]){
[COLOR=Blue]echo count[/COLOR]($rs[[COLOR=Sienna]”club”[/COLOR]]).[COLOR=Sienna]“<br>”[/COLOR]; }
}

[B]output: [/B]
[COLOR=DarkOrange][B]1
1[/B][/COLOR]

thank you so much

Also in #PHP _↴