|
Guide to Manchester
Welcome to Manchester
Manchester History
Shopping
Eating Out
Nightlife
Sport
Things to see do
Travel
Business
Manchester Cathedral
Manchester Community info
Visitor Information
Manchester Airport
Find your Hotel
Popular Areas of Manchester
Manchester Hotels A-Z
Manchester Hotel By Rating
Hotels in Manchester By Price
Manchester Airport Hotels
Contact Us
Manchester Hotels
$EstablishmentName
");
}
?>
|
");
while($row = mysql_fetch_array($result)){
$bgcolor = "#FFFF99";
$pic1 = $row['pic1'];
$pic2 = $row['pic2'];
$URL = $row['URL'];
$HomeHyperlink = $row['HomeHyperlink'];
$BookingsHyperlink = $row['BookingsHyperlink'];
$EstablishmentName = $row['EstablishmentName'];
$Address1 = $row['Address1'];
$Area = $row['Area'];
$PostCode = $row['PostCode'];
$railair = $row['railair'];
$NumBedrooms = $row['NumBedrooms'];
$EstablishmentType = $row['EstablishmentType'];
$Description = $row['Description'];
$RoomsFrom = $row['RoomsFrom'];
$Rating = $row['Rating'];
$phone = $row['phone'];
$website = $row['website'];
$email = $row['email'];
$bar = $row['bar'];
$rest = $row['rest'];
$carpark = $row['carpark'];
$laundry = $row['laundry'];
$pool = $row['pool'];
$childfac = $row['childfac'];
$lift = $row['lift'];
$sat = $row['sat'];
$tv = $row['tv'];
$cc = $row['cc'];
$tpress = $row['tpress'];
$hair = $row['hair'];
$teacoffee = $row['teacoffee'];
$gym = $row['gym'];
$golf = $row['golf'];
$text = "
$EstablishmentName
$Address1 Manchester $PostCode
$Description
";
echo(" | | ");
echo ("$text");
echo(" | ");
}
echo(" ");
if($page != 1){
$pageprev = $page-1;
echo("PREV".$limit." ");
}else{
echo("PREV".$limit." ");
}
$numofpages = $totalrows / $limit;
for($i = 1; $i <= $numofpages; $i++){
if($i == $page){
echo($i." ");
}else{
echo("$i ");
}
}
if(($totalrows % $limit) != 0){
if($i == $page){
echo($i." ");
}else{
echo("$i ");
}
}
if(($totalrows - ($limit * $page)) > 0){
$pagenext = $page+1;
echo("NEXT".$limit."");
}else{
echo("NEXT".$limit);
}
mysql_free_result($result);
?>
|
