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]);
}
?>
Devis assurance voyage - assurance expatrié | Devis gratuits