Roofing Solutions View All Solutions
$get_prods = $conn->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") { ?>
} else { ?>
}
}
?>