| | FAQ | Help

Keyword Product Code

1-800-658-8788 Call ABC Office
Speak With one of our Experts Today!

by Category


by Manufacturer


Siteseal
> overstock > Overstock

Clearance and Overstock


<< See All Overstock Categories
0 AND ABC_YN <> 0 And C.SiteName='ABC Site' AND C.SiteName=MainCatInfo.SiteName AND C.MainCat=MainCatInfo.MainCat ORDER BY C.MainCat";*/ $queryCloseout = "SELECT distinct items.PageName,items.Thumbnail,items.Title,items.ShipTruck,items.FreeFreight,items.code,items.Sh,items.CartDesc,items.IdxCol1,items.PurchaseQty,price.Price,price.retail,C.Description FROM items, price, Category C WHERE C.SiteName='ABC Site' and items.Code=price.Code AND items.ABC_YN <> 0 AND items.Discon_YN = 0 AND C.memberof=items.memberof AND (C.MainCat = '".$_GET["category"]."') AND (items.closeout_YN <> 0 OR items.OverStock_YN <> 0) ORDER BY price.Price"; $resultCloseout = mysql_query($queryCloseout) or die ("queryCloseout Failed"); $first = true; while ($datCloseout = mysql_fetch_array($resultCloseout)) { if($first==true) { print "\n

".$datCloseout["AnchorText"]."

"; print "

".$extraHype."

"; print "\n"; print ""; print ""; print ""; print ""; print ""; $first=false; } if (mysql_num_rows($resultCloseout) < 1) // if the query returns no data { print "\n\t\n"; print "\t\t\n"; } else { print "\n\t\n"; print "\t\t\n"; if($datCloseout["Description"] && $datCloseout["Description"] !="Closeout Items") { print "\t\t\n"; } else { if ($datCloseout["IdxCol1"] != '' || $datCloseout["IdxCol1"] != NULL) { print "\t\t\n"; } else print "\t\t\n"; } print "\t\t"; print ""; $LastSKU = $SKU; print "\n"; print "";//http://www.officezone.com/ print ""; print ""; print ""; print ""; print ""; //print ""; print "0 && $datCloseout["Retail"]>$datCloseout["Price"]) { print $datCloseout["Retail"]; } else { print $datCloseout["Price"]; } print "\">"; print ""; if($datCloseout["Retail"]>0 && $datCloseout["Retail"]>$datCloseout["Price"]) //print "Make an Offer\n"; print ""; print "\t\n\n"; } } if (mysql_num_rows($resultCloseout) < 1) { print "\n

".$datCloseout["AnchorText"]."

"; print "\n
ModelCategory DescriptionCloseout Price
There are currently no used items available in this category."; print "
"; if($datCloseout["PageName"]==''|| $datCloseout["PageName"]==NULL) { $altInfo=null; //do nothing } else { $query2= "SELECT Hype.thumbnail, Hype.AltPageName FROM Hype WHERE (((Hype.SiteName)='ABC Site') AND ((Hype.PageName)='".$datCloseout["PageName"]."'));"; $result2= mysql_query($query2); $altInfo=mysql_fetch_array($result2); if($altInfo["AltPageName"]!=null) $dat["PageName"] = $altInfo["AltPageName"]; print ""; } if($datCloseout["Thumbnail"]!=''&& $datCloseout["Thumbnail"]!=NULL && $datCloseout["Thumbnail"]!="2" && $datCloseout["Thumbnail"]!="3" && $datCloseout["Thumbnail"]!="4" && $datCloseout["Thumbnail"]!="5" && (strpos($datCloseout["Thumbnail"],".gif")==false)) { $altInfo["thumbnail"] = str_replace(".jpg","",$altInfo["thumbnail"]).".jpg"; print "\"View
"; } if($datCloseout["CartDesc"]==''|| $datCloseout["CartDesc"]==NULL) { print $datCloseout["Title"]; } else { print $datCloseout["CartDesc"]; } if($datCloseout["PageName"]!=''||$datCloseout["PageName"]!=NULL) { print "
"; } print "
".$datCloseout["Description"]."".$datCloseout["IdxCol1"]." "; print "$".number_format(($datCloseout["Price"]*$datCloseout["PurchaseQty"]),2); if ($datCloseout["PurchaseQty"] > 1){ print " / ".$datCloseout["PurchaseQty"]; } print "\t"; if($datCloseout['FreeFreight']<>0) $SKU=$datCloseout['code']."#"; else $SKU = $datCloseout['code']; if($datCloseout['ShipTruck']<>0) $SKU=$SKU."@TR"; print "\t
\n"; print "\t\n"; print "\t"; print "\n"; print ""; print "\n\t
"; print ""; print ""; print ""; print ""; print ""; //print ""; print ""; print "\n\t\n"; print "\t\t\n"; } if(isset($resultCloseout)) mysql_free_result($resultCloseout); print '
ModelCategory DescriptionCondition **Used PriceMake an offer
There are currently no used items available in this category."; print "
'; } else{ $queryUsed = "SELECT DISTINCT MainCatInfo_1.MainCat, MainCatInfo_1.AnchorText FROM items INNER JOIN Category ON items.memberof = Category.MemberOf INNER JOIN MainCatInfo ON Category.MainCat = MainCatInfo.MainCat AND Category.SiteName=MainCatInfo.SiteName INNER JOIN MainCatInfo AS MainCatInfo_1 ON MainCatInfo.OneLevelUp = MainCatInfo_1.MainCat AND MainCatInfo.SiteName = MainCatInfo_1.SiteName WHERE (((MainCatInfo_1.SiteName)='ABC Site') AND ((items.ABC_YN)<>0) AND ((items.Discon_YN)=0) AND ((items.DontCreate)=0) AND ((items.used_YN)<>0)) ORDER BY MainCatInfo_1.AnchorText;"; $result = mysql_query($queryUsed); while($data = mysql_fetch_array($result)) { ++$num; $link2 = null; print '
'.$data[
'.$data["AnchorText"].'
'; print $link2; //print '
'; //print '
'.$data["Description"].'
'; // removed class="submenu" print '
'; if($num % 3 == 0)print "

"."\n\t"; }} ?>





800-658-8788 Or: 866-380-9222 Local Phone: 801.927.3020 Fax Number: 801.927.3037

8:00am - 5:00pm (MST) M-F

Email ABC Office
Company Info ABC Office Blog ABC Office Facebook Page ABC Office Google+ Page
Home   |   Site Map   |   About Us   |   Contact Us   |   Policies 39 ABC Office YEARS Site Secured by Godaddy.com All Major Credit Cards Welcome! ShopSite Cart Amazon Star Rating