= 25 ORDER BY lang_code" ,$connection); while($langs = mysql_fetch_array($result, MYSQL_NUM)) { $name = ""; $lang = ""; // Get the code for the language $lang = $langs[0]; // Get the name for the language $fetchname = mysql_query( "SELECT name FROM language WHERE lang_code = \"" . $lang . "\"", $connection); if($fetcharray = mysql_fetch_array($fetchname, MYSQL_NUM)) { $name = $fetcharray[0]; } else { $name = $lang; } print "

\n"; //print "\n"; //print "\n"; } ?>

Language Name	Ethnologue Code
" . $name . "	" . $lang . "