$choice = $_GET['choice']; include("user.php"); //Tour Operator's MySQL database link if($choice == "citybreaks") { $query = "SELECT * FROM `n_company` WHERE `TO_city_break` = '-1' AND `Display web` = '-1' ORDER BY `Company name`;"; $operator = "City Break Operators"; } if($choice == "shortbreaks") { $query = "SELECT * FROM `n_company` WHERE `TO_city_break` = '-1' AND `Display web` = '-1' ORDER BY `Company name`;"; $operator = "Short Break Operators"; } if($choice == "golf") { $query = "SELECT * FROM `n_company` WHERE `TO_golf_tour` = '-1' AND `Display web` = '-1' ORDER BY `Company name`;"; $operator = "Golf Tour Operators"; } if($choice == "internet") { $query = "SELECT * FROM `n_company` WHERE `TO_internet` = '-1' AND `Display web` = '-1' ORDER BY `Company name`;"; $operator = "Internet Operators"; } if($choice == "motor") { $query = "SELECT * FROM `n_company` WHERE `TO_motor` = '-1' AND `Display web` = '-1' ORDER BY `Company name`;"; $operator = "Motor Racing Operators"; } if($choice == "coach") { $query = "SELECT * FROM `n_company` WHERE `TO_coach` = '-1' AND `Display web` = '-1' ORDER BY `Company name`;"; $operator = "Coach Operators"; } if($choice == "family") { $query = "SELECT * FROM `n_company` WHERE `TO_family` = '-1' AND `Display web` = '-1' ORDER BY `Company name`;"; $operator = "Family Holiday Operators"; } if($choice == "group") { $query = "SELECT * FROM `n_company` WHERE `TO_groups` = '-1' AND `Display web` = '-1' ORDER BY `Company name`;"; $operator = "Group Holiday Operators"; } if($choice == "school") { $query = "SELECT * FROM `n_company` WHERE `TO_schools` = '-1' AND `Display web` = '-1' ORDER BY `Company name`;"; $operator = "School and Youth Operators"; } if($choice == "military") { $query = "SELECT * FROM `n_company` WHERE `TO_military` = '-1' AND `Display web` = '-1' ORDER BY `Company name`;"; $operator = "Military Tourism"; } if($choice == "spa") { $query = "SELECT * FROM `n_company` WHERE `TO_spa` = '-1' AND `Display web` = '-1' ORDER BY `Company name`;"; $operator = "Spa Specialists"; } if($choice == "") { $query = "SELECT * FROM `n_company` WHERE `Display web` = '-1' ORDER BY `Company name`;"; $operator = "All Operators"; } if($choice == "beer") { $query = "SELECT * FROM `n_company` WHERE `TO_beer` = '-1' AND `Display web` = '-1' ORDER BY `Company name`;"; $operator = "Beer Tour Specialists"; } //connect to database $link = mysql_connect("$dbhost", "$dbuser", "$dbpass") or die ("ERROR!: Could not connect"); mysql_select_db ("$dbname") or die ("ERROR!: Could not select database"); //print result of database query ?>
Tour Operator Listings
This page displays selective listings from our "Trade Database".
If you are a tour operator and would like to be included, please contact us!
print "$operator"; ?>
if($query =="")
{
}
else
{
$result = mysql_query($query);
while($row = mysql_fetch_array($result,1))
{
$companyname = $row['Company name'];
$city = $row['City'];
$url = $row['Web'];
$telephone = $row['Tel'];
$fax = $row['Fax'];
?>
print "$companyname"; ?> print "$city"; ?> url: visit website telephone: print "$telephone"; ?> fax: print "$fax"; ?> } } ?> If you experience problems with the tour operator listings, please email Philippe. |