Unnamed

//PHP index.php

<?php
$sql = mysql_connect("localhost","root");
if(!$sql){
	die("Failed to connect to SQL server.");
}else{
	$sqlDB = mysql_select_db("world",$sql);
	$sqlQuery = mysql_query("SELECT DISTINCT language FROM countrylanguage ORDER BY language");
	$numLang = mysql_num_rows($sqlQuery);
	echo "numLang=$numLang&";
	for($i=0;$i<$numLang;$i++){
		$data = mysql_fetch_array($sqlQuery);
		echo "language$i=$data[0]&";
	}
	$sqlQuery2 = mysql_query("SELECT DISTINCT continent FROM country ORDER BY continent");
	$numContinents = mysql_num_rows($sqlQuery2);
	echo "numContinents=$numContinents&";
	for($i=0;$i<$numContinents;$i++){
		$data = mysql_fetch_array($sqlQuery2);
		echo "continent$i=$data[0]&";
	}
}

?>
//flash index.fla

var getVars:LoadVars = new LoadVars();
var sendVars:LoadVars = new LoadVars();
var langListen:Object = new Object();
getVars.load("index.php");
getVars.onLoad = function() {
	for (var i = 0; i<getVars.numLang; i++) {
		language_cb.addItem(_root.getVars["language"+i]);
	}
	for (var i = 0; i<getVars.numContinents; i++) {
		continent_cb.addItem(_root.getVars["continent"+i]);
	}
};
langListen.change = function() {
	sendVars.lang = language_cb.value;
	sendVars.cont = continent_cb.value;
	sendVars.sendAndLoad("index2.php", sendVars, "POST");
};
sendVars.onLoad = function() {
	country_lb.removeAll();
	for (var i = 0; i<sendVars.numCountries; i++) {
		country_lb.addItem(_root.sendVars["lang"+i]);
	}
};
language_cb.addEventListener("change",langListen);
continent_cb.addEventListener("change",langListen);

//PHP index2.php

<?php
$sql = mysql_connect("localhost","root");
$db = mysql_select_db("world",$sql);
if(!$sql){
	die("sfsdf");
}else{	
	$lang = $_POST['lang'];
	$cont = $_POST['cont'];
	$resultsQuery = mysql_query("SELECT country.name FROM country, countrylanguage WHERE countrylanguage.language ='$lang' AND country.code = countrylanguage.countrycode ORDER BY country.name");
	$numCountries = mysql_num_rows($resultsQuery);
	for($i=0;$i<$numCountries;$i++){
		$data = mysql_fetch_array($resultsQuery);
		echo "lang$i=$data[0]&";
		}
		echo "numCountries=$numCountries&";
	}
?>