Cheap Flights to
Cheap Flights
Cheapflights canada Canada Nova Scotia Nova Scotia
0) { ?>

The most populate place in "; while($row6 = mysql_fetch_assoc($res6)) { echo "
\"".tiretEspace($countryName)."\" ".$row6['asciiname']." (".$row6['population'].")
"; } if($nbResultatsVillesAdmin2!="") { echo "

"; } } //si les admin 2 n'ont pas de villes on fait rien on affiche directemment l'ordre alpha sinon on affihcce les admin2 if($nbResultatsVillesAdmin2!="") { ?>

Second-order administrative division of Nova Scotia

Second-order administrative division of Nova Scotia

"; $o_admin2 = new admin2(); $res2 = $o_admin2->admin2Pays($_GET['countryCodes'],$_GET['admin1']); $nbResultatsAdmin2 = mysql_num_rows($res2); while($row2 = mysql_fetch_assoc($res2)) { $admin1 = $row2['admin1Codes']; $admin2 = $row2['admin2Codes']; $nomAdmin2 = $row2['nomAdmin2Codes']; $countryCodes= $row2['countryCodes']; //recherche si l'admin a des villes $resAdmin = $o_villes->nbvillesAdmin2($admin2,$_GET['countryCodes']); $nbResultatsAdmin = mysql_num_rows($resAdmin); $rowAdmin = mysql_fetch_assoc($resAdmin); $adminIdVillesInfos = $rowAdmin['idVillesInfos']; $adminNomVille = $rowAdmin['asciiname']; $admin2NomVille = $rowAdmin['admin2Code']; //recherche des id des villes admin pour les afficher si pas de villes $resVillesAdmin2 = $o_villes->villesAdmin22($row2['nomAdmin2Codes'],$admin1,$_GET['countryCodes']); $nbResultatsAdmin22 = mysql_num_rows($resVillesAdmin2); $rowVillesAdmin2 = mysql_fetch_assoc($resVillesAdmin2); $admin2IdVillesInfos = $rowVillesAdmin2['idVillesInfos']; //si des villes on affihce le lien pour afficher les villes if($adminIdVillesInfos!="") { echo ""; } else { echo ""; } } } echo "
"; ?>
"; //ici la liste des villes pour le departement $o_villes = new villes(); $resnb = $o_villes->nbvillesAdmin2($_GET['admin2'],$_GET['countryCodes']); $nbResultats = mysql_num_rows($resnb); $rownb = mysql_fetch_assoc($resnb); $lettreAsciiname = $rownb['asciiname']; if ($_GET['lettreVille']=="") { $lettreVille =$lettreAsciiname{0}; } else { $lettreVille = $_GET['lettreVille']; } $res1 = $o_villes->villesAdmin2Alpha($_GET['admin2'],$_GET['countryCodes'],$lettreVille); $nbResultatsAdmin1 = mysql_num_rows($res1); echo "

".$nbResultatsAdmin1." places in ".$row3['nomAdmin2Codes'].",".urldecode($row1['nomAdmin1Codes']).",".$countryName.",".$row4['nomContinents']."

"; echo "".strtoupper($lettreVille)." - ".$nbResultatsAdmin1." place(s)"; echo "
"; echo "
"; echo "
"; $chaine = "a,b,c,d,e,f,g,h,i,j,k,l,m,n,o,p,q,r,s,t,u,v,w,x,y,z"; $t_chaine = explode(",",$chaine); if ($_GET['lettreVille']=="") { $lettreVille ="a"; } else { $lettreVille = $_GET['lettreVille']; } foreach($t_chaine as $cle => $lettre) { if($lettreVille!=$lettre) { //echo "&admin2=".$_GET['admin2'].""; //echo "&admin1=".$_GET['admin1'].""; //echo "&countryCodes=".$_GET['countryCodes']."\" class=\"liensAlphabetVilles\">".$lettre." ";*/ echo " ".$lettre." "; } else { echo " ".$lettre." "; } } echo "
"; //calcul du nombre de ville par colonne $modulo1 = ceil(($nbResultatsAdmin1/4)); $i=1; echo "
"; while($row1 = mysql_fetch_assoc($res1)) { echo "
\"".tiretEspace($row1['asciiname'])."\" "; echo "".$row1['asciiname']."
"; } echo "
"; }// fin du if if(!empty($_GET['admin1']) && !empty($_GET['countryCodes']) && empty($_GET['admin2'])) { echo "
"; //ici la liste des villes pour le departement $o_villes = new villes(); $resnb = $o_villes->nbvillesAdmin1($_GET['admin1'],$_GET['countryCodes']); $nbResultats = mysql_num_rows($resnb); $rownb = mysql_fetch_assoc($resnb); $lettreAsciiname = $rownb['asciiname']; if ($_GET['lettreVille']=="") { $_GET['lettreVille'] =$lettreAsciiname{0}; } $res1 = $o_villes->villesAdmin1Alpha($_GET['admin1'],$_GET['countryCodes'],$_GET['lettreVille']); $nbResultatsAdmin1 = mysql_num_rows($res1); echo "

".$nbResultats." places in ".urldecode($row1['nomAdmin1Codes']).", ".$countryName.", ".$row4['nomContinents']."

"; echo "".strtoupper($_GET['lettreVille'])." - ".$nbResultatsAdmin1." place(s)"; echo "
"; echo "
"; echo "
"; $chaine = "a,b,c,d,e,f,g,h,i,j,k,l,m,n,o,p,q,r,s,t,u,v,w,x,y,z"; $t_chaine = explode(",",$chaine); if ($_GET['lettreVille']=="") { $lettreVille ="a"; } else { $lettreVille = $_GET['lettreVille']; } foreach($t_chaine as $cle => $lettre) { if($lettreVille!=$lettre) { echo " ".$lettre." "; } else { echo " ".$lettre." "; } } echo "
"; //calcul du nombre de ville par colonne $modulo1 = ceil(($nbResultatsAdmin1/4)); $i=1; echo "
"; while($row1 = mysql_fetch_assoc($res1)) { echo "
\"".tiretEspace($row1['asciiname'])."\""; echo "".$row1['asciiname']."
"; $i++; } echo "
"; } ?>