include("assign.inc");
if(!$this_prod_id && !$this_prod_name ) {
redirect("index.htm");
} // end if
if(Str::has_value($this_prod_name) && $this_product_count == 0) {
redirect("index.htm");
} // end if
if(!$this_subcat_id) {
$query = "SELECT cat.cat_id FROM `prod_cat` LEFT JOIN cat on cat.cat_id = prod_cat.cat_id WHERE `prod_id` LIKE '$this_prod_id' AND cat.parent_id = '$this_parent_cat_id';";
$this_subcat_id = $db->query($query)->fetch()->cat_id;
// echo "setting subcat id to " . $this_subcat_id;
}
// Get all product attributes
$prod_attr_query = "SELECT * FROM `attrib` LEFT JOIN `prod_attrib` ON attrib.attrib_id = prod_attrib.attrib_id LEFT JOIN `prod_attrib_data` ON prod_attrib_data.prod_attrib_id = prod_attrib.prod_attrib_id WHERE prod_attrib.prod_id = '$this_prod_id' ORDER BY prod_attrib_index";
$prod_attrib_result = $db->query($prod_attr_query);
$prod_attrib_count = $prod_attrib_result->count();
$prod_attr = $prod_attrib_result->fetch(); // set first attribute for main description, then reset query
$prod_main_desc = $prod_attr->prod_attrib_data_value;
$prod_main_desc = str_replace("query($item_query);
$item_count = $item_result->count();
$item = $item_result->fetch();
$price = Str::format_currency($item->prod_item_price);
if($item_count == 0) {
$display_price = "Call For Pricing";
}
elseif($item_count > 1) {
$display_price = "Starting at " . $price;
}
else {
$display_price = $price;
}
include("head_print_friendly.inc");
?>
"; // print_r($attr_row); // echo ""; if($attr_row->attrib_name != "Overview") { $attr_count = $attr_count + 1; $attr_desc = str_replace("