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(); $item_price = $item->prod_item_price; $price = Str::format_currency($item->prod_item_price); $msrp = Str::format_currency($item->prod_item_msrp); if($item_count == 0) { $display_price = "Call For Pricing"; } elseif($item_count > 1) { $display_price = "Starting at " . $price; if($item->prod_item_promo_start) { // there is a possible promo if((date('Y-m-d') >= $item->prod_item_promo_start) && (date('Y-m-d') <= $item->prod_item_promo_end)) { $active_promo = $item->prod_item_promo_title; $display_price = "Promotional Pricing!
View Items to see our lower prices!"; // $sale_start = date('m d, Y', $item->prod_item_promo_start); } } } else { $display_price = $price; if($item->prod_item_promo_start) { // there is a possible promo if((date('Y-m-d') >= $item->prod_item_promo_start) && (date('Y-m-d') <= $item->prod_item_promo_end)) { $active_promo = $item->prod_item_promo_title; $display_price = "Promotional Pricing!
Was ". Str::format_currency($item->prod_item_price) . " - Now only " . Str::format_currency($item->prod_item_promo_price); // $sale_start = date('m d, Y', $item->prod_item_promo_start); } } } include("head.inc"); include("side_menu.inc"); include("breadcrumbs.inc"); include("menu_bar.inc"); // include("gtags_tracking.inc"); ?>
$active_promo
Sale runs from $item->prod_item_promo_start through $item->prod_item_promo_end
";} ?>

Print friendly
prod_item_msrp) { ?> prod_item_msrp) ?>

prod_item_msrp) { ?>
Quantity
bof(); ?>

fetch()) { unset($display_price); if($item->prod_item_promo_start) { // there is a possible promo if((date('Y-m-d') >= $item->prod_item_promo_start) && (date('Y-m-d') <= $item->prod_item_promo_end)) { $active_promo = $item->prod_item_promo_title; $display_price = "Was ". Str::format_currency($item->prod_item_price) . "
Promo Price " . Str::format_currency($item->prod_item_promo_price) . ""; // $sale_start = date('m d, Y', $item->prod_item_promo_start); } } else{ $display_price = Str::format_currency($item->prod_item_price); } ?>
prod_item_desc ?>
bof(); while($attr_row = $prod_attrib_result->fetch()) { if($attr_row->attrib_name != "Overview") { $attr_count = $attr_count + 1; $attr_desc = str_replace("prod_attrib_data_value); ?> bof(); ?> fetch()) { if($attr_row->attrib_name != "Overview") { $attr_count = $attr_count + 1; $attr_desc = str_replace("prod_attrib_data_value); ?>