Home:Customers:ASP.NET eCommerce:Vizio Optic

ASP.NET eCommerce

select($SQL); $fvalue = $resBnr[0]['FieldValue']; $farray = explode(",", $fvalue); $IconWidth = $farray[1]; $IconHeight = $farray[2]; $dirID = $farray[0]; $pimagepath = array(); while($dirID != 0) { $SQL = "SELECT DirName FROM directory WHERE DirId = ".$dirID; $res = $objDB->select($SQL); $pimagepath[] = $dirID; $SQL = "SELECT Parent FROM dir_hierarchy WHERE DirId = ".$dirID; $res = $objDB->select($SQL); $dirID = $res[0]['Parent']; } $pimagepath = array_reverse($pimagepath); $TechIconPath = ""; for($i=0; $i < count($pimagepath); $i++) { $SQL = "SELECT DirName FROM directory WHERE DirId = ".$pimagepath[$i]; $res = $objDB->select($SQL); $TechIconPath .= strtolower($res[0]['DirName']) ."/"; } /* Path for Large Image */ $SQL = "SELECT FieldValue FROM field WHERE FieldId = ".PortfolioLargeImage; $resBnr = $objDB->select($SQL); $fvalue = $resBnr[0]['FieldValue']; $farray = explode(",", $fvalue); $dirID = $farray[0]; $pimagepath = array(); while($dirID != 0) { $SQL = "SELECT DirName FROM directory WHERE DirId = ".$dirID; $res = $objDB->select($SQL); $pimagepath[] = $dirID; $SQL = "SELECT Parent FROM dir_hierarchy WHERE DirId = ".$dirID; $res = $objDB->select($SQL); $dirID = $res[0]['Parent']; } $pimagepath = array_reverse($pimagepath); $dirPath = ""; for($i=0; $i < count($pimagepath); $i++) { $SQL = "SELECT DirName FROM directory WHERE DirId = ".$pimagepath[$i]; $res = $objDB->select($SQL); $dirPath .= strtolower($res[0]['DirName']) ."/"; } /* Path for Thumb Image */ $SQL = "SELECT FieldValue FROM field WHERE FieldId = ".PortfolioThumbImage; $resBnr = $objDB->select($SQL); $fvalue = $resBnr[0]['FieldValue']; $farray = explode(",", $fvalue); $dirID = $farray[0]; $pimagepath = array(); while($dirID != 0) { $SQL = "SELECT DirName FROM directory WHERE DirId = ".$dirID; $res = $objDB->select($SQL); $pimagepath[] = $dirID; $SQL = "SELECT Parent FROM dir_hierarchy WHERE DirId = ".$dirID; $res = $objDB->select($SQL); $dirID = $res[0]['Parent']; } $pimagepath = array_reverse($pimagepath); $ThumbdirPath = ""; for($i=0; $i < count($pimagepath); $i++) { $SQL = "SELECT DirName FROM directory WHERE DirId = ".$pimagepath[$i]; $res = $objDB->select($SQL); $ThumbdirPath .= strtolower($res[0]['DirName']) ."/"; } $SQL = "SELECT OrderBy FROM term_hierarchy WHERE tid = ".$PageId; $res = $objDB->select($SQL); $OrderBy = $res[0]['OrderBy']; $nextOB = $OrderBy + 1; $prevOB = $OrderBy - 1; $prevName = ""; $nextName = ""; $SQL = "SELECT parent FROM term_hierarchy WHERE tid = ".$PageId; $res = $objDB->select($SQL); $curParent = $res[0]['parent']; $nextID = fetch_next_portfolio($curParent, $PageId, "next"); $SQL = "SELECT Name, CleanURL FROM ".DATA_TABLE." WHERE PageId = ".$nextID; $res = $objDB->select($SQL); $nextLink = $res[0]['CleanURL']; $nextName = $res[0]['Name']; $prevID = fetch_next_portfolio($curParent, $PageId, "prev"); $SQL = "SELECT Name, CleanURL FROM ".DATA_TABLE." WHERE PageId = ".$prevID; $res = $objDB->select($SQL); $prevLink = $res[0]['CleanURL']; $prevName = $res[0]['Name']; if($prevLink == $CleanURL) { $prevLink = ''; $prevName = ''; } if($nextLink == $CleanURL) { $nextLink = ''; $nextName = ''; } if($PortfolioLargeImage != "") { if(!file_exists($dirPath.$PortfolioLargeImage)) $LImage = $dirPath."default.png"; else $LImage = $dirPath.$PortfolioLargeImage; } else $LImage = $dirPath."default.png"; ?>

Vizio Optic

Previous Next

Vizio Optic

We are an award winning, high-end eyewear boutique offering you high-end, specialty designer glasses and designer sunglasses from around the world. In the past nine years we won the "Best of Boston" awards seven times and our goal is to give you the best customer experience in buying eyeglasses and sunglasses. We are passionate about eyeglasses, which is why we offer a unique selection of eyeglass frames that are handcrafted by specialty eyewear designers and true artists who live and breathe eyewear. You will find unique brands of eyewear at Vizio that will not only help you see better and will make you look good too!

select($SQL); if($res[0]['ProjectTechnology'] != "") $ProjectTechnology = $res[0]['ProjectTechnology']; } if($ProjectTechnology != "") { ?>

Project Technologies

0) { ?>

Repeat Business