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

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