include("../include/c_mysql.php"); //recherche des différentes ==> Département $result=mysql_query("SELECT id_lieu,lieu,parent FROM region WHERE parent!=0 ORDER BY lieu"); while($row=mysql_fetch_array($result)){ $id_lieu[]=$row[0]; $lieu[]=htmlentities($row[1]); $parent[]=$row[2]; } $nbre_region=mysql_num_rows($result); //recherche des rubriques parent régions $result=mysql_query("SELECT id_lieu,lieu FROM region WHERE parent='0' ORDER BY lieu"); while($row=mysql_fetch_array($result)){ $id_region[]=$row[0]; $region[]=htmlentities($row[1]); } //recherche des différents pays $result=mysql_query("SELECT id_pays,pays,parent FROM pays WHERE parent!=0 ORDER BY pays"); while($row=mysql_fetch_array($result)){ $id_pays[]=$row[0]; $pays[]=htmlentities($row[1]); $parent_pays[]=$row[2]; } $nbre_pays=mysql_num_rows($result); //recherche des rubriques parent pays=continents $result=mysql_query("SELECT id_pays,pays FROM pays WHERE parent='0' ORDER BY pays"); while($row=mysql_fetch_array($result)){ $id_continent[]=$row[0]; $continent[]=htmlentities($row[1]); } ?>