<?php 
class Brand{ 
    function brand_list($search,$utility_class,$db){ 
      $query = "SELECT `id`, `name` FROM `lms2_vehicle_brands` WHERE name LIKE '%$search%' AND status = 1 ORDER BY name ASC;";
      return $db->sql_query($query);

    }

    function get_brand_by_name($brand_name,$utility_class,$db){
        $query = "SELECT * FROM `lms2_vehicle_brands` WHERE name = '$brand_name' AND status = 1 ORDER BY name ASC LIMIT 1;";
        return $db->sql_query($query); 
    }
}
?>