alert('Sorry!!! Your selected product id #$products_id is inactivated in our inventory'); window.location = 'index.html'; "; } //echo $metal_id; #print_r($_COOKIE); $accounts_id = getSessionAccountId(); $PHPSESSID = $_COOKIE['PHPSESSID']; $ip= $_SERVER['REMOTE_ADDR']; $row_wish = 0; list($row_wish, $product_arr, $wishlist_size_id_arr) = getWishListItems($products_id); if($accounts_id > 0) { $wish_link=""; }else{ $wish_str="Please note that you are not logged in to your account, and your wish list will
not be saved unless you: login to your account or register for an account.

"; } $itemadded = base64_decode($itemadded); $html_mini = ""; $html_mini.= ""; //ADD WISHLIST MINI WINDOW $html_mini.= ""; //echo $html_mini;exit; //END ?> 0 or size2 > 0) and active='Y'"; $results = mysql_query($q); if (mysql_num_rows($results) > 0) { $htmlselect.= " with "; while($row = mysql_fetch_array($results)) { $products_sizes_id = $row["products_sizes_id"]; $size1 = $row["size1"]; $size2 = $row["size2"]; $size3 = $row["size3"]; $size4 = $row["size4"]; $size_name = $size1; if ($size1) $size_name; if ($size2 > 0) $size_name .= "x". $size2; if ($size3 > 0) $size_name .= "-". $size3; if ($size4 > 0) $size_name .= "x". $size4; $size_name .= " mm"; $sizes[$products_sizes_id] = $size_name; $stone_finding_size2 = $size_name; $prices[$products_sizes_id] = $row["price"]; $beads_per_strand[$products_sizes_id] = $row["beads_per_strand"]; } if(count($sizes) > 0) { natsort($sizes); while(list($k,$v) = each($sizes)) { $price = $prices[$k]; $bead_per_strand = $beads_per_strand[$k]; $price_per_bead = @($price / $bead_per_strand); $display_price_per_bead = Make_Currency($price_per_bead); if($price > 0) { $display_price = Make_Currency($price); $htmlselect.= "$v"; $has_at_least_one_price = "y"; } } } $htmlselect.= ""; } if(!empty ($bead_per_strand)){ $product_block_sec_title .= $htmlselect; } if ($stone_id) { $q = "SELECT category from BC_categories where categories_id='$stone_id' and category!=''"; $results = mysql_query($q); $row = mysql_fetch_array($results); $stone_name = $row["category"]; if ($stone_id_display) { $product_block_sec_title .= " $stone_name"; } } if ($shapes_id) { $q = "SELECT shape_name from BC_shapes where shapes_id='$shapes_id' and shape_name!=''"; $results = mysql_query($q); $row = mysql_fetch_array($results); $shape_name = $row["shape_name"]; $product_block_sec_title .= " $shape_name"; } } $htmlselect = ""; ?>
Home / Catalog / $parent_category / "; echo "$category"; ?> « Return To Previous Page

» Need help?
 
 
 Product#  

"; else if ($db_product_data['closeout'] == "Y") echo ""; ?>
| Product#
0 and beads_per_strand>0)"; $q = "SELECT * from BC_products_sizes where products_id='$products_id' and active='Y' and price > 0 and (size1 > 0 or size2 > 0)"; $results = mysql_query($q); $sizes = $sizesb = $product_size_rowdata = array(); $bead_cnt=0; if (mysql_num_rows($results) > 0) { while($row = mysql_fetch_array($results)) { $products_sizes_id = $row["products_sizes_id"]; $size1 = $row["size1"]; $size2 = $row["size2"]; $size3 = $row["size3"]; $size4 = $row["size4"]; $size_name = $size1; if ($size1) $size_name; if ($size2 > 0) $size_name .= "x". $size2; if ($size3 > 0) $size_name .= "-". $size3; if ($size4 > 0) $size_name .= "x". $size4; $size_name .= " mm"; $price = $row["price"]; $beads_per_strand = $row["beads_per_strand"]; if(trim($row["length_per_strand"]) == "" || $row["length_per_strand"] == 0){ $row["length_per_strand"] = "-"; }else{ $row["length_per_strand"] .= '"'; } $beads_per_strand = round($beads_per_strand); if ($beads_per_strand == 0) { $price_per_bead = $price; }else{ $price_per_bead = @($price / $beads_per_strand); } $sizes[$products_sizes_id] = $size_name; $sizesb[$products_sizes_id] = $size_name; /* $prices[$products_sizes_id] = $row["price"]; $beads_per_strand[$products_sizes_id] = $row["beads_per_strand"]; $lengths_per_strand[$products_sizes_id] = $row["length_per_strand"]; $pricesb[$products_sizes_id] = $row["price"]; */ if(trim($beads_per_strand) == "" || $beads_per_strand == 0){ $beads_per_strand = "-"; }else{ $bead_cnt++; } $product_size_rowdata[$products_sizes_id]['size'] = $size_name; $product_size_rowdata[$products_sizes_id]['length_per_strand'] = $row["length_per_strand"]; $product_size_rowdata[$products_sizes_id]['price'] = $price; $product_size_rowdata[$products_sizes_id]['beads_per_strand'] = $beads_per_strand; $product_size_rowdata[$products_sizes_id]['price_per_bead'] = $price_per_bead; } natsort($sizes); } $htmlselect = ""; if($bead_cnt > 0 && !($finding_stone_product)) { $htmlselect.= "
"; while(list($k,$v) = each($sizes)) { $price = $product_size_rowdata[$k]['price']; $bead_per_strand = $product_size_rowdata[$k]['beads_per_strand']; $length_per_strand = $product_size_rowdata[$k]['length_per_strand']; $price_per_bead = $product_size_rowdata[$k]['price_per_bead']; $display_price_per_bead = Make_Currency($price_per_bead); $display_price = Make_Currency($price); #$bead_per_strand = round($bead_per_strand); $htmlselect.= " "; } $htmlselect.= "
Bead Size Strand
Length
#
Beads
$
Bead
$v $length_per_strand $bead_per_strand $display_price_per_bead
"; } //echo $htmlselect;exit; if(intval($bead_cnt) > 0){ echo $htmlselect; } ?>
0) { $htmlselect.= ""; } }else{ if (count($product_size_rowdata) > 0) { $htmlselect.= ""; } } if($has_at_least_one_price == "y") echo $htmlselect; else echo ""; $htmlselect = ""; if($has_at_least_one_price == "y") { if ($price_per_weight > 0) echo ""; echo ""; } ?>
Qty
Price: "; natsort($sizesb); while(list($k,$v) = each($sizesb)) { $priceb = $product_size_rowdata[$k]['price']; if($priceb > 0) { $display_price = Make_Currency($priceb); $htmlselect.= "$display_price"; if ($price_per_weight > 0) $htmlselect.= "**"; $htmlselect.= "\n"; $has_at_least_one_price = "y"; } } $q = "SELECT * from BC_finding_type2 where finding_type_id2='$finding_type_id2' order by finding_type_name2"; $db_type2 = $obj->select($q); $db_finding_type_name2 = $db_type2[0]["finding_type_name2"]; $htmlselect.= " per $db_finding_type_name2
Size
Please Call For Price
**This is an estimated price based on a price of \$$price_per_weight per $weight_type.

"; if($row_wish==0) { echo "
"; } else { echo "Item in Wish List,
click here to view.

"; } echo "

» Large View

0)) { $metaland .= " and p.categories_id='".$db_product_data['categories_id']."' "; $category_union_query = "UNION ". $assoc_query . " and p.categories_id='".$db_product_data['categories_id']."' $exclude_prod_id group by ps.products_id"; //$metalor = " p.categories_id='".$db_product_data['categories_id']."' "; } if ($db_product_data['colors_id'] && ($db_product_data['colors_id'] > 0)) { $metaland .= " and pc.colors_id = '".$db_product_data['colors_id']."'"; $color_union_query = "UNION ". $assoc_query . " and pc.colors_id = '".$db_product_data['colors_id']."' $exclude_prod_id group by ps.products_id"; #$metalor .= " or pc.colors_id = '".$db_product_data['colors_id']."'"; } if ($db_product_data['shapes_id'] && ($db_product_data['shapes_id'] > 0)) { $metaland .= " and p.shapes_id='".$db_product_data['shapes_id']."' "; $shapes_union_query = "UNION ". $assoc_query . " and p.shapes_id='".$db_product_data['shapes_id']."' $exclude_prod_id group by ps.products_id"; # $metalor .= " or p.shapes_id='".$db_product_data['shapes_id']."'"; } if ($db_product_data['cuts_id'] && ($db_product_data['cuts_id'] > 0)) { $metaland .= " and p.cuts_id='".$db_product_data['cuts_id']."' "; $cuts_union_query = "UNION ". $assoc_query . " and p.cuts_id='".$db_product_data['cuts_id']."' $exclude_prod_id group by ps.products_id"; # $metalor .= " or p.cuts_id='".$db_product_data['cuts_id']."'"; } if ($db_product_data['drills_id'] && ($db_product_data['drills_id'] > 0)) { $metaland .= " and p.drills_id='".$db_product_data['drills_id']."'"; $drills_union_query = "UNION ". $assoc_query . " and p.drills_id='".$db_product_data['drills_id']."' $exclude_prod_id group by ps.products_id"; # $metalor .= " or p.drills_id='".$db_product_data['drills_id']."'"; } if ($db_product_data['metal_id'] && ($db_product_data['metal_id'] > 0)) { $metaland .= " and p.metal_id='".$db_product_data['metal_id']."' "; $metal_union_query = "UNION ". $assoc_query . " and p.metal_id='".$db_product_data['metal_id']."' $exclude_prod_id group by ps.products_id"; # $metalor .= " or p.metal_id='".$db_product_data['metal_id']."' "; } if($metaland!="") $metaland = substr($metaland,4); if($metalor!="") $metalor = substr($metalor,3); $q = $assoc_query . " and ( $metaland ) $exclude_prod_id group by ps.products_id "; //$q .= $assoc_query . " and ( $metaland ) $exclude_prod_id group by ps.products_id "; $q .= " $category_union_query "; $q .= " $color_union_query "; $q .= " $shapes_union_query "; $q .= " $cuts_union_query "; $q .= " $drills_union_query "; $q .= " $metal_union_query "; $q .= " LIMIT 0,3"; # echo $q; //exit; $sql_assoc_query = $q; $db_results_arr = $obj->select($sql_assoc_query); #$results = mysql_query($q); #$amount = mysql_num_rows($results); $amount = count($db_results_arr); if ($amount > 0) { echo "

Associated Items

"; $i=0; for($i=0; $i<$amount; $i++) { $product_name = $db_results_arr[$i][product_name]; $price = $db_results_arr[$i][minimum_price]; $products_id = $db_results_arr[$i][products_id]; $display_price = number_format($price,2); echo ""; } for($j=$i;$j<=3;$j++) echo ""; echo "
$product_name"; echo "
\$$display_price
"; } } ?> ShowContent('html_mini');"; echo ""; } if($showprompt == "y" && $prompttype == "wishlist"){ //echo "here";exit; //echo ""; //#TB_inline?height=155&width=300&inlineId=hiddenModalContent&modal=true echo ""; } ?>