//echo "";
//print_r($product_result_array);
$metal_result_array = array();
if(count($metal_arr)>0){
$metal_ids = implode("','" , $metal_arr);
if($metal_ids!=''){
$select_metal = "select metal_name, metal_id from BC_metals where metal_id IN ('".$metal_ids."') ";
$metal_result_array = $obj->select($select_metal, $fetch="assoc", 'metal_id');
}
}
$country_result_array = array();
if(count($countries_id_array)>0){
$countries_ids = implode("','" , $countries_id_array);
if($countries_ids!=''){
$select_country = "select country_name, countries_id from BC_countries where countries_id IN ('".$countries_ids."') ";
$country_result_array = $obj->select($select_country, $fetch="assoc", 'countries_id');
}
}
$db_closeout = array();
if(count($products_id_array) > 0)
{
$sel_closeout = "select products_id,closeout from BC_products_sizes where closeout IN ('Y') and products_id in ('".implode("','",$products_id_array)."') group by products_id";
$db_closeout= $obj->select($sel_closeout, $fetch="assoc", 'products_id');
}
$select_dimesion = "select finding_dim_id, finding_dim_name from BC_finding_dim";
$dimension_result_array = $obj->select($select_dimesion, $fetch="assoc", 'finding_dim_id');
#mr($dimension_result_array);
$sel_finding = "select finding_type_id2, finding_type_name2 from BC_finding_type2 where active IN ('Y','y') ";
$db_finding = $obj->select($sel_finding, "assoc", "finding_type_id2");
if (!$start){
$start = 0;
}
?>
if(count($db_search_results)>0) {?>
$pageing_msg = "";
$begin_amount = $start + 1;
$end_amount = $start + 10;
if ($search_records < $end_amount){
$end_amount = $search_records;
}
$pageing_msg = "Showing $begin_amount-$end_amount of $search_records stones found";
$pageing_msg .= '
';
$pageing_msg .= "Page ";
$pages = $search_records / 10;
$pages = ceil($pages);
for ($i=1; $i<=$pages; $i++)
{
$start_number = ($i-1) * 10;
if ($start_number == $start)
$pageing_msg .= " $i ";
else
$pageing_msg .= " $i ";
}
echo $pageing_msg;
?>
|
} else { ?>
I am sorry but your search for " echo $search;?>" returned no results. Please retry your query or contact us for more information.
|
} ?>
for ($i=$start;$i<$start+10;$i++)
{
if ($products_id_array[$i])
{
$product_array = Array();
$products_id = $products_id_array[$i];
$product_array = $product_result_array[$products_id];
#mr($product_result_array[$products_id]);
if($search)
{
$temp_p_name = $product_name_array[$i];
$temp_p_name = str_replace("$search","$search",$temp_p_name);
}
else
$temp_p_name = $product_name_array[$i];
if (trim($short_description_array[$i])!=""){
$temp_p_name = $temp_p_name." - ".$short_description_array[$i];
}
$new = $product_result_array[$products_id]['new'];
#$closeout = $db_closeout[$products_id][0]['closeout'];
$closeout = $product_result_array[$products_id]['closeout'];
$office_lot = $product_result_array[$products_id]["office_lot"];
$countries_id = $product_result_array[$products_id]["countries_id"];
$country_name = $country_result_array[$countries_id][0]['country_name'];
$countries_id_display = $product_result_array[$products_id]['countries_id_display'];
$rating_display = $product_result_array[$products_id]['rating_display'];
$rating = $product_result_array[$products_id]['rating'];
$metal_name = "";
$metal_id = $product_result_array[$products_id]["metal_id"];
if(intval($metal_id) > 0){
$metal_name = $metal_result_array[$metal_id][0]['metal_name'];
}
$str_dimension = FindingDimensions($product_result_array[$products_id] , $dimension_result_array);
$color_value = "";
$q2_color = "SELECT c.color_name from BC_products_colors as pc, BC_colors as c where pc.products_id='$products_id' and pc.colors_id=c.colors_id";
$db_res_color = $obj->select($q2_color, $fetch="assoc", 'color_name');
if(count($db_res_color) > 0)
{
$color_value = implode(" / ",array_keys($db_res_color));
}
$color_depth_value = $product_result_array[$products_id]["color_depth"];
$price = $product_result_array[$products_id]["minimum_price"];
$type_id = $product_result_array[$products_id]['finding_type_id2'];
if(intval($price) >0)
$str_price = StartingPriceString($price , $type_id , $db_finding);
else
$str_price = "Call For Price: Toll-Free: (800) 578-1889";
?>
|
|
if (trim($office_lot)!="") { ?>
echo "Lot #: $office_lot"; ?> |
} ?>
if (trim($countries_id_display) == "Y" && trim($country_name)!="") { ?>
echo "Country where Mfg: $country_name"; ?> |
} ?>
if (trim($rating_display) == "Y" && trim($rating)!="") { ?>
echo "Relative Rating: ".displayRating($rating); ?> |
} ?>
if (trim($metal_name)!="") { ?>
echo "Metal: $metal_name"; ?> |
} ?>
if (trim($str_dimension)!="") { ?>
echo "Finding Dimensions: $str_dimension"; ?> |
} ?>
if (trim($color_value)!="") { ?>
echo "Color: $color_value"; ?> |
} ?>
if (trim($color_depth_value)!="") { ?>
echo "Color Depth: $color_depth_value"; ?> |
} ?>
if (trim($products_id)!="") { ?>
echo "Product #$products_id"; ?> |
} ?>
if (trim($str_price)!="") { ?>
echo $str_price; ?> |
} ?>
|
|
}
}
?>
if(count($db_search_results)>0) {?>
|
$pageing_msg = "";
$begin_amount = $start + 1;
$end_amount = $start + 10;
if ($search_records < $end_amount){
$end_amount = $search_records;
}
$pageing_msg .= "Page ";
$pages = $search_records / 10;
$pages = ceil($pages);
for ($i=1; $i<=$pages; $i++)
{
$start_number = ($i-1) * 10;
if ($start_number == $start)
$pageing_msg .= " $i ";
else
$pageing_msg .= " $i ";
}
$pageing_msg .= '
';
$pageing_msg .= "Showing $begin_amount-$end_amount of $search_records stones found";
echo $pageing_msg;
?>
|
} ?>