Error performing query: " . mysql_error() . "

"); exit(); } while($row = mysql_fetch_array($query)) { $destination_code=$row["airport_code"]; $destination_country=$row["country"]; } ?> <?php eval('echo "List of Low Cost Flights to $destination_name, $destination_country";');?> "/> 31){ $meta_description = 'Low Cost flights to $destination_name. Route details for budget airlines offering cheap flights to $destination_name ($destination_code) in $destination_country.'; eval("\$meta_description = \"$meta_description\";"); } else{ $meta_description = 'Low Cost flights to $destination_name. Low Cost Airline Guide provides route details for budget airlines offering cheap flights to $destination_name ($destination_code) in $destination_country.'; eval("\$meta_description = \"$meta_description\";"); } ?>

Error performing query: " . mysql_error() . "

"); exit(); } while($row = mysql_fetch_array($query)) { $destination_code=$row["airport_code"]; $alternative_names=$row["alternative_names"]; $official_airport_website=$row["official_airport_website"]; $wikitravel_website=$row["wikitravel_website"]; } $query = @mysql_query("SELECT DISTINCT routes.from_code, routes.to_code, routes.airline_code, airlines.name, airlines.website_full, airlines.website_display, origin.airport_name AS origin_name, destination.airport_name AS destination_name, destination.country AS destination_country, origin.country AS origin_country, destination.airport_desc FROM routes, airlines, airports AS origin, airports AS destination WHERE routes.to_code='$destination_code' AND airlines.ICAO_code = routes.airline_code AND origin.airport_code = routes.from_code AND destination.airport_code = routes.to_code ORDER BY origin.country, origin_name "); if (!$query) { echo("

Error performing query: " . mysql_error() . "

"); exit(); } if (mysql_num_rows($query) == 0){ echo "Sorry! We are not currently currently aware of any low cost airlines providing flights to {$destination_name}, but this page is updated daily so please check back again soon. You can also check the availability of {$destination_country} flights to other airports.\n"; echo "
"; } $printed_header="0"; $printed_country="0"; $printed_origin="0"; //print the header/title while($row = mysql_fetch_array($query)) { $destination_name=$row["destination_name"]; $destination_country=$row["destination_country"]; $destination_desc=$row["airport_desc"]; if($printed_header == "0") { eval ('echo "

" . gettext("Low cost $destination_name flights") . "

\n";'); echo "

" . $destination_desc . "

\n"; echo "
\n"; eval ('echo "

" . gettext("Which country would you like to fly to $destination_name from?") . "

\n";'); $printed_header="1"; } } mysql_data_seek($query,0); //reset pointer $country_old=""; echo "

\n"; while($row = mysql_fetch_array($query)) { $origin_country=$row["origin_country"]; // Build a list of countries at the top of the page to act as hyperlinks to lower down the page // Replace spaces in a name tag with _ for xhtml compliance if ($country_old != $origin_country){ echo "" . gettext($origin_country) . "\n"; $country_old = $origin_country; } } echo "

\n"; mysql_data_seek($query,0); //reset pointer while($row = mysql_fetch_array($query)) { $from_code=$row["from_code"]; $airline_code=$row["airline_code"]; $airline_name=$row["name"]; $website_full=$row["website_full"]; $website_display=$row["website_display"]; $origin_name=$row["origin_name"]; $destination_name=$row["destination_name"]; $destination_country=$row["destination_country"]; $origin_country=$row["origin_country"]; $to_code=$row["to_code"]; $destination_desc=$row["airport_desc"]; if($printed_country != $origin_country){ //1. unless its the very first origin for the first country, close the last divdivider if($printed_country != "0"){ echo "
\n"; //end of individual route div } echo "
\n"; //eval('echo "' . addslashes(gettext('Fly from $origin_name ($from_code) to $destination_name ($to_code) with $airline_name ($airline_website)')) . '";'); //Replace spaces in a name tag with _ for xhtml compliance eval ('echo "

" . gettext("List of low cost airline flights to $destination_name from $origin_country:") . "

";'); //' . gettext('Low cost flights to $destination_name from $origin_country') .":\n";'); echo "
\n"; $printed_country=$origin_country; $first_origin_after_a_country_heading="1"; } //create a new div for each new origin if($printed_origin != $origin_name){ if($first_origin_after_a_country_heading=="1") echo "
\n"; //3. If its a new origin, open div else echo "
\n
\n"; //2. If its a new origin, but not the first one after a country heading, close the last div $printed_origin=$origin_name; $first_origin_after_a_country_heading="0"; } echo "

\n"; $airline_website="{$website_display}"; eval('echo "' . addslashes(gettext('Fly from $origin_name ($from_code) to $destination_name ($to_code) with $airline_name ($airline_website)')) . '";'); echo "

\n"; } echo "
\n"; //end of individual route div ?>

', $destination_name, $destination_code); if ($alternative_names !="") printf('Alternative airport names: %1$s
', $alternative_names); if ($wikitravel_website !="") printf('' . gettext('Wikitravel - %1$s Travel Guide') . '
', $destination_name); if ($official_airport_website !="") printf('' . gettext('Official %1$s Airport Website') . '
', $destination_name); ?>



Scroll to Top