$findthisprod[retailorder] and catalog.itemid = webitems.maincat and (itemno like '%SET%' or webitems.itemname like '%SET%') and page > 0 order by catalog.retailorder limit 1",$conn); $findnextprod = mysql_fetch_array($findnextprodres); $findprevprodres = mysql_query(" select webitemid,webitems.itemname from catalog,webitems where catalog.entity = '16' and webitems.active = 1 and catalog.type='collection' and catalog.useconsumer = 1 and catalog.retailorder < $findthisprod[retailorder] and catalog.itemid = webitems.maincat and (itemno like '%SET%' or webitems.itemname like '%SET%') and page > 0 order by catalog.retailorder desc limit 1",$conn); $findprevprod = mysql_fetch_array($findprevprodres); //print "Next" .$findnextprod[webitemid]; if($findnextprod[webitemid]==""){ $findnextprodres = mysql_query(" select webitemid,webitems.itemname from catalog,webitems where catalog.entity = '16' and catalog.type='collection' and catalog.useconsumer = 1 and catalog.retailorder > 0 and webitems.active = 1 and catalog.itemid = webitems.maincat and (itemno like '%SET%' or webitems.itemname like '%SET%') and page > 0 order by catalog.retailorder limit 1",$conn); $findnextprod = mysql_fetch_array($findnextprodres); } if($findprevprod[webitemid]==""){ $findprevprodres = mysql_query(" select webitemid,webitems.itemname from catalog,webitems where catalog.entity = '16' and catalog.type='collection' and catalog.useconsumer = 1 and catalog.retailorder > 0 and webitems.active = 1 and catalog.itemid = webitems.maincat and (itemno like '%SET%' or webitems.itemname like '%SET%') and page > 0 order by catalog.retailorder desc limit 1",$conn); $findprevprod = mysql_fetch_array($findprevprodres); } ?>
"; } if($iteminfo[license]=="Lucky Duck"){ print " "; } } ?> ";
if($findprod[size]!=""){
print "Size: ".$findprod[size];
}
//print $findprod[itemno];
if(substr($findprod[itemno],0,3)!="SET" && strpos($findprod[itemname],"SET")==0){
$findsetres = mysql_query("select * from webitems where itemno like 'SET-%".$findthisprod[itemid]."%-BBF' and module = 'bf' and active = 1",$conn);
if(mysql_num_rows($findsetres)>0){
$findset = mysql_fetch_array($findsetres);
print " Contact us for fabric swatches. Please note that fabric swatches are not available for this product. "; } ?>
";
$accesq = "select * from webitems where itemno like '%-".$findprod[maincat]."-BBF' ";
if( substr($findprod[itemno],0,3)=="SET" ){ $accesq .= "and itemno <> 'SET-".$findprod[maincat]."-BBF' "; }
$accesq .= " and module = 'bf' and active = 1 ";
$findaccres = mysql_query($accesq,$conn);
$items = "'".$findprod[mayalsolike]."'";
$items = ereg_replace(",","','",$items);
$itemq = mysql_query("select * from webitems where itemno in (".$items.") and active = 1 order by qtysold desc limit 2",$conn);
if(mysql_num_rows($findaccres) || mysql_num_rows($itemq) || $findprod[swatchesavailable]){
?>
|
||
Close zoom view |