";
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 "";
}
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);
?>