Search Rides
Browse Rides
if (!isset($orderby)) { $orderby = "`overall_rate` DESC"; }
echo '
';
$tmp = 1;
$upquery = mysql_query("SELECT * FROM `cars`".$searchq." ORDER BY ".$orderby." LIMIT ".$start." , ".$perpage);
//echo "SELECT * FROM `cars`".$searchq." ORDER BY ".$orderby." LIMIT ".$start." , ".$perpage;
while ($uprow = mysql_fetch_assoc($upquery)) {
$pquery = mysql_query("SELECT * FROM `pics` WHERE `id` = '".$uprow['default_pic']."' LIMIT 1");
$prow = mysql_fetch_assoc($pquery);
echo ' '.$uprow['year'].' '.$makes[$uprow['make']].' '.stripslashes($uprow['model']).' | ';
if ($tmp == 5) { echo '
'; $tmp = 0; }
$tmp++;
}
?>
Pages:
$temp = 1;
if (isset($q)) { $q = str_replace(" ","+",$q); }
while ($temp <= $pages) {
if ($page == $temp) {
echo '
'.$page.' ';
}
else
{
if ($_GET['orderby'] == "latest") {
if (isset($_GET['q'])) {
echo '
'.$temp.' ';
}
else
{
echo '
'.$temp.' ';
}
}
else
{
if (isset($_GET['q'])) {
echo '
'.$temp.' ';
}
else
{
echo '
'.$temp.' ';
}
}
}
$temp++;
}
?>
include("footer.php");
?>
include ("footerbottom.php");
?>