DOH!!
<?php
// GET PAGE ID
$page = $_GET[pageid];
$start = $_GET[start];
$cat = $_GET[cat];
if(!isset($cat)) $cat = 0;
// CONNECT TO DATABASE
require("scripts/connect_db.php");
// SET PAGES
if(!isset($start)) $start = 0;
$rows_per_page = 5;
$sql = "SELECT *, date_format(date, '%e/%c-%Y') as date FROM publications ";
$sql .= "LIMIT $start, $rows_per_page";
$result = mysql_query($sql);
// TITLE
echo "<h1>Udgivelser</h1>";
echo "<div class=\\"decotext\\">";
// CAT SELECTOR
// CATEGORY ARRAY
$cat_array = array("Vælg kategori...",
"Musikteori & Historie",
"Undervisningsbøger",
"Sangbøger",
"Kornoder",
"Melodibøger",
"Børnemusik",
"Julemusik");
// SELECTOR
echo "<form action=\\"".$path."scripts/get_pub_list.php?pageid=5\\" method=\\"post\\">";
echo "<select name=\\"cat\\">";
foreach ($cat_array as $selected => $category) {
if ($cat == $selected) $current = " selected";
else $current = "";
echo "<option value=\\"$selected\\"" .$current.">".$category."</option>\\n";
}
echo "</select>";
echo "<input type=\\"submit\\" name=\\"submit\\" value=\\"Vælg\\">";
echo "</form>";
echo "<br><br>";
// OUTPUT NEWS
while($row = mysql_fetch_array($result)) {
// IMAGE
echo "<img width=\\"50\\" src=\\"".$path."images/publications/".$row['img_id'].".jpg\\" style=\\"float: right; margin-left: 1em\\">";
// TITLE
echo "<h3>".$row['title']."</h3><br>";
// PUBLISHER / LINK
if ($row['publisher'] && ($row['link'])) {
echo "<p><b>Forlag:</b> <a href=\\"".$row['link']."\\" target=\\"_blank\\">".$row['publisher']."</a><br></p>";
} elseif ($row['publisher']) {
echo "<p><b>Forlag:</b> ".$row['publisher']."<br></p>";
}
// AUTHOR
if ($row['author']) {
echo "<p><b>Forfatter/redaktør:</b> ".$row['author']."<br></p>";
}
// DETAILS
if ($row['date']) {
echo "<p><b>Udgivelsesdato:</b> ".$row['date']."<br></p>";
}
// PRICE
if ($row['price']) {
echo "<p><b>Pris:</b> ".$row['price'].",- DKK<br></p>";
}
// OMTALE
echo "<p><b>Omtale:</b> <a href=\\"#\\" target=\\"_parent\\">Klik her</a></p>";
echo "<br><br><br>";
}
echo "</div>";
echo "<br>";
// PREV / NEXT
$query = "SELECT count(*) as count FROM publications";
$result = mysql_query($query);
$row = mysql_fetch_array($result);
$numrows = $row['count'];
echo "<p align=\\"center\\">";
if($start > 0)
echo "<a href='". $PHP_SELF ."?pageid=10&start=". ($start - 10) ."'><- Forrige</a>";
if(($start > 0) AND ($numrows > ($start + 10)))
echo " | ";
if($numrows > ($start + 10))
echo "<a href='" . $PHP_SELF . "?pageid=10&start=" . ($start + 10) . "'>Næste -></a>";
echo "</p>";
// CLOSE CONNECTION TO DATABASE
include("scripts/close_db.php");
?>