CALL US : (727) 344-9640
Reviews
notify('NOTIFY_HEADER_START_PRODUCT_REVIEWS_INFO'); if (isset($_GET['reviews_id']) && zen_not_null($_GET['reviews_id']) && isset($_GET['products_id']) && zen_not_null($_GET['products_id'])) {// check product exists and current// if product does not exist or is status 0 send to _info page $products_reviews_check_query = "SELECT count(*) AS count FROM " . TABLE_PRODUCTS . " p WHERE p.products_id= :productsID AND p.products_status = 1"; $products_reviews_check_query = $db->bindVars($products_reviews_check_query, ':productsID', $_GET['products_id'], 'integer'); $products_reviews_check = $db->Execute($products_reviews_check_query); if ($products_reviews_check->fields['count'] < 1) { zen_redirect(zen_href_link(zen_get_info_page((int)$_GET['products_id']), 'products_id=' . (int)$_GET['products_id'])); }// count reviews for additional link// if review must be approved or disabled do not show review $review_status = " and r.status = '1'"; $reviews_count_query = "SELECT count(*) as count FROM " . TABLE_REVIEWS . " r, " . TABLE_REVIEWS_DESCRIPTION . " rd WHERE r.products_id = :productsID AND r.reviews_id = rd.reviews_id AND rd.languages_id = :languagesID " . $review_status; $reviews_count_query = $db->bindVars( $reviews_count_query, ':productsID', $_GET['products_id'], 'integer'); $reviews_count_query = $db->bindVars( $reviews_count_query, ':languagesID', $_SESSION['languages_id'], 'integer'); $reviews_count = $db->Execute($reviews_count_query); $reviews_counter = $reviews_count->fields['count'];// if review must be approved or disabled do not show review $review_status = " and r.status = '1'"; $review_info_check_query = "SELECT count(*) AS total FROM " . TABLE_REVIEWS . " r, " . TABLE_REVIEWS_DESCRIPTION . " rd WHERE r.reviews_id = :reviewsID AND r.products_id = :productsID AND r.reviews_id = rd.reviews_id AND rd.languages_id = :languagesID " . $review_status; $review_info_check_query = $db->bindVars($review_info_check_query, ':reviewsID', $_GET['reviews_id'], 'integer'); $review_info_check_query = $db->bindVars($review_info_check_query, ':productsID', $_GET['products_id'], 'integer'); $review_info_check_query = $db->bindVars($review_info_check_query, ':languagesID', $_SESSION['languages_id'], 'integer'); $review_info_check = $db->Execute($review_info_check_query); if ($review_info_check->fields['total'] < 1) { zen_redirect(zen_href_link(FILENAME_PRODUCT_REVIEWS, zen_get_all_get_params(array('reviews_id')))); } } else { zen_redirect(zen_href_link(FILENAME_PRODUCT_REVIEWS, zen_get_all_get_params(array('reviews_id')))); } $sql = "UPDATE " . TABLE_REVIEWS . " SET reviews_read = reviews_read+1 WHERE reviews_id = :reviewsID"; $sql = $db->bindVars($sql, ':reviewsID', $_GET['reviews_id'], 'integer'); $db->Execute($sql); $review_info_query = "SELECT rd.reviews_text, r.reviews_rating, r.reviews_id, r.customers_name, r.date_added, r.reviews_read, p.products_id, p.products_price, p.products_tax_class_id, p.products_image, p.products_model, pd.products_name FROM " . TABLE_REVIEWS . " r, " . TABLE_REVIEWS_DESCRIPTION . " rd, " . TABLE_PRODUCTS . " p, " . TABLE_PRODUCTS_DESCRIPTION . " pd WHERE r.reviews_id = :reviewsID AND r.reviews_id = rd.reviews_id AND rd.languages_id = :languagesID AND r.products_id = p.products_id AND p.products_status = '1' AND p.products_id = pd.products_id AND pd.language_id = :languagesID " . $review_status; $review_info_query = $db->bindVars($review_info_query, ':reviewsID', $_GET['reviews_id'], 'integer'); $review_info_query = $db->bindVars($review_info_query, ':languagesID', $_SESSION['languages_id'], 'integer'); $review_info = $db->Execute($review_info_query); $products_price = zen_get_products_display_price($review_info->fields['products_id']); $products_name = $review_info->fields['products_name']; if ($review_info->fields['products_model'] != '') { $products_model = '
[' . $review_info->fields['products_model'] . ']'; } else { $products_model = ''; }// set image// $products_image = $review_info->fields['products_image']; if ($review_info->fields['products_image'] == '' and PRODUCTS_IMAGE_NO_IMAGE_STATUS == '1') { $products_image = PRODUCTS_IMAGE_NO_IMAGE; } else { $products_image = $review_info->fields['products_image']; } require(DIR_WS_MODULES . zen_get_module_directory('require_languages.php')); $breadcrumb->add(NAVBAR_TITLE); // This should be last line of the script: $zco_notifier->notify('NOTIFY_HEADER_END_PRODUCT_REVIEWS_INFO');?>

Price :


Forgive me if I gush - this is the most comfortable sport-style racer-back bra in the universe! No exaggeration: 1. under bust wrap band feature is super comfortable and non-binding 2. wide, covered straps do not bind, chafe or hurt tender shoulders (even after two shoulder surgeries) 3. accommodates large (38J) bust size without creating uniboob or total compression attempts and finally 5. very comfortable for lounge, sleep or casual wear. I sewed them up without seeing blog videos, but they are a great guide - I was too eager to sew it up and didn't stop to look first.