require("config/conf.php");
// CONNEXION MYSQL
$db_link = @mysql_connect($sql_serveur,$sql_user,$sql_passwd);
if(!$db_link) {echo "Connexion impossible à la base de données $sql_bdd sur le serveur $sql_server Contacter le IVAO-AWM1"; exit;}
$alldivision=mysql_db_query($sql_bdd,"select * from division where status>0 order by name",$db_link) or die(mysql_error());
?>
Organization Divisions
Organization Divisions
while ($data = mysql_fetch_array($alldivision)) {
$division = $data['icao'];
$divlow = strtolower($division);
$divhigh = strtoupper($division);
$dir=mysql_db_query($sql_bdd,"select * from ivao_staff where callsign=\"$divhigh-DIR\"",$db_link) or die(mysql_error());
$dir2 = mysql_fetch_array($dir);
$vid_dir = $dir2[vid];
$person_dir=mysql_db_query($sql_bdd,"select * from user_data where Pers_Id=\"$vid_dir\"",$db_link) or die(mysql_error());
$person_dir2 = mysql_fetch_array($person_dir);
$name_dir = $person_dir2[Pers_Last_Name];
$surname_dir = $person_dir2[Pers_First_Name];
$adir=mysql_db_query($sql_bdd,"select * from ivao_staff where callsign=\"$divhigh-ADIR\"",$db_link) or die(mysql_error());
$adir2 = mysql_fetch_array($adir);
$vid_adir = $adir2[vid];
$person_adir=mysql_db_query($sql_bdd,"select * from user_data where Pers_Id=\"$vid_adir\"",$db_link) or die(mysql_error());
$person_adir2 = mysql_fetch_array($person_adir);
$name_adir = $person_adir2[Pers_Last_Name];
$surname_adir = $person_adir2[Pers_First_Name];
print '