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"); ?>

prod_item_price * 1.15) ?>

Quantity
bof(); ?>

fetch()) { ?>
prod_item_desc ?>
prod_item_price) ?>
query($prod_attr_query); while($attr_row = $prod_attrib_result->fetch()) { // echo "
";
           // print_r($attr_row);
           // echo "
"; if($attr_row->attrib_name != "Overview") { $attr_count = $attr_count + 1; $attr_desc = str_replace("prod_attrib_data_value); ?>