All Countries\n"; $result = mysql_Query("SELECT DISTINCT clubaddr_country FROM club_details ORDER BY clubaddr_country", $sqlLink); WHILE ( list( $cCode ) = mysql_Fetch_Row($result) ) { $cName = $countryArray[$cCode]; $modName = ucWords( strToLower($cName) ); echo "\t\t
" . $modName . "\n"; } ?>