<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN"
  "http://www.w3.org/TR/html4/loose.dtd">
<html xmlns="http://www.w3.org/1999/xhtml" lang="en-US">

<head>
<title>Moreno Travel</title>
    <link href="style.css" rel="stylesheet" type="text/css" />
    <meta http-equiv="content-type"
        content="text/html; charset=utf-8" />
<?php include 'analytics.php'; ?>
</head>



<?php include 'headerhome.php'; ?>

<ul>


<p>

<table class="home"><tr><td colspan="2" class="home">
<h1 class="h1_home2">Reserva un paquete de viaje hoy mismo!</h1>

<div class="figurehome2">
<a class="figurehome" href="http://moreno.ca/Moreno_Tours/index.htm">
<p class="figurehome" valign="bottom">Canada y Estados Unidos</p><img src="img/canadaus.jpg"></a></div>
</td>


</tr><tr>
<td align="left" class="home">
<h1 class="h1_home">Book a Tour<br> Package Today!</h1>


<?php


require_once('connectvars.php');

	

$dbh = mysql_connect(hostname, username, password)

	or die("Unable to connect to MySQL");

mysql_select_db (dbname, $dbh);


$query = sprintf("SELECT p.location_id, l.* FROM packages p, location l WHERE l.location_id=p.location_id and p.location_id>0 and l.location_order>0 GROUP BY l.location_id ORDER BY location_order ASC");


$result = mysql_query($query);



if (!$result) {

    $message  = 'Invalid query: ' . mysql_error() . "\n";

    $message .= 'Whole query: ' . $query;

    die($message);

}

while ($row = mysql_fetch_assoc($result)) {






 echo "<center><div class=\"figurehome\">
<a class=\"figurehome\" href=\"home_country.php?location_id=".$row['location_id']."\">
<p class=\"figurehome\" valign=\"bottom\">".$row['location_name']."</p><img src=\"countryimg/".$row['location_pic']."\"></a></div></center>";


}
?></td>
<td rowspan="3" align="left" class="home"><iframe frameborder="0" src="http://wftc1.e-travel.com/plnext/AIEABPYABPY/CleanUpSessionPui.action?SITE=ABPYABPY&LANGUAGE=US" name="Book a Flight"
width="800px" height="750px">
content if browser does not support
</iframe>
</td>

</tr>



<tr><td class="home">
<h1 class="h1_home">Specialty Travel</h1>

<div class="figurehome">
<a class="figurehome" href="medical.php">
<p class="figurehome" valign="bottom">Medical Tourism<br></p><img src="img/medical.jpg"></a></div>


<div class="figurehome">
<a class="figurehome" href="incentive.php">
<p class="figurehome" valign="bottom">Incentive Tours<br></p><img src="img/incentive.jpg"></a></div>

<div class="figurehome">
<a class="figurehome" href="longtermlist.php">
<p class="figurehome" valign="bottom">Long Term Stay<br></p><img src="img/longterm.jpg"></a></div>





</td></tr></table>
</ul>
<?php include 'footer.php'; ?>

</div>


</body>

</html>