"; ?>

Vehicle make: AllAll= 1){ while($catData22 = @mysql_fetch_array($get_cat22)){ $catId22 = trim($catData22['id']); $catTitle22 = stripslashes (htmlspecialchars (trim($catData22['title']))); if($_GET['cid'] == $catId22 || $_GET['cid'] == $catId22){ if( $_GET['cid'] =="All"){ }else{ ?>"/>"/>No Make found Vehicle model: AllAll= 1){ while($scatData22 = @mysql_fetch_array($get_scat22)){ $scatId22 = trim($scatData22['id']); $scatTitle22 = stripslashes (htmlspecialchars (trim($scatData22['title']))); if($_GET['sid'] == $scatId22){ //if($_GET['sid'] == $scatId22 || $_GET['sid'] == $scatId22){ ?>"/>"/> Milage below: 0; $i-=25000){ if($display!="" && $i == $milage){ print "";print $milage;print ""; }else{ print "";print $i;print ""; } } ?> Price below: 1000 1000 5000 5000 10000 10000 15000 15000 25000 25000 50000 50000 100000 100000 150000 150000 Year below: "; print $listItem; print ""; }else{ print ""; print $listItem; print ""; } $listItem = $listItem - 1; } while (++$count < $numYearstoList); ?> Type: All All Sedan Sedan Wagon Wagon Van/Minivan Van/Minivan Coupe Coupe Pickup Pickup Luxury Luxury Convertible Convertible SUV SUV Hybrid Hybrid Hatchback Hatchback $scatTitle"; if($items_total >= 1){ $totalPages = $real_total_items/$total_items_to_show; $totalPagesRounded = ceil($totalPages); if($totalPagesRounded == 1){ //echo " $real_total_items item(s) found in $totalPagesRounded page   "; $get_starter_item_visible = $get_starter_item+1; $total_items_to_show_visible = $total_items_to_show * $get_current_page; if($get_current_page >= $totalPagesRounded){ //echo "Viewing item(s): $get_starter_item_visible - $real_total_items "; }else{ //echo "Viewing item(s): $get_starter_item_visible - $total_items_to_show_visible  "; } //echo"Page: $get_current_page"; }else{ //echo "$real_total_items item(s) found in $totalPagesRounded pages   "; $get_starter_item_visible = $get_starter_item+1; $total_items_to_show_visible = $total_items_to_show * $get_current_page; if($get_current_page >= $totalPagesRounded){ //echo "Viewing item(s): $get_starter_item_visible - $real_total_items Page: $get_current_page  "; }else{ //echo "Viewing item(s): $get_starter_item_visible - $total_items_to_show_visible Page: $get_current_page  "; } //echo"Page: $get_current_page"; } echo"Page: "; for($i=0; $i < $totalPagesRounded; $i++){ $currentPage = $i ; $offsetter = $currentPage * $total_items_to_show; if($i>0){ $starter_item = 0+ $currentPage * $total_items_to_show ; }else{ $starter_item = 0; } $show = $starter_item + $total_items_to_show ; if($show==0){ $show=$total_items_to_show; } $i2 = $i+1; if($i2 == $get_current_page){ echo " ".($i +1)." "; //echo "".($i +1)." "; }else{ echo " ".($i +1)." "; } }; while($itemData = @mysql_fetch_array($get_items)){ $item_id = trim($itemData['id']); $item_cid = trim($itemData['cid']); $item_sid = trim($itemData['sid']); $item_make= trim($itemData['make']); $item_model = trim($itemData['model']); $item_year = trim($itemData['year']); $item_milage = trim($itemData['milage']); $item_condition = trim($itemData['condition']); $item_price = trim($itemData['price']); $item_comments = trim($itemData['comments']); $item_style = trim($itemData['style']); $item_doors = trim($itemData['doors']); $item_posted = strftime("%d-%m-%y", trim($itemData['posted'])); $item_isLive = trim($itemData['isLive']); ?> '; $images_result_for_real_total = @mysql_query("select id from images"); $real_total_images = @mysql_num_rows($images_result_for_real_total); $image_result = @mysql_query("select * from images WHERE itemId='$item_id' LIMIT 0,1"); $total_images = @mysql_num_rows($image_result); if($total_images >= 1){ while($edit_itemImagesData = @mysql_fetch_array($image_result)){ $edit_itemImages_id = trim($edit_itemImagesData['id']); $edit_itemImages_itemId = trim($edit_itemImagesData['itemId']); $edit_itemImages_image = trim($edit_itemImagesData['image']); $file_ext = get_ext($edit_itemImages_image); $stippedfilename = strip_ext($edit_itemImages_image); $original = "items/$edit_itemImages_itemId/$edit_itemImages_image"; $thumb50 = "items/$edit_itemImages_itemId/$stippedfilename"."_thumb_50.".$file_ext; $thumb100 = "items/$edit_itemImages_itemId/$stippedfilename"."_thumb_100.".$file_ext; $thumb200 = "items/$edit_itemImages_itemId/$stippedfilename"."_thumb_200.".$file_ext; ?> " > " style="border:1px solid #eee;"/> " > "; echo'"; ?> '; echo"$item_make - $item_model "; echo"Year: $item_year   "; echo" Price: ".'$'."$item_price    "; echo"Type: $item_style   "; echo"Miles: $item_milage "; //echo"Doors: $item_doors "; echo"Comments: $item_comments "; echo" "; } }else{ } if($_GET['cid'] != "" && $_GET['sid'] != "" ){ $get_starter_item = $_GET['start']; if($get_starter_item ==""){$get_starter_item = 0;} $get_current_page = $_GET['curr']; if($get_current_page ==""){$get_current_page = 1;} $total_items_to_show=6; $get_cId = $_GET['cid']; $get_sId = $_GET['sid']; $items_result_for_real_total = @mysql_query("select id from items WHERE (cid='$get_cId' AND sid='$get_sId' AND isLive='yes') Order by year desc "); $real_total_items = @mysql_num_rows($items_result_for_real_total); $get_items = @mysql_query("select * from items WHERE (cid='$get_cId' AND sid='$get_sId' AND isLive='yes') Order by year desc LIMIT $get_starter_item,$total_items_to_show"); $items_total = @mysql_num_rows($get_items); //echo" $scatTitle "; if($items_total >= 1){ $totalPages = $real_total_items/$total_items_to_show; $totalPagesRounded = ceil($totalPages); if($totalPagesRounded == 1){ //echo " $real_total_items item(s) found in $totalPagesRounded page   "; $get_starter_item_visible = $get_starter_item+1; $total_items_to_show_visible = $total_items_to_show * $get_current_page; if($get_current_page >= $totalPagesRounded){ //echo "Viewing item(s): $get_starter_item_visible - $real_total_items "; }else{ //echo "Viewing item(s): $get_starter_item_visible - $total_items_to_show_visible  "; } //echo"Page: $get_current_page"; }else{ //echo "$real_total_items item(s) found in $totalPagesRounded pages   "; $get_starter_item_visible = $get_starter_item+1; $total_items_to_show_visible = $total_items_to_show * $get_current_page; if($get_current_page >= $totalPagesRounded){ //echo "Viewing item(s): $get_starter_item_visible - $real_total_items Page: $get_current_page  "; }else{ //echo "Viewing item(s): $get_starter_item_visible - $total_items_to_show_visible Page: $get_current_page  "; } //echo"Page: $get_current_page"; } echo"Page: "; for($i=0; $i < $totalPagesRounded; $i++){ $currentPage = $i ; $offsetter = $currentPage * $total_items_to_show; if($i>0){ $starter_item = 0+ $currentPage * $total_items_to_show ; }else{ $starter_item = 0; } $show = $starter_item + $total_items_to_show ; if($show==0){ $show=$total_items_to_show; } $i2 = $i+1; if($i2 == $get_current_page){ echo " ".($i +1)." "; //echo "".($i +1)." "; }else{ echo " ".($i +1)." "; } }; while($itemData = @mysql_fetch_array($get_items)){ $item_id = trim($itemData['id']); $item_cid = trim($itemData['cid']); $item_sid = trim($itemData['sid']); $item_make= trim($itemData['make']); $item_model = trim($itemData['model']); $item_year = trim($itemData['year']); $item_milage = trim($itemData['milage']); $item_condition = trim($itemData['condition']); $item_price = trim($itemData['price']); $item_comments = trim($itemData['comments']); $item_style = trim($itemData['style']); $item_doors = trim($itemData['doors']); $item_posted = strftime("%d-%m-%y", trim($itemData['posted'])); $item_isLive = trim($itemData['isLive']); ?> '; $images_result_for_real_total = @mysql_query("select id from images"); $real_total_images = @mysql_num_rows($images_result_for_real_total); $image_result = @mysql_query("select * from images WHERE itemId='$item_id' LIMIT 0,1"); $total_images = @mysql_num_rows($image_result); if($total_images >= 1){ while($edit_itemImagesData = @mysql_fetch_array($image_result)){ $edit_itemImages_id = trim($edit_itemImagesData['id']); $edit_itemImages_itemId = trim($edit_itemImagesData['itemId']); $edit_itemImages_image = trim($edit_itemImagesData['image']); $file_ext = get_ext($edit_itemImages_image); $stippedfilename = strip_ext($edit_itemImages_image); $original = "items/$edit_itemImages_itemId/$edit_itemImages_image"; $thumb50 = "items/$edit_itemImages_itemId/$stippedfilename"."_thumb_50.".$file_ext; $thumb100 = "items/$edit_itemImages_itemId/$stippedfilename"."_thumb_100.".$file_ext; $thumb200 = "items/$edit_itemImages_itemId/$stippedfilename"."_thumb_200.".$file_ext; ?> " > " style="border:1px solid #eee;"/> " > "; echo'"; ?> '; echo"$item_make - $item_model "; echo"Year: $item_year   "; echo" Price: ".'$'."$item_price    "; echo"Type: $item_style   "; echo"Miles: $item_milage "; //echo"Doors: $item_doors "; echo"Comments: $item_comments "; echo" "; } }else{ } if($_GET['cid'] == "" && $_GET['sid'] == ""){ //echo""; $get_cId = $_GET['cid']; $get_sId = $_GET['sid']; $get_starter_item = $_GET['start']; if($get_starter_item ==""){$get_starter_item = 0;} $get_current_page = $_GET['curr']; if($get_current_page ==""){$get_current_page = 1;} $total_items_to_show=6; $items_result_for_real_total = @mysql_query("select id from items WHERE special='yes' AND isLive='yes' Order by year desc "); $real_total_items = @mysql_num_rows($items_result_for_real_total); $get_items = @mysql_query("select * from items WHERE special='yes' AND isLive='yes' Order by year desc LIMIT $get_starter_item,$total_items_to_show"); $items_total = @mysql_num_rows($get_items); //$get_items = @mysql_query("select * from items WHERE cid='$get_cId ' Order by year desc"); //$items_total =@mysql_num_rows($get_items); //echo" $scatTitle "; if($items_total >= 1){ $totalPages = $real_total_items/$total_items_to_show; $totalPagesRounded = ceil($totalPages); if($totalPagesRounded == 1){ //echo " $real_total_items item(s) found in $totalPagesRounded page   "; $get_starter_item_visible = $get_starter_item+1; $total_items_to_show_visible = $total_items_to_show * $get_current_page; if($get_current_page >= $totalPagesRounded){ //echo "Viewing item(s): $get_starter_item_visible - $real_total_items "; }else{ //echo "Viewing item(s): $get_starter_item_visible - $total_items_to_show_visible  "; } //echo"Page: $get_current_page"; }else{ //echo "$real_total_items item(s) found in $totalPagesRounded pages   "; $get_starter_item_visible = $get_starter_item+1; $total_items_to_show_visible = $total_items_to_show * $get_current_page; if($get_current_page >= $totalPagesRounded){ //echo "Viewing item(s): $get_starter_item_visible - $real_total_items Page: $get_current_page  "; }else{ //echo "Viewing item(s): $get_starter_item_visible - $total_items_to_show_visible Page: $get_current_page  "; } //echo"Page: $get_current_page"; } echo"Specials: "; for($i=0; $i < $totalPagesRounded; $i++){ $currentPage = $i ; $offsetter = $currentPage * $total_items_to_show; if($i>0){ $starter_item = 0+ $currentPage * $total_items_to_show ; }else{ $starter_item = 0; } $show = $starter_item + $total_items_to_show ; if($show==0){ $show=$total_items_to_show; } $i2 = $i+1; if($i2 == $get_current_page){ echo " ".($i +1)." "; //echo "".($i +1)." "; }else{ echo " ".($i +1)." "; } }; while($itemData = @mysql_fetch_array($get_items)){ $item_id = trim($itemData['id']); $item_cid = trim($itemData['cid']); $item_sid = trim($itemData['sid']); $item_make= trim($itemData['make']); $item_model = trim($itemData['model']); $item_year = trim($itemData['year']); $item_milage = trim($itemData['milage']); $item_condition = trim($itemData['condition']); $item_price = trim($itemData['price']); $item_comments = trim($itemData['comments']); $item_style = trim($itemData['style']); $item_doors = trim($itemData['doors']); $item_posted = strftime("%d-%m-%y", trim($itemData['posted'])); $item_isLive = trim($itemData['isLive']); ?> '; $images_result_for_real_total = @mysql_query("select id from images"); $real_total_images = @mysql_num_rows($images_result_for_real_total); $image_result = @mysql_query("select * from images WHERE itemId='$item_id' LIMIT 0,1"); $total_images = @mysql_num_rows($image_result); if($total_images >= 1){ while($edit_itemImagesData = @mysql_fetch_array($image_result)){ $edit_itemImages_id = trim($edit_itemImagesData['id']); $edit_itemImages_itemId = trim($edit_itemImagesData['itemId']); $edit_itemImages_image = trim($edit_itemImagesData['image']); $file_ext = get_ext($edit_itemImages_image); $stippedfilename = strip_ext($edit_itemImages_image); $original = "items/$edit_itemImages_itemId/$edit_itemImages_image"; $thumb50 = "items/$edit_itemImages_itemId/$stippedfilename"."_thumb_50.".$file_ext; $thumb100 = "items/$edit_itemImages_itemId/$stippedfilename"."_thumb_100.".$file_ext; $thumb200 = "items/$edit_itemImages_itemId/$stippedfilename"."_thumb_200.".$file_ext; ?> " > " style="border:1px solid #eee;"/> " > "; echo'"; ?> '; echo"$item_make - $item_model "; echo"Year: $item_year   "; echo" Price: ".'$'."$item_price    "; echo"Type: $item_style   "; echo"Miles: $item_milage "; //echo"Doors: $item_doors "; echo"Comments: $item_comments "; echo" "; } }else{ } } ?> "; //echo"sid = $get_sid "; //echo"milage= $get_milage "; //echo"price=$get_price "; //echo"year= $get_year "; //echo"style=$get_style "; //make LIKE '%$search%' AND year LIKE '%$search%' if($get_style == "All"){ $extaQuery = "(price <= $get_price AND milage <= $get_milage AND year <= $get_year AND isLive='yes')"; }else{ $extaQuery = "(price <= $get_price AND milage <= $get_milage AND year <= $get_year AND style LIKE '%$get_style%' AND isLive='yes')"; } if($get_cid == "All"){ if($get_sid == "All"){ $get_search_item = @mysql_query("select * from items WHERE $extaQuery AND ($extaQuery) LIMIT $get_starter_item,$total_items_to_show"); $items_result_for_real_total = @mysql_query("select id from items WHERE $extaQuery AND ($extaQuery) "); $real_total_items = @mysql_num_rows($items_result_for_real_total); }else{ $get_search_item = @mysql_query("select * from items WHERE sid='$get_sid' AND ($extaQuery) LIMIT $get_starter_item,$total_items_to_show"); $items_result_for_real_total = @mysql_query("select id from items WHERE sid='$get_sid' AND ($extaQuery) "); $real_total_items = @mysql_num_rows($items_result_for_real_total); } }else{ if($get_sid == "All"){ $get_search_item = @mysql_query("select * from items WHERE cid='$get_cid' AND ($extaQuery) LIMIT $get_starter_item,$total_items_to_show"); $items_result_for_real_total = @mysql_query("select id from items WHERE cid='$get_cid' AND ($extaQuery) "); $real_total_items = @mysql_num_rows($items_result_for_real_total); }else{ $get_search_item = @mysql_query("select * from items WHERE cid='$get_cid' AND (sid='$get_sid' AND $extaQuery) LIMIT $get_starter_item,$total_items_to_show"); $items_result_for_real_total = @mysql_query("select id from items WHERE cid='$get_cid' AND (sid='$get_sid' AND $extaQuery)"); $real_total_items = @mysql_num_rows($items_result_for_real_total); } } $search_item_total =@mysql_num_rows($get_search_item); if($search_item_total >= 1){ $totalPages = $real_total_items/$total_items_to_show; $totalPagesRounded = ceil($totalPages); if($totalPagesRounded == 1){ //echo " $real_total_items item(s) found in $totalPagesRounded page   "; $get_starter_item_visible = $get_starter_item+1; $total_items_to_show_visible = $total_items_to_show * $get_current_page; if($get_current_page >= $totalPagesRounded){ //echo "Viewing item(s): $get_starter_item_visible - $real_total_items "; }else{ //echo "Viewing item(s): $get_starter_item_visible - $total_items_to_show_visible  "; } //echo"Page: $get_current_page"; }else{ //echo "$real_total_items item(s) found in $totalPagesRounded pages   "; $get_starter_item_visible = $get_starter_item+1; $total_items_to_show_visible = $total_items_to_show * $get_current_page; if($get_current_page >= $totalPagesRounded){ //echo "Viewing item(s): $get_starter_item_visible - $real_total_items Page: $get_current_page  "; }else{ //echo "Viewing item(s): $get_starter_item_visible - $total_items_to_show_visible Page: $get_current_page  "; } //echo"Page: $get_current_page"; } echo"Page: "; for($i=0; $i < $totalPagesRounded; $i++){ $currentPage = $i ; $offsetter = $currentPage * $total_items_to_show; if($i>0){ $starter_item = 0+ $currentPage * $total_items_to_show ; }else{ $starter_item = 0; } $show = $starter_item + $total_items_to_show ; if($show==0){ $show=$total_items_to_show; } $i2 = $i+1; if($i2 == $get_current_page){ echo " ".($i +1)." "; //echo "".($i +1)." "; }else{ echo " ".($i +1)." "; } }; while($search_itemData = @mysql_fetch_array($get_search_item)){ $search_item_id = trim($search_itemData['id']); $search_item_cid = trim($search_itemData['cid']); $search_item_sid = trim($search_itemData['sid']); $search_item_make= trim($search_itemData['make']); $search_item_model = trim($search_itemData['model']); $search_item_year = trim($search_itemData['year']); $search_item_milage = trim($search_itemData['milage']); $search_item_condition = trim($search_itemData['condition']); $search_item_price = trim($search_itemData['price']); $search_item_comments = trim($search_itemData['comments']); $search_item_posted = trim($search_itemData['posted']); $search_item_style = trim($search_itemData['style']); $search_item_isLive = trim($search_itemData['isLive']); ?> '; $images_result_for_real_total = @mysql_query("select id from images"); $real_total_images = @mysql_num_rows($images_result_for_real_total); $image_result = @mysql_query("select * from images WHERE itemId='$search_item_id' LIMIT 0,1"); $total_images = @mysql_num_rows($image_result); if($total_images >= 1){ while($edit_itemImagesData = @mysql_fetch_array($image_result)){ $edit_itemImages_id = trim($edit_itemImagesData['id']); $edit_itemImages_itemId = trim($edit_itemImagesData['itemId']); $edit_itemImages_image = trim($edit_itemImagesData['image']); $file_ext = get_ext($edit_itemImages_image); $stippedfilename = strip_ext($edit_itemImages_image); $original = "items/$edit_itemImages_itemId/$edit_itemImages_image"; $thumb50 = "items/$edit_itemImages_itemId/$stippedfilename"."_thumb_50.".$file_ext; $thumb100 = "items/$edit_itemImages_itemId/$stippedfilename"."_thumb_100.".$file_ext; $thumb200 = "items/$edit_itemImages_itemId/$stippedfilename"."_thumb_200.".$file_ext; ?> " > " style="border:1px solid #eee;"/> " > "; echo'"; ?> '; echo"$search_item_make - $search_item_model "; echo"Year: $search_item_year   "; echo" Price: ".'$'."$search_item_price    "; echo"Type: $search_item_style   "; echo"Miles: $search_item_milage "; //echo"Doors: $item_doors "; echo"Comments: $search_item_comments "; echo"

"; $totalPages = $real_total_images/$total_images_to_show; $totalPagesRounded = ceil($totalPages); if($totalPagesRounded == 1){ //echo " $real_total_images image(s) found in $totalPagesRounded page  
"; $get_starter_item_visible = $get_starter_item+1; $total_images_to_show_visible = $total_images_to_show * $get_current_page; if($get_current_page >= $totalPagesRounded){ //echo "Viewing image(s): $get_starter_item_visible - $real_total_images
"; }else{ //echo "Viewing image(s): $get_starter_item_visible - $total_images_to_show_visible
 "; } //echo"Page: $get_current_page"; }else{ //echo "$real_total_images image(s) found in $totalPagesRounded pages  
"; $get_starter_item_visible = $get_starter_item+1; $total_images_to_show_visible = $total_images_to_show * $get_current_page; if($get_current_page >= $totalPagesRounded){ //echo "Viewing image(s): $get_starter_item_visible - $real_total_images
Page: $get_current_page 
"; }else{ //echo "Viewing image(s): $get_starter_item_visible - $total_images_to_show_visible
Page: $get_current_page 
"; } //echo"Page: $get_current_page"; } //echo"Page: $get_current_page"; echo ""; for($i=0; $i < $totalPagesRounded; $i++){ $currentPage = $i ; $offsetter = $currentPage * $total_images_to_show; if($i>0){ $starter_item = 0+ $currentPage * $total_images_to_show ; }else{ $starter_item = 0; } $show = $starter_item + $total_images_to_show ; if($show==0){ $show=$total_images_to_show; } $i2 = $i+1; if($i2 == $get_current_page){ echo " ".($i +1)." | "; //echo "".($i +1)." "; }else{ echo " ".($i +1)." | "; } }; */ ?>