prepare("SELECT * FROM `stock` WHERE `id` = :prod_id AND `status` < 1 "); $get_prod->bindParam(":prod_id",$i); //Get Range $get_range = $conn->prepare("SELECT `id`,`name` FROM `ranges` WHERE `id` = :r_id "); $get_range->bindParam(":r_id",$range_id); //Temp info. //Get the product info $get_prod->execute(); $row = $get_prod->fetch(PDO::FETCH_ASSOC); $prod_id = $row['id']; $prod_name = $row['name']; $prod_desc = $row['description']; $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)."/"; // Get range info. $get_range->execute(); $row2 = $get_range->fetch(PDO::FETCH_ASSOC); $rang_name = $row2['name']; $rang_url = "/range/".nice_url($rang_name)."/"; ?> ⋮ ⋮
Products
  • $rang_name
  • $prod_name
    • "; include("inc/sub-hdr.php"); ?>

    In Range:

    Related Files
    Spec Sheet */ ?>
    Attribute Value accumsan at tellus eget xxxxx accumsan at tellus eget xxxxx accumsan at tellus eget xxxxx accumsan at tellus eget xxxxx accumsan at tellus eget xxxxx accumsan at tellus eget xxxxx */?>

    Talk to us about
    VIEW OUR COMPLETE PRODUCT RANGE