"; try { if ($ringflag!='1' && $ringflag!='0') { $ringflag='0'; } $objDB = new raruDB($hostname, $username, $password, $databasename); $objDB->connect(); echo ""; echo ""; echo ""; $name=""; if ($productsubtype=="") { $name=$category; } else { $name=$producttype; // echo ""; } echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; if ($ringflag=='1') { echo ""; } echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; $qStr = ""; $qStr = $qStr . "SELECT distinct(productID), ProductType, WebComments, RetailPrice, RingSize, "; // Width, Length, $qStr = $qStr . " PrimaryMetal, SecondaryMetal, ImageFlag, ImageHeight, ImageWidth, HoldFlag, saleflag, saleprice FROM products "; $qStr = $qStr . " WHERE Category = '".$category."' AND ProductSubType = '".$productsubtype."' "; $qStr = $qStr . " AND RetailPrice > 0 AND SoldFlag = 0 "; $qStr = $qStr . " Order by productID DESC"; $objDB->querystr = $qStr; // echo $objDB->querystr; $rows = $objDB->select(); foreach ($rows as $row) { // $producttype=$row["ProductType"]; // if ($producttype=="") { $producttype=$category; } echo ""; echo ""; echo ""; if ($row["ImageFlag"]) { echo ""; } if ($ringflag=='1') { echo ""; } echo ""; echo ""; if ($row["ImageFlag"]) { $height = $row["ImageHeight"]+185+30; $width = $row["ImageWidth"]+33+15; $producttype = strtolower($row["ProductType"]); echo ""; $src = "http://www.raru.com/products/images/".$producttype."/".$row["productID"]."TN.jpg"; echo ""; } else { echo ""; } echo ""; echo ""; echo ""; } echo "
".$instocksubtype."".$name."
Product NumberRing SizeMetal
DescriptionClickable ImageRetail Price
"; if ($row["ImageFlag"]) { echo ""; } echo $row["productID"]; echo "
"; if ($row["RingSize"]!="") { echo $row["RingSize"]; } else { echo " "; } echo "
"; // echo ""; if ($row["PrimaryMetal"]!="") { echo $row["PrimaryMetal"]; } else { echo " "; } // echo ""; echo "
"; // echo ""; if ($row["WebComments"]!="") { $saleflag = $row["saleflag"]; $saleprice = $row["saleprice"]; if ($saleflag) { echo $row["WebComments"]."
Special Sale $".number_format($saleprice)."
"; } else { echo $row["WebComments"]; } } else { echo " "; } // echo "
"; echo "
"; echo ""; echo ""; echo ""; echo "
Camera Shy
"; // echo ""; if ($row["HoldFlag"]) { echo "ON HOLD"; } else { $price = $row["RetailPrice"]; if (is_numeric($price)) { echo "$".number_format($price); } else { echo "$".number_format("call for price"); } } // echo ""; echo "
"; $objDB->close(); } catch (Exception $ex) { echo "caught an exception."; echo $ex->getMessage(); exit(1); } } ?> Gold Jewelry, Platinum Jewelry and Wedding Rings : 48hr shipment, best quality and affordable prices by deSignet
Hours
Monday - Friday 9AM-4PM
Saturday 9AM-2PM EST
Closed Sunday
PRICES SUBJECT to CHANGE without NOTICE


Ready for Immediate Delivery !!
Gents Jewelry
deSignet International

In a rush?  View our in stock pendants, religious items, gemstone rings or wedding bands.  
Check out our  plain and two tone bands  which are ready to ship within 48 to 72 hours.  
We also have an extensive inventory of diamonds  and gemstones.

Bracelets
Gents Jewelry
Earrings
Engagement Rings
Necklaces
Pendants
Religious Items
Rings
Wedding Bands
Celtic Wedding Bands