0 or sta_mo_2008 > 0 or sta_mo_2009 > 0) $make order by make,model"); } elseif($combo == 1){ $qry=mysql_query("select make_code,make,model,model_code from models where (type1 = '$type1' or type2 = '$type1' or type3 = '$type1' or type4 = '$type1' or type5 = '$type1' or type6 = '$type1' or type7 = '$type1' or type8 = '$type1' or type9 = '$type1' or type10 = '$type1' or type11 = '$type1' or type12 = '$type1' or type13 = '$type1' or type14 = '$type1' or type15 = '$type1') and (type1 = '$type2' or type2 = '$type2' or type3 = '$type2' or type4 = '$type2' or type5 = '$type2' or type6 = '$type2' or type7 = '$type2' or type8 = '$type2' or type9 = '$type2' or type10 = '$type2' or type11 = '$type2' or type12 = '$type2' or type13 = '$type2' or type14 = '$type2' or type15 = '$type2') and (sta_mo_2007 > 0 or sta_mo_2008 > 0 or sta_mo_2009 > 0) $make order by make,model"); } elseif($type1 == 'x4'){ $type1 = 'sv';$type2 = 'tr';$type3 = 's4';$type4 = 'm4';$type5 = 'u2'; $qry=mysql_query("select make_code,make,model,model_code from models where ". "((type1 = '$type1' or type2 = '$type1' or type3 = '$type1' or type4 = '$type1' or type5 = '$type1' or type6 = '$type1' or type7 = '$type1' or type8 = '$type1' or type9 = '$type1' or type10 = '$type1' or type11 = '$type1' or type12 = '$type1' or type13 = '$type1' or type14 = '$type1' or type15 = '$type1') or ". "(type1 = '$type2' or type2 = '$type2' or type3 = '$type2' or type4 = '$type2' or type5 = '$type2' or type6 = '$type2' or type7 = '$type2' or type8 = '$type2' or type9 = '$type2' or type10 = '$type2' or type11 = '$type2' or type12 = '$type2' or type13 = '$type2' or type14 = '$type2' or type15 = '$type2') or ". "(type1 = '$type3' or type2 = '$type3' or type3 = '$type3' or type4 = '$type3' or type5 = '$type3' or type6 = '$type3' or type7 = '$type3' or type8 = '$type3' or type9 = '$type3' or type10 = '$type3' or type11 = '$type3' or type12 = '$type3' or type13 = '$type3' or type14 = '$type3' or type15 = '$type3') or ". "(type1 = '$type4' or type2 = '$type4' or type3 = '$type4' or type4 = '$type4' or type5 = '$type4' or type6 = '$type4' or type7 = '$type4' or type8 = '$type4' or type9 = '$type4' or type10 = '$type4' or type11 = '$type4' or type12 = '$type4' or type13 = '$type4' or type14 = '$type4' or type15 = '$type4')) and ". "(type1 != '$type5' and type2 != '$type5' and type3 != '$type5' and type4 != '$type5' and type5 != '$type5' and type6 != '$type5' and type7 != '$type5' and type8 != '$type5' and type9 != '$type5' and type10 != '$type5' and type11 != '$type5' and type12 != '$type5' and type13 != '$type5' and type14 != '$type5' and type15 != '$type5') and ". "(sta_mo_2007 > 0 or sta_mo_2008 > 0 or sta_mo_2009 > 0) $make order by make,model"); // Reset $type-s for post form navigation $type1 = 'x4';$type2 = '';$type3 = '';$type4 = '';$type5 = ''; } elseif($type1 == 'c4'){ $name_gen = 'Four Cylinder (4cyl)'; $name_gen2 = 'Four Cylinder Vehicles'; $name1 = 'Four Cylinder Cars'; $type1 = 'c4'; $type2 = 't4'; $qry1=mysql_query("select model_id,make_code,make,model,model_code from models where (type1 = '$type1' or type2 = '$type1' or type3 = '$type1' or type4 = '$type1' or type5 = '$type1' or type6 = '$type1' or type7 = '$type1' or type8 = '$type1' or type9 = '$type1' or type10 = '$type1' or type11 = '$type1' or type12 = '$type1' or type13 = '$type1' or type14 = '$type1' or type15 = '$type1') and ". "(type1 != '$type2' and type2 != '$type2' and type3 != '$type2' and type4 != '$type2' and type5 != '$type2' and type6 != '$type2' and type7 != '$type2' and type8 != '$type2' and type9 != '$type2' and type10 != '$type2' and type11 != '$type2' and type12 != '$type2' and type13 != '$type2' and type14 != '$type2' and type15 != '$type2') and (sta_mo_2007 > 0 or sta_mo_2008 > 0 or sta_mo_2009 > 0) $make order by make,model"); $name2 = 'Four Cylinder SUVs and Trucks'; $type1 = 't4'; $qry2=mysql_query("select make_code,make,model,model_code from models where ". "(type1 = '$type1' or type2 = '$type1' or type3 = '$type1' or type4 = '$type1' or type5 = '$type1' or type6 = '$type1' or type7 = '$type1' or type8 = '$type1' or type9 = '$type1' or type10 = '$type1' or type11 = '$type1' or type12 = '$type1' or type13 = '$type1' or type14 = '$type1' or type15 = '$type1') and ". "(sta_mo_2007 > 0 or sta_mo_2008 > 0 or sta_mo_2009 > 0) $make order by make,model"); $type1='c4';$type2=''; } else{ $qry=mysql_query("select model_id,make_code,make,model,model_code from models where (type1 = '$type1' or type2 = '$type1' or type3 = '$type1' or type4 = '$type1' or type5 = '$type1' or type6 = '$type1' or type7 = '$type1' or type8 = '$type1' or type9 = '$type1' or type10 = '$type1' or type11 = '$type1' or type12 = '$type1' or type13 = '$type1' or type14 = '$type1' or type15 = '$type1') and (sta_mo_2007 > 0 or sta_mo_2008 > 0 or sta_mo_2009 > 0) $make order by make,model"); } if($type1 == 'c4'){ $count = mysql_num_rows($qry1); $count += mysql_num_rows($qry2); }else{ $count = mysql_num_rows($qry); } ?> PriceQuotes.com - Compare <? if(strstr($_SESSION['pq_keyword'],"leas")){echo "Lease";}else{echo "Price";} ?> Quotes on All New<? echo $make_name." ".$name; ?>
 New Cars >
Click to verify BBB accreditation and to see a BBB report.
 New Cars >



     Get Quotes On the Most Fuel Efficient Cars, Trucks, Minivans and SUVs Get Quotes On A New Four Cylinder (4cyl) Vehicle Get Quotes On A New     Models
Jump To:   Four Cylinder Cars  |  Four Cylinder SUVs and Trucks
Click a Model To Continue
";} $mo_year = $year; $make_code=$t['make_code'];$make=$t['make']; if($make_code=='210'){if($t['model']=="Ram Pickup 1500 SRT-10"){$model="Ram SRT-10";}elseif($t['model']=="Sprinter Passenger Van"){$model="Sprinter Pass Van";}elseif($t['model']=="Sprinter Cargo"){$model="Sprinter Cargo Van";}else{$model=$t['model'];}}else{$model=$t['model'];} $models_code=$t['model_code']; $review_exists=0; if($mr=mysql_fetch_array(mysql_query("select model_id from reviews where make_code='$make_code' and model_code='$models_code'"))){$review_exists=1;} ?> "."";} } ?>
">.jpg" alt="" border="1"><? echo $make." border="0">
">
">.jpg" alt="" border="1">
">

Best Possible MPG:
".$model_epa['epa'];} ?>
";} $mo_year = $year; $make_code=$t['make_code'];$make=$t['make']; if($make_code=='210'){if($t['model']=="Ram Pickup 1500 SRT-10"){$model="Ram SRT-10";}elseif($t['model']=="Sprinter Passenger Van"){$model="Sprinter Pass Van";}elseif($t['model']=="Sprinter Cargo"){$model="Sprinter Cargo Van";}else{$model=$t['model'];}}else{$model=$t['model'];} $models_code=$t['model_code']; $review_exists=0; if($mr=mysql_fetch_array(mysql_query("select model_id from reviews where make_code='$make_code' and model_code='$models_code'"))){$review_exists=1;} ?> "."";} }?>
">.jpg" alt="" border="1"><? echo $make." border="0">
">
">.jpg" alt="" border="1">
">

Best Possible MPG:
".$model_epa['epa'];} ?>
";} $mo_year = $year; $make_code=$t['make_code'];$make=$t['make']; if($make_code=='210'){if($t['model']=="Ram Pickup 1500 SRT-10"){$model="Ram SRT-10";}elseif($t['model']=="Sprinter Passenger Van"){$model="Sprinter Pass Van";}elseif($t['model']=="Sprinter Cargo"){$model="Sprinter Cargo Van";}else{$model=$t['model'];}}else{$model=$t['model'];} $models_code=$t['model_code']; $review_exists=0; if($mr=mysql_fetch_array(mysql_query("select model_id from reviews where make_code='$make_code' and model_code='$models_code'"))){$review_exists=1;} ?> "."";} }?>
">.jpg" alt="" border="1"><? echo $make." border="0">
">
">.jpg" alt="" border="1">
">

Best Possible MPG:
".$model_epa['epa'];} ?>