www.mexicocancun.net - One CLICK Away - Your Cancun Web Site

Cancun Hotels Resorts & More


	+ Cancun, Mexico
	Cancun Currency
	Cancun Supermarkets
	Online Hotel Reservations
	Online Tours Reservations
	Online Groups & Meetings
	What to do in Cancun
	Where to Stay
	Pictures, Photos & Videos
	Cancun Bulletin Board
	Cancun eCards
	How to get to Cancun
	Our Cancun Guestboock
	About Us
	MexicoCancun.net site map



	For reservations only call us at: 1 888 247-8081 Monday - Friday: 9AM - 6PM (CST) Saturday: 10AM - 2PM (CST)

Cancun Hotels & Resorts

Refine your Hotel Options

The current results are sorted by: "; $finale="1";} if($category=="GT"){echo "Grand Tourism";} if($category=="5"){echo "5 Stars";} if($category=="4"){echo "4 Stars";} if($category=="3"){echo "3 Stars";} if($category=="2"){echo "2 Stars";} if($category=="1"){echo "1 Star";} if($type!=""){ if($category!=""){echo", ";} if($type=="BR"){echo "Beach Resort";} if($type=="BC"){echo "Beach Club";} if($type=="BH"){echo "Budget Hotels";} if($type=="BB"){echo "Bed & Breakfast";} if($type=="G"){echo "Getaways";} } if($price!=""){ if($category!=""||$type!=""){echo", ";} if($price=="0-50"){echo "Low Price";} if($price=="51-100"){echo "Mid Price";} if($price=="101-200"){echo "High Price";} if($price=="over200"){echo "Luxury";} } if($mealplan!=""){ if($category!=""||$type!=""||$price!=""){echo", ";} if($mealplan=="planai"){echo "All Inclusive";} if($mealplan=="planep"){echo "European Plan";} if($mealplan=="both"){echo "All Inclusive and European Plan";} } if($ordine!=""){ if($category!=""||$type!=""||$price!=""||$mealplan!=""){echo", ";} if($ordine=="alpha"){echo "Alphabetically";} if($ordine=="rating"){echo "By Rating";} if($ordine=="rec"){echo "Recommendations";} if($ordine=="low-price"){echo "Lower to highest Price";} } if($finale=="1"){echo "";} } ?>

Refine your option

50 AND preciomin <= 100";} if($price=="101-200"){$prezzo=" AND preciomin > 100 AND preciomin <= 200";} if($price=="over200"){$prezzo=" AND preciomin > 200";} if($ordine==""){$ordinare="category";$senso=" DESC";} if($ordine=="Order"){$ordinare="category";$senso=" DESC";} if($ordine=="alpha"){$ordinare="name";$senso=" ASC";} if($ordine=="low-price"){$ordinare="preciomin";$senso=" asc";} $query="SELECT * FROM iconos WHERE onoff='1'".$categoria.$comida.$prezzo.$tipo." ORDER BY ".$ordinare.$senso; if($ordine=="rating"){ ## trasformo todos lso campos en campos corectos por la joint anadiendo m if($type!=""){$tipo=" AND m.type='".$type."'";} if($category!=""){$categoria=" AND m.category='".$category."'";} if($mealplan=="both"){$comida=" AND m.planep='1'AND m.planai='1'";} if($mealplan=="planep"){$comida=" AND m.planep='1'";} if($mealplan=="planai"){$comida=" AND m.planai='1'";} if($price=="0-50"){$prezzo=" AND m.preciomin <= 50";} if($price=="51-100"){$prezzo=" AND m.preciomin > 50 AND m.preciomin <= 100";} if($price=="101-200"){$prezzo=" AND m.preciomin > 100 AND m.preciomin <= 200";} if($price=="over200"){$prezzo=" AND m.preciomin > 200";} ## query joint super dificil!!!!!! $query="SELECT m.*, AVG( b.rank ) AS averages FROM iconos AS m LEFT JOIN comments AS b ON m.ihotelier = b.hotel WHERE m.onoff = '1'".$categoria.$comida.$prezzo.$tipo." GROUP BY ihotelier ORDER BY averages DESC"; } $mysql_result=mysql_query($query, $mysql_link); if (!$mysql_result) { $errno = mysql_errno($mysql_link); $error = mysql_error($mysql_link); echo "Database Error test0 ($errno): $error"; } $totalerecord=mysql_num_rows($mysql_result); $queryx=$query." LIMIT ".$limit.",".$numerorecord; $mysql_resultx=mysql_query($queryx, $mysql_link); if (!$mysql_resultx) { $errno = mysql_errno($mysql_link); $error = mysql_error($mysql_link); echo "Database Error test1 ($errno): $error"; } if(!$indietro){ $primo=$ultimo + 1; if ($totalerecord > ($ultimo + $numerorecord)){ $ultimo=$ultimo + $numerorecord;} else {$ultimo = $totalerecord;} } else{ $primo=$limit+1; $ultimo=$limit+$numerorecord; if($ultimo>$totalerecord){$ultimo=$totalerecord;} } if($totalerecord>0){ ?>

◄

Back

Total Hotel & Resorts - Now showing: -

►

" class="hotel-reserve">		0){ while($arraycommenti=mysql_fetch_array($mysql_resultcommenti)){ $totalerank=$totalerank+$arraycommenti["rank"]; } $averagerank=$totalerank/$totalerecordcomm; } if($totalerank>0){ if($averagerank<="1.25"&&$averagerank>"0.75"){$image="../images/interfaz/accommodations/icono_coments01.gif";} if($averagerank<="1.75"&&$averagerank>"1.25"){$image="../images/interfaz/accommodations/icono_coments01.5.gif";} if($averagerank<="2.25"&&$averagerank>"1.75"){$image="../images/interfaz/accommodations/icono_coments02.gif";} if($averagerank<="2.75"&&$averagerank>"2.25"){$image="../images/interfaz/accommodations/icono_coments02.5.gif";} if($averagerank<="3.25"&&$averagerank>"2.75"){$image="../images/interfaz/accommodations/icono_coments03.gif";} if($averagerank<="3.75"&&$averagerank>"3.25"){$image="../images/interfaz/accommodations/icono_coments03.5.gif";} if($averagerank<="4.25"&&$averagerank>"3.75"){$image="../images/interfaz/accommodations/icono_coments04.gif";} if($averagerank<="4.75"&&$averagerank>"4.25"){$image="../images/interfaz/accommodations/icono_coments04.5.gif";} if($averagerank>"4.75"){$image="../images/interfaz/accommodations/icono_coments05.gif";} if($image){ echo ""; } } ?>