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 :


I was one of the testers for this pattern and I struggled a little since the pattern called for skills I had never tried before (the sweetheart neckline, the heart shape in the back, the criss cross front, the slick way to do the shoulder straps to prevent bulk, and the way to prevent the elastic from directly touching the skin and keeping all seams enclosed.) Once I completed the bra, I wondered why I had never tried any of these techniques before! This is the first sports bra that I have made that fits correctly without a bunch of modifications ( and I have tried several patterns to get a pattern in my size a 46M.) I wore it all day the other day without issues of it riding up, the dreaded looking uniboob, or the straps digging in uncomfortably. If you want a great fitting bra from the first try, I suggest you give this pattern a whirl!

On a side note, I loved the plush elastic for the shoulder straps that came in the bra kit and plan on buying more to use for the waistband on some UnderArmour type of bike shorts.