|
Tours & Activities Puerto Vallarta |
|
 Hide List
|
Your shopping cart is currently empty";}
while($row2 = mysql_fetch_array($result2))
{
$numero += $row2["qty"];
// Increment the total cost of all items
$totalCost2x += ($row2["qty"] * $row2["adult2"]);
$totalCost2y += ($row2["qtyc"] * $row2["child"]);
$totalCost2=$totalCost2x+$totalCost2y;
?>
|
|
|
Date: // |
0){ ?>
Adults
0){ ?>
Children
|
|
$
|
|
| |
Total $ |
|
|
|
|
50 AND adult2 <= 100";}
if($price=="101-150"){$prezzo=" AND adult2 > 100 AND adult2 <= 150";}
if($price=="over150"){$prezzo=" AND adult2 > 150";}
if($duration=="Duration"){$durata="";}
if($duration=="0-3"){$durata=" AND duration <= 3";}
if($duration=="4-5"){$durata=" AND duration > 3 AND duration <= 5";}
if($duration=="6-16"){$durata=" AND duration > 5 AND duration <= 16";}
if($duration=="longer"){$durata=" AND duration > 16";}
if($classifi!="Classi"&&$classifi!=""){$durex=" AND ".$classifi."='1'";}
if($classifi=="Classi"){$durex="";}
if($ordine==""){$ordinare="tour";$senso="";}
if($ordine=="Order"){$ordinare="tour";$senso="";}
if($ordine=="alpha"){$ordinare="tour";$senso=" asc";}
if($ordine=="popular"){$ordinare="contador";$senso=" desc";}
if($ordine=="rec"){$ordinare="reccom";$senso=" asc";}
if($ordine=="low-price"){$ordinare="adult2";$senso=" asc";}
$query="SELECT * FROM tours WHERE onoff='1'".$durex.$prezzo.$durata." ORDER BY ".$ordinare.$senso;
$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){
?>
|
|
|
Total tour options: - Now showing tours from to |
|
|
|
Tour options (prices in US dollars):
|
|
|
|
|
|
|
|
Total tour options: - Now showing tours from to |
|
![](\"../images/interfaz/accommodations/separador.gif\") |
| Your search has not given any results. Please try to search with fewer options or clear the search form and try again";
} ?> |
|
|
|
|
|
|
