You searched for routes meeting the following criteria |
#echo $routename." ".$regionid." ".$portlen." ".$routedesc;
#exit(1);
$dregionid = $regionid;
$droutename = $routename;
$ddist1 =$dist1;
$ddist2 =$dist2;
$ddur1 =$dur1;
$ddur2 =$dur2;
$dlooptrip = $looptrip;
$dportlen = $portlen;
$droutedesc =$routedesc;
$sql = "Select region from Region_Master where regionid='$dregionid'";
$result = mysql_query($sql);
if($myrow = mysql_fetch_array($result)) { $region = $myrow[region]; }
?>
| Region: |
echo $region ?>
|
| Route
Name Contains: |
if(!$droutename || $droutename == "%") { echo "(not specified)"; }
else { echo $droutename; }
?>
|
| Trip
Distance:: |
if(!$ddist1 || !$ddist2) { echo "(not specified)"; }
else { echo $ddist1." to ".$ddist2." m"; }
?>
|
| Trip
Duration: |
if(!$ddur1 || !$ddur2) { echo "(not specified)"; }
else { echo $ddur1." to ".$ddur2." days"; }
?>
|
| Loop
Trip: |
if($dlooptrip == "Any") { echo "(not specified)"; }
else {
if($dlooptrip == 1) { echo "Yes"; } else {
if($dlooptrip == 0) { echo "No"; } }}
?>
|
| Total
Portaging Less Than: |
if(!$dportlen || $dportlen == 10000) { echo "(not specified)"; }
else { echo $dportlen." m"; }
?>
|
| Route
Description contains: |
if(!$droutedesc || $droutedesc == "%") { echo "(not specified)"; }
else { echo $droutedesc; }
?>
|
if (!$routename) { $routename = "%"; }
if (!$dist) { $dist = "%"; }
if (!$dur) { $dur = "%"; }
if (!$portlen) { $portlen = "10000"; }
if (!$routedesc) { $routedesc = "%"; }
if (!$dist1) { $dist1 = "0"; }
if (!$dist2) { $dist2 = "10000"; }
if (!$dur1) { $dur1 = "0"; }
if (!$dur2) { $dur2 = "10000"; }
$limit = 20;
$allData = array();
$i=0;
$found = 0;
if($looptrip == "Any") { $result = mysql_query("Select * from Route_Master where ((regionid = '$regionid') AND (route like '%$routename%') AND (distance between $dist1 AND $dist2) AND (duration between $dur1 AND $dur2) AND (portagedistance <= '$portlen') AND (routedescription like '%$routedesc%') AND (display = 'Yes')) ORDER BY route"); }
else { $result = mysql_query("Select * from Route_Master where ((regionid = '$regionid') AND (route like '%$routename%') AND (distance between $dist1 AND $dist2) AND (duration between $dur1 AND $dur2) AND (looptrip = '$looptrip') AND (portagedistance <= '$portlen') AND (routedescription like '%$routedesc%') AND (display = 'Yes')) ORDER BY route"); }
$numrows = mysql_num_rows($result);
if (empty($offset)) { $offset = 1; }
$off = $offset - 1;
if($looptrip == "Any") { $result = mysql_query("Select * from Route_Master where ((regionid = '$regionid') AND (route like '%$routename%') AND (distance between $dist1 AND $dist2) AND (duration between $dur1 AND $dur2) AND (portagedistance <= '$portlen') AND (routedescription like '%$routedesc%') AND (display = 'Yes')) ORDER BY route limit $off, $limit"); }
else { $result = mysql_query("Select * from Route_Master where ((regionid = '$regionid') AND (route like '%$routename%') AND (distance between $dist1 AND $dist2) AND (duration between $dur1 AND $dur2) AND (looptrip = '$looptrip') AND (portagedistance <= '$portlen') AND (routedescription like '%$routedesc%') AND (display = 'Yes')) ORDER BY route limit $off, $limit"); }
if ($myrow = mysql_fetch_array($result))
{
do
{
array_push($allData, $myrow["routeid"]);
$i++;
}while ($myrow = mysql_fetch_array($result));
$found = 1;
}
?>
|
|
if($found == 1)
{
echo "We found the following $numrows routes that met your criteria | ";
echo "
";
echo "";
echo " ";
foreach ($allData as $a)
{
$sql = "Select * from Route_Master where routeid = '$a'";
$result = mysql_query($sql);
$myrow = mysql_fetch_array($result);
echo "$myrow[route]";
echo " ";
}
echo " ";
}
else { echo "No routes matching this criteria were found - search again"; }
echo " |
| Pages ";
if ($offset != 1)
{
$prevoffset = $offset - $limit;
print " << previous \n";
}
$pages=intval($numrows/$limit);
if ($numrows % $limit) { $pages++; }
for ($i=1; $i<=$pages; $i++)
{
$newoffset = $limit * ($i - 1) +1;
print "$i \n";
}
if (!(($offset / $limit) == $pages) && $pages != 1)
{
$newoffset = $offset + $limit + 1;
echo " ";
if ($total > $offset + ($limit-1))
{
print "next >>\n";
}
}
?>
|