The $grname Series at A1AdultEbooks"; print ""; print ""; ?> "; print " "; if ($dispbooks!="N") { print ""; } else { print ""; } print "
"; include("../scripts/leftbar2024.php"); include("../scripts/sidebar2024.php"); print "
"; print "
"; include("../scripts/leftbar2024.php"); include("../scripts/sidebar2024.php"); print "
"; print "
"; include("../scripts/leftbar2024.php"); include("../scripts/sidebar2024.php"); print "
"; if ($dispbooks=="N") { print "
"; include("../scripts/leftbar2024.php"); print "
"; print "
"; include("../scripts/leftbar2024.php"); print "
"; } print ""; if ($dispbooks!="N") { if ($seriesblurb!="" or $seriesjpg=="Y") { print ""; if ($seriesjpg=="Y") { $seriespic="/seriesimages/s_".$serno.".jpg"; print "

$grname

"; } if ($seriesblurb!="") { print ""; print " "; print "
"; $seriesblurb=nl2br($seriesblurb); print "

$seriesblurb

"; print "
"; } print ""; } print ""; // display middle section message print ""; print " "; print "
"; $notitles="0"; // get all titles in this category and display the first ten... $resultse=mysqli_query($linkns, "SELECT * FROM 00prodseries WHERE pse_root='$serno' "); while($rowse = mysqli_fetch_row($resultse)) { $setitle=stripslashes($rowse[4]); $autno=$rowse[2]; } // get the author $resultau=mysqli_query($linkns, "SELECT * FROM 00authors where aut_number='$autno'"); while($rowau = mysqli_fetch_row($resultau)) {if ($rowau[1]==$autno) { $autname=stripslashes($rowau[5]);} else {$autname="Author Unknown";} } // check if series pricing exists $seriesprice="N"; $seriesbundle=""; $resultsb=mysqli_query($linkns, "SELECT * FROM 00autbundles where po_seriesno='$serno'"); while($rowsb = mysqli_fetch_row($resultsb)) { $seriesprice="Y"; $seriesbundle=$rowsb[2]; } print ""; print " "; print "
"; print "

$setitle by $autname

"; if ($seriesprice=="Y") { print "

We have a special price offer for the books in this series.

"; print "

Click here for more information.

"; } print "
"; $resultp=mysqli_query($linkns, "SELECT * FROM 00productmeta WHERE (pr_status='A' and (pr_style='R' or pr_style='E' or pr_style='S' or pr_style='D') and pr_f4ok='Y' and pr_seriesno='$serno') order by pr_serieselt "); while($rowp = mysqli_fetch_row($resultp)) { $pr=$rowp[1]; $pubno=$rowp[3]; $autno=$rowp[4]; $gencode1=$rowp[28]; $gencode2=$rowp[29]; $gencode3=$rowp[30]; $prevprod=$rowp[99]; $prevf4=$rowp[100]; $adultalert=$rowp[130]; $serieselt=$rowp[78]; $bookinc="Y"; if ($bookinc=="Y") { // now build up the display for the title... include("../scripts/bookprocmeta.php"); include("../scripts/f4serieslayout.php"); print "
"; } } print "
"; } // display middle section message print ""; include("../scripts/bottombar2022.php"); mysqli_close($linkns); ?>