Meant to count the paddlers in the paddlers in each crew

<?php

$username="joe";

$password="chickie";

$database="kcc_reg";

mysql_connect("mysql.fatcow.com","$username","$password");

mysql_select_db($database) or die ( "Unable to select database");

$query= "SELECT DISTINCT crew FROM members";

$result=mysql_query($query) or die(mysql_error());

$num = mysql_num_rows ($result) or die(mysql_error());

$query = "SELECT crew, COUNT(name_last) FROM members GROUP BY crew";

$result = mysql_query($query) or die(mysql_error());

// Print out result

while($row = mysql_fetch_array($result)){

echo "There are ". $row['COUNT(name_last)'] ." ". $row['crew'] ." paddlers.";

echo "<br />";

}

mysql_close();

?>