Price------->".$price; //echo "
";
//print_r($_SESSION);
//echo "
"; if ($db->Connect()) { /***************CODE FOR FETCHING META KEYWORDS AND DESCRIPTION**************************************/ $sql_meta_key_desc="select * from $tables[meta_key_desc]"; $res_meta_key_desc=mysql_query($sql_meta_key_desc) or die(redirect_index()); $line_meta_key_desc=mysql_fetch_array($res_meta_key_desc); $line_meta_desc=stripslashes($line_meta_key_desc['meta_desc']); $line_meta_key=stripslashes($line_meta_key_desc['meta_key']); /***************END OF CODE FOR FETCHING META KEYWORDS AND DESCRIPTION**************************************/ ?> Diamond Jewelry, Engagement Rings, Earrings, Pendants and Bracelets Execute($selectcategory) or die(redirect_index()); $category_row=$db->FetchArray($result); //echo "
CAT------------->".$categoryid; //code start for product listing if($_GET['id']!="all_pr") { $recPerPage=12;// product shown per page if($price!=""){ if($price!=2000){ if($price == 300) { $count="select * from $tables[fixproduct] where (product_price<'$price' and product_price>'100') and status='active'"; // echo "
CC----->".$count; // exit; }else if($price == 500) { $count="select * from $tables[fixproduct] where (product_price<'$price' and product_price>'300') and status='active'"; }else if($price == 1000) { $count="select * from $tables[fixproduct] where (product_price<'$price' and product_price>'500') and status='active'"; }else { $count="select * from $tables[fixproduct] where product_price<'$price' and status='active'"; } }else{ $count="select * from $tables[fixproduct] where product_price>'1000' and status='active'"; } } elseif($_REQUEST['orderby'] == "product_bestseller") { $count="select * from $tables[fixproduct] where bestseller='yes' and (category_id=$categoryid or subcategory_id=$categoryid) and status='active'"; } elseif ($featured=='yes'){ $count="select * from $tables[fixproduct] where features like '%$categoryid%' and status='active'"; }else{ $count="select * from $tables[fixproduct] where (category_id=$categoryid or subcategory_id=$categoryid) and status='active' "; } //echo "
COUNT----->".$count; $rsCount=$db->Execute($count) or die(redirect_index()); $count_row = $db->RowCount($rsCount); $tot1=($count_row/$recPerPage); // echo "
TOT1------->".$tot1; $tot=round($count_row/$recPerPage); if($tot1>$tot) { $tot=$tot+1; // echo "
TOT---------->".$tot; } } //code added for paging end // $orderby = ((isset($_REQUEST['orderby']))?$_REQUEST['orderby']:'product_order'); Modified by Morrison on 21 jan 2008 // $orderby = ((isset($_REQUEST['orderby']))?$_REQUEST['orderby']:'product_price'); if($_GET['price']!='') { $orderby = ((isset($_REQUEST['orderby']))?$_REQUEST['orderby']:'product_price'); } else { $orderby = ((isset($_REQUEST['orderby']))?$_REQUEST['orderby']:'product_order'); } // echo "
ORDER-------->".$orderby; if($_GET['id']=="all_pr") { if($orderby == "product_bestseller") { $query = "select * from $tables[fixproduct] where bestseller='yes' and (category_id=$categoryid or subcategory_id=$categoryid) and status='active'"; // echo "
QUER------->".$query; // exit; }else if($price!=""){ if($price!=2000){ if($price == 100) { $query = "select * from $tables[fixproduct] where product_price<='$price' and status='active' order by product_order"; }else if($price == 300) { $query = "select * from $tables[fixproduct] where (product_price<='$price' and product_price>'100') and status='active' order by product_order"; //echo "
1Query300------->".$query; // exit; }else if($price == 500) { $query = "select * from $tables[fixproduct] where (product_price<='$price' and product_price>'300') and status='active' order by product_order"; }else if($price == 1000) { $query = "select * from $tables[fixproduct] where (product_price<='$price' and product_price>'500') and status='active' order by product_order"; } // echo "
QUERY1------->".$query; // exit; }else{ $query="select * from $tables[fixproduct] where product_price>'1000' and status='active' order by product_order"; // echo "
QUERY2------->".$query; // exit; } }elseif ($featured=='yes'){ $query="select * from $tables[fixproduct] where features like '%$categoryid%' and status='active' order by product_order"; //echo "
QUERY3------->".$query; //exit; }else{ $query = "select * from $tables[fixproduct] where (category_id=$categoryid or subcategory_id=$categoryid) and status='active' order by $orderby"; //echo "
QUERY4------->".$query; //exit; } }else { if($orderby == "product_bestseller") { $query = "select * from $tables[fixproduct] where bestseller='yes' and (category_id=$categoryid or subcategory_id=$categoryid) and status='active' limit ". ((($pg-1)*$recPerPage)) . "," . $recPerPage; // echo "
QUER------->".$query; // exit; }else if($price!=""){ if($price!=2000){ if($price == 100) { $query = "select * from $tables[fixproduct] where product_price<='$price' and status='active' order by $orderby limit ". ((($pg-1)*$recPerPage)) . "," . $recPerPage; // echo "
QUERY1------->".$query; // exit; }else if($price == 300) { $query = "select * from $tables[fixproduct] where (product_price<='$price' and product_price>'100') and status='active' order by $orderby limit ". ((($pg-1)*$recPerPage)) . "," . $recPerPage; // echo "
2Query300------->".$query; // exit; }else if($price == 500) { $query = "select * from $tables[fixproduct] where (product_price<='$price' and product_price>'300') and status='active' order by $orderby limit ". ((($pg-1)*$recPerPage)) . "," . $recPerPage; }else if($price == 1000) { $query = "select * from $tables[fixproduct] where (product_price<='$price' and product_price>'500') and status='active' order by $orderby limit ". ((($pg-1)*$recPerPage)) . "," . $recPerPage; } }else{ $query="select * from $tables[fixproduct] where product_price>'1000' and status='active' order by $orderby limit ". ((($pg-1)*$recPerPage)) . "," . $recPerPage; // echo "
QUERY2------->".$query; // exit; } }elseif ($featured=='yes'){ $query="select * from $tables[fixproduct] where features like '%$categoryid%' and status='active' order by $orderby limit ". ((($pg-1)*$recPerPage)) . "," . $recPerPage; //echo "
QUERY3------->".$query; //exit; }else{ $query = "select * from $tables[fixproduct] where (category_id=$categoryid or subcategory_id=$categoryid) and status='active' order by $orderby limit ". ((($pg-1)*$recPerPage)) . "," . $recPerPage; //echo "
QUERY4------->".$query; //exit; } } //echo $query; $rsProduct=$db->Execute($query) or die(redirect_index()); $tot_prod=$db->RowCount($rsProduct); //code end for product listing //print_r($category_row); include("include/header.php"); ?>
CURRENT------->".$current_image_path; $image_size=getimagesize($current_image_path); // echo "
IMG_SIZE---------->".$image_size; list($uploade, $feature, $image,$imagename) =split("/", substr($category_row['imagepath1'],2), 4); if($image_size[0] > 605) { $new_image_path=SITE_ROOT."product_images/category/large_".$imagename; if(!file_exists($new_image_path)) { // $make_magick = system("/usr/bin/convert -geometry 250 x 250 $current_image_path $new_image_path", $retval); $make_magick = exec("/usr/bin/convert $current_image_path -resize 600x400\! $new_image_path", $retval); } $new_pth=1; }else { $new_pth=0; } } //code end if(($_GET['cat_id']=='222') || ($_GET['cat_id']=='223') || ($_GET['cat_id']=='224') ) { include("search_products45.php"); } if($_GET['cat_id']=='228') { include("include/promotion.php"); } if($_GET['cat_id']=='260') { include("include/promotion.php"); } ?>
0){ ?>
Show All
"; $total_rows_pro = mysql_num_rows($rsProduct); //echo"total_rows_pro:-----".$total_rows_pro; if($total_rows_pro%3=='0') { echo"
"; } $arr_img = array(); $b = 0; while ($row_prod=$db->FetchArray($rsProduct)) { $current_image_path=SITE_ROOT.substr($row_prod['product_image1'],2); list($uploade, $feature, $image,$imagename) =split("/", substr($row_prod['product_image1'],2), 4); $new_image_path=SITE_ROOT."product_images/product/thumb_".$imagename; if(!file_exists($new_image_path)){ $make_magick = system("/usr/bin/convert -geometry 150 x 150 $current_image_path $new_image_path", $retval); } $current_image_path=SITE_ROOT.substr($row_prod['product_image1'],2); list($uploade, $feature, $image,$imagename) =split("/", substr($row_prod['product_image1'],2), 4); $new_image_path=SITE_ROOT."product_images/product/big_".$imagename; if(!file_exists($new_image_path)){ $make_magick = system("/usr/bin/convert -geometry 500 x 500 $current_image_path $new_image_path", $retval); } $you_savv = ($row_prod['product_price']/$row_prod['retail_value'])*100; $you_savv_price=number_format((100 - $you_savv),2); // print_r($row_prod); //echo $row_prod['product_id']."hello "; if($b%3==0) { $j = 0; $counter = 0; $c_counter = 0; echo""; $tb_cols = 4; } $counter++; if($j == 1) { $tb_cols = 4; } $c_counter = $counter; $arr_img[$j][image] = "product_images/category/thumb_".$imagename; $arr_img[$j][count] = $c_counter; // for recentlry stored $recentImgpath = 'product_images/product/thumb_'.$imagename; $proReImgid = $row_prod['product_id']; $_SESSION['recentImgpath_'.$proReImgid] = $recentImgpath; echo""; if($j == 2) { echo"
"; echo"
"; ?> '; } else { $divContent = '
 
'; $saveExt = ''; $validTill = ''; $finalAMt = ''; } ?>
Our Price :MONEY_SIMBOL0.00
Retail Value :MONEY_SIMBOL0.00
You Save :%

"; } $j = $j+1; $b = $b+1; ?>
COUNT---------->".$count_row; // echo "
PG---------->".$pg; // echo "
REC_PER_PAGE---------->".$recPerPage; // echo "
TOT---------->".$tot; // echo "
URL---------->".$url; $pageLink = pageSplit1($count_row,$pg,$recPerPage,$tot,$url); ?>

Show All
No Product exist for the selected category
"; } ?> ". $db->SQLERROR; } include("include/footer.php"); ?>