"; 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); } } ?> Custom Designet Pendants by Designet!
Hours
Monday - Friday 8AM-5PM
Saturday 9AM-2PM EST
Closed Sunday


Ready for Immediate Delivery !!
Pendants
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