");
PrintTrailer();
return;
}
if (!isset($querystr)) {
$querystr = "str_ID <> 0 and tblStrip.aut_ID=tblAuteur.aut_ID and tblStrip.ser_ID=tblSerie.ser_ID and tblStrip.uit_ID=tblUitgever.uit_ID and ";
if ($str_Paginas) {
$querystr .= "str_Paginas = $str_Paginas% and ";
}
if ($str_Jaar) {
$querystr .= "str_Jaar like '%$str_Jaar%' and ";
}
if ($str_Naam) {
$querystr .= "str_Naam like '%$str_Naam%' and ";
}
if ($aut_ID) {
$querystr .= "tblStrip.aut_ID = $aut_ID and ";
}
if ($ser_ID) {
$querystr .= "tblStrip.ser_ID = $ser_ID and ";
}
if ($uit_ID) {
$querystr .= "tblStrip.uit_ID = $uit_ID and ";
}
// remove last ' and '
$querystr = substr($querystr, 0, strlen($querystr)-4);
}
else {
$querystr = urldecode($querystr);
$querystr = ereg_replace("#", "%", $querystr);
}
if ($items == 0) {
$result = Query("select count(*) as aantal from tblStrip,tblAuteur,tblUitgever,tblSerie where $querystr");
if ($result) {
if ($row = Row($result)) {
$items = $row[aantal];
}
Free($result);
}
}
if ($items == 0) {
PrintHeader("Strips zoeken");
print Error("Geen Strips gevonden.");
exit;
}
if ($page == 0) {
$page = 1;
}
$offset = ($page - 1) * $max_items;
$rows = $max_items;
/* Hoe sorteren? */
$order_by = array('aut_Achternaam','str_Naam','uit_Naam','ser_Naam','str_Paginas','str_Jaar','str_Naam');
if (!in_array($order,$order_by)) {
$order = 'str_Naam';
}
$result = Query("select aut_Voornaam,aut_Tussen,aut_Achternaam,uit_Naam,ser_Naam,str_ID,str_Paginas,str_Jaar,str_Naam from tblStrip,tblAuteur,tblUitgever,tblSerie where $querystr order by $order limit $offset,$rows");
if ($items == 1) {
$row = Row($result);
Header("Location: toonstrip.php?session=$session&str_ID=$row[str_ID]");
Free($result);
Disconnect($conn);
return;
} else {
$querystr = ereg_replace("%", "#", $querystr);
PrintHeader("Strips zoeken");
if ($items > $max_items) {
for ($pagcnt=1; $pagcnt <= (ceil($items / $max_items)); $pagcnt++) {
if ($pagcnt == $page) {
$class = "pageCurrent";
}
else {
$class = "page";
}
echo("