0
and license = 'Bananafish' order by retailorder",$conn);
print "
Bananafish Baby Bedding";
if($catid=='Bananafish'){
print "
";
$icount = 0;
$showall = $_GET[showall];
if($showall == 1 || $showall ==0){
}else{
$showall = 0;
}
while($findcat = mysql_fetch_array($findcatres)){
$findsetres = mysql_query("select * from webitems where (itemno like 'SET%".$findcat[itemid]."%-BBF' ) and module = 'bf' and active = 1",$conn);
$findset = mysql_fetch_array($findsetres);
if($findset[webitemid]==""){
continue;
}
print "
";
if($icount == 9 && $showall==0){
print " See all >";
}
if($icount > 8 && $showall==0){print ""; }
print " |
";
print "";
$icount++;
}
print "
";
}
$findcatres = mysql_query("select * from catalog where entity = '16' and type = 'collection' and useconsumer = 1 and page > 0
and license = 'MiGi' order by retailorder",$conn);
print "
MiGi Baby Bedding";
if($catid=='MiGi'){
print "
";
$icount = 0;
$showall = $_GET[showall];
if($showall == 1 || $showall ==0){
}else{
$showall = 0;
}
while($findcat = mysql_fetch_array($findcatres)){
$findsetres = mysql_query("select * from webitems where (itemno like 'SET%".$findcat[itemid]."%-BBF' ) and module = 'bf' ",$conn);
$findset = mysql_fetch_array($findsetres);
if($findset[webitemid]==""){
continue;
}
print "
";
if($icount == 9 && $showall==0){
print " See all >";
}
if($icount > 8 && $showall==0){print ""; }
print " |
";
print "";
$icount++;
}
print "
";
}
/*
$findcatres = mysql_query("select * from catalog where entity = '16' and type = 'collection' and useconsumer = 1 and page > 0
and license = 'Skip-Hop' order by retailorder",$conn);
print "
Skip Hop Baby Bedding";
if($catid=='Skip-Hop'){
print "
";
while($findcat = mysql_fetch_array($findcatres)){
$findsetres = mysql_query("select * from webitems where (itemno like 'SET%".$findcat[itemid]."%-BBF' ) and module = 'bf' ",$conn);
$findset = mysql_fetch_array($findsetres);
print "
".$findcat[itemdesc]." |
";
}
print "
";
}
*/
$findcatres = mysql_query("select * from catalog where entity = '16' and type = 'collection' and useconsumer = 1 and page > 0
and license = 'Bananafish-Toddler' order by retailorder",$conn);
//print "
Bananafish Toddler Bedding";
if($catid=='Bananafish-Toddler'){
print "
";
$icount = 0;
$showall = $_GET[showall];
if($showall == 1 || $showall ==0){
}else{
$showall = 0;
}
while($findcat = mysql_fetch_array($findcatres)){
$findsetres = mysql_query("select * from webitems where (itemno like 'SET%".$findcat[itemid]."%-BBF' ) and module = 'bf' ",$conn);
$findset = mysql_fetch_array($findsetres);
print "
";
if($icount == 9 && $showall==0){
print " See all >";
}
if($icount > 8 && $showall==0){print ""; }
print " |
";
print "";
$icount++;
}
print "
";
}
/*
$findcatres = mysql_query("select * from catalog where entity = '16' and type = 'collection' and useconsumer = 1 and page > 0
and license = 'Diaper-Bags' order by retailorder",$conn);
print "
Bananafish Diaper Bags";
if($catid=='Diaper-Bags'){
print "
";
$icount = 0;
$showall = $_GET[showall];
if($showall == 1 || $showall ==0){
}else{
$showall = 0;
}
while($findcat = mysql_fetch_array($findcatres)){
$findsetres = mysql_query("select * from webitems where (itemno like 'SET%".$findcat[itemid]."%-BBF' ) and module = 'bf' ",$conn);
$findset = mysql_fetch_array($findsetres);
print "
";
if($icount == 9 && $showall==0){
print " See all >";
}
if($icount > 8 && $showall==0){print ""; }
print " |
";
print "";
$icount++;
}
print "
";
}
$findcatres = mysql_query("select * from catalog where entity = '16' and type = 'collection' and useconsumer = 1 and page > 0
and license = 'Bananafish-Stroller-Blankets' order by retailorder",$conn);
print "
Bananafish Stroller Blankets";
if($catid=='Bananafish-Stroller-Blankets'){
print "
";
$icount = 0;
$showall = $_GET[showall];
if($showall == 1 || $showall ==0){
}else{
$showall = 0;
}
while($findcat = mysql_fetch_array($findcatres)){
$findsetres = mysql_query("select * from webitems where (itemno like 'SET%".$findcat[itemid]."%-BBF' ) and module = 'bf' ",$conn);
$findset = mysql_fetch_array($findsetres);
print "
";
if($icount == 9 && $showall==0){
print " See all >";
}
if($icount > 8 && $showall==0){print ""; }
print " |
";
print "";
$icount++;
}
print "
";
}
*/
?>
0 ";
if($catid==""){ $catid = "Bananafish"; }
if($catid!=""){
$maxstring .= " and license = '$catid' ";
}
$findmaxpageres = mysql_query($maxstring,$conn);
$maxpages = ceil(mysql_num_rows($findmaxpageres) / 6);
if($pagenum=="" || !isset($pagenum)){
$pagenum = 1;
}
if($pagenum > $maxpages){ $pagenum = $maxpages; }
$offset = ($pagenum - 1) * 6;
$qstring = "select * from catalog where entity = '16' and type='collection' and useconsumer = 1 and page > 0 ";
if($catid!=""){
$qstring .= " and license = '$catid' ";
}
if($showall==1){
$qstring .= " order by retailorder limit 999 ";
}else{
$qstring .= " order by retailorder limit 6 offset $offset ";
}
// print $qstring;
$findcatres = mysql_query($qstring,$conn);
print "
".str_replace("-"," ",$catid) . " Collection
";
print "
";
$icount = 0;
while($findcat = mysql_fetch_array($findcatres)){
$findsetres = mysql_query("select * from webitems where (itemno like 'SET-".$findcat[itemid]."-BBF') and module = 'bf' and active = 1 ",$conn);
//if(mysql_num_rows($findsetres)>0){
$findset = mysql_fetch_array($findsetres);
if($findset[webitemid]==""){
continue;
}
if( ($icount % 3) ==0){
print "\r\n";
}
print "
".$findset[itemname]."
| ";
$icount++;
//}
}
?>
1";
}else{
print "
1";
}
for($x=2;$x<=$maxpages;$x++){
if($x==$pagenum || $showall==1){
print " |
$x ";
}else{
print " |
$x ";
}
}
?>