About Us Banking Information Heavy Machinery Feed Back/Inquiry Form Contact Us
open(); $db->query("SELECT manufacturer FROM manufacturers WHERE id=$make"); $r = $db->rsset(); $qry = "SELECT veh.*, make.make, GROUP_CONCAT(cnt.country SEPARATOR ', ') as country FROM vehicles veh INNER JOIN make ON make.id = veh.make_id INNER JOIN manufacturers man ON man.id = make.manufacturer_id LEFT JOIN vehicle_country vc ON vc.vehicle_id = veh.id LEFT JOIN countries cnt ON cnt.id = vc.country_id "; $qry.= " WHERE 1=1 "; if($country_id) $qry.= " AND vc.country_id=$country_id"; if($make) $qry.= " AND make.manufacturer_id=$make"; if($model) $qry.= " AND veh.make_id = $model"; if($vehicle_type) $qry.= " AND veh.vehicle_type = $vehicle_type"; $qry.= " GROUP BY veh.id ORDER BY vc.country_id ASC"; $db->query($qry); $records = $db->rows(); } ?>
Home Page >> Vehicle Search Record
You are on Vehicle Record Page.
0 record(s) found
rsset()) {?>
Stock No Picture Model Year Chassis Number Engine Number Available In More Details
'; if($r["front_view"]) echo ''; else echo ''; echo '';?> Click Here
No related record found.