prepare("SELECT `id`,`name` FROM `ranges` WHERE `name` LIKE '$range_name' "); $get_range->execute(); $row = $get_range->fetch(PDO::FETCH_ASSOC); $range_id = $row['id']; $rang_name = $row['name']; $rang_url = "/range/".nice_url($rang_name)."/"; ?> Products
  • $page_title
  • "; include("inc/sub-hdr.php"); ?>

    Roofing Solutions      View All Solutions

    prepare("SELECT `id`,`name`,`images` FROM `stock` WHERE FIND_IN_SET(:r_id,`range_ids`) AND `status` < 1 ORDER BY `name` "); $get_prods->bindParam(":r_id",$range_id); $get_prods->execute(); // while($row = $get_prods->fetch(PDO::FETCH_ASSOC)) { $prod_id = $row['id']; $prod_name = $row['name']; $prod_img_arr = explode(",",$row['images']); $prod_img = $prod_img_arr[0]; if($prod_img == false) { $prod_img = "/img/no-pic.jpg"; } $prod_thu = str_replace("/media/","/media-thu/",$prod_img); $range_ids_arr = explode(",",$row['range_ids']); $range_id = $range_ids_arr[0]; $prod_url = "/product/".nice_url($prod_name)."/$prod_id/"; if($range_name == "Trims" || $range_name == "Equipment") { ?>
    ,

    Contact:    Technical Team:    Send an Email Demo Day:    Book to Attend
    ยง