"; 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); } } ?> Celtic Instock Wedding Bands Ready To Ship by deSignet
Hours
Monday - Friday 9AM-4PM
Saturday 9AM-2PM EST
Closed Sunday
PRICES SUBJECT to CHANGE without NOTICE


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