Cheap Flights to
Cheap Flights
Vols-Resa Sitemap Vol-resaSitemap 
".$_GET['lettre'].""; echo "
"; echo "
"; while($rowRechercheVille = mysql_fetch_array($resultat)) { $idVillesInfos = $rowRechercheVille['idVillesInfos']; $nomVille = $rowRechercheVille['asciiname']; //selection pays $o_pays = new pays(); $resSearch = $o_pays->paysNoms($rowRechercheVille['countryCode']); $rowSearch = mysql_fetch_assoc($resSearch); $countrySearch = $rowSearch['nameCountry']; echo "airline tickets ".$nomVille." - ".$countrySearch.""; echo "
"; } } } if(($_GET['lettre']!="") && ($_GET['sitemapType']=="country")) { //selection pays $sqlNombreElement = "SELECT country, idPaysInfos FROM paysInfos WHERE country LIKE '".$_GET['lettre']."%'"; $resultatNombreElement = mysql_query($sqlNombreElement); //echo $sqlNombreElement; $limit=90; if($debut==""){$debut=0;} $debut=$page*$limit; $nbTotal=mysql_num_rows($resultatNombreElement); $limite=mysql_query("$sqlNombreElement limit $debut,$limit"); $limit_str = "LIMIT ". $page * $limit .",$limit"; $sqlAlpha = "SELECT country, idPaysInfos FROM paysInfos WHERE country LIKE '".$_GET['lettre']."%' ORDER BY country ASC ".$limit_str; $resultat = mysql_query($sqlAlpha); $i = 0; //echo $sqlAlpha; if($resultatNombreElement!="") { echo "(".$nbTotal.") resultat(s) pour ".$_GET['lettre'].""; echo "
"; echo "
"; while($rowRecherchePays = mysql_fetch_assoc($resultat)) { $nomPays = $rowRecherchePays['country']; $idPays = $rowRecherchePays['idPaysInfos']; echo "airline tickets ".$nomPays.""; echo "
"; } } } if(($_GET['lettre']!="") && ($_GET['sitemapType']=="airports")) { $sqlNombreElement = "SELECT asciiname, idAeroportsInfos, timezone FROM aeroportsInfos WHERE asciiname LIKE '".$_GET['lettre']."%' GROUP BY asciiname"; $resultatNombreElement = mysql_query($sqlNombreElement); //echo $sqlNombreElement; $limit=90; if($debut==""){$debut=0;} $debut=$page*$limit; $nbTotal=mysql_num_rows($resultatNombreElement); $limite=mysql_query("$sqlNombreElement limit $debut,$limit"); $limit_str = "LIMIT ". $page * $limit .",$limit"; $sqlAlpha = "SELECT asciiname, idAeroportsInfos, timezone FROM aeroportsInfos WHERE asciiname LIKE '".$_GET['lettre']."%' GROUP BY asciiname ORDER BY asciiname ASC ".$limit_str; $resultat = mysql_query($sqlAlpha); $i = 0; //echo $sqlAlpha; if($resultatNombreElement!="") { echo "(".$nbTotal.") result(s) for ".$_GET['lettre'].""; echo "
"; echo "
"; while($rowRechercheAirports = mysql_fetch_assoc($resultat)) { $idAirportsInfos = $rowRechercheAirports['idAeroportsInfos']; $nomAirports = $rowRechercheAirports['asciiname']; $timezone = $rowRechercheAirports['timezone']; echo "airline tickets ".$nomAirports." - ".$timezone.""; echo "
"; } } } echo "
"; echo "
"; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo "
"; if ($page>0) { $precedent=$page-1; echo "<< Page précédente"; } echo ""; $k=0; $j=1; if($nbTotal>$limit) { while($k<($nbTotal/$limit)) { $h++; if($k!=$page){echo "  ".$j."  ";} else { echo "   ".$j."  ";} $k++;$j++; if($h%12==0){ echo "
";} } } echo "
"; if($debut+$limit<$nbTotal) { $suivant=$page+1; echo "Page suivante >>"; } echo "
"; ?>