$banner = "Banner_index";
include_once("inc/page.header.php");
# list chains
$sql = "SELECT * FROM chains ORDER BY chain";
$result = mysql_query($sql);
while ($row = mysql_fetch_array($result)) {
$cid = $row["id"];
$cna = $row["chain"];
$clk = $row["webpage"];
# list hotels within chain
$sql2 = "SELECT * FROM hotels WHERE chain=$cid ORDER BY name";
$result2 = mysql_query($sql2);
$hid = $hna = $hst = $hlk = "";
while ($row2 = mysql_fetch_array($result2)) {
$hid = $row2["id"];
$hna .= "".$row2["name"]."
";
$hst .= "![".$row2["stars"]."](img/".$row2["stars"]."_stars.gif)
";
$hlk .= $row2["webpage"]."website
";
}
$hotel_list .= "
 |
$hna |
$hst |
";
}
?>
xlate('Hotel Chains')?>
| xlate('Chain')?> |
xlate('Hotel')?> |
xlate('Category')?> |
include_once("inc/page.footer.php");?>