';
// print_r($_GET);
// echo '';
if (isset($_SQLGET['decade']) == 0) {//no id given, abort
header('Location: index.php');
}
else {
if(is_numeric($_SQLGET['decade'])) {//is it a valid number
if($_SQLGET['decade']>=194 AND $_SQLGET['decade']<=203) {
$decade = $_SQLGET['decade'];
}
else {
header('Location: index.php');//id is not between 1940 and 2030; abort
}
}
else {
header('Location: index.php');//id is not a number; abort
}
}
//how many records in this decade
$SQL = "SELECT * FROM `tblitems` WHERE `itemReleaseDate` LIKE '%$decade%' AND `itemSold` != 'Y' ORDER BY `itemDateAdded` DESC";
$result = mysqli_query($dbc,$SQL) or dielog("Query failed : " . mysqli_error($dbc));
$selectedrecordcount = mysqli_num_rows($result);
//how many CDs
$formatSQL = " AND (itemFormat LIKE '%CD%' OR itemFormat LIKE '%DVD%' OR itemFormat LIKE '%CDS%') ";
$SQL = "SELECT * FROM `tblitems` WHERE `itemReleaseDate` LIKE '%$decade%' AND `itemSold` != 'Y'" . $formatSQL . " ORDER BY `itemDateAdded` DESC";
$CDresult = mysqli_query($dbc,$SQL) or dielog("Query failed : " . mysqli_error($dbc));
$CDrecordcount = mysqli_num_rows($CDresult);
//how many 7"
$formatSQL = " AND (itemFormat LIKE '%7%') ";
$SQL = "SELECT * FROM `tblitems` WHERE `itemReleaseDate` LIKE '%$decade%' AND `itemSold` != 'Y'" . $formatSQL . " ORDER BY `itemDateAdded` DESC";
$sevenresult = mysqli_query($dbc,$SQL) or dielog("Query failed : " . mysqli_error($dbc));
$sevenrecordcount = mysqli_num_rows($sevenresult);
//how many 12" / LP
$formatSQL = " AND (itemFormat LIKE '%12%' OR itemFormat LIKE '%LP%') ";
$SQL = "SELECT * FROM `tblitems` WHERE `itemReleaseDate` LIKE '%$decade%' AND `itemSold` != 'Y'" . $formatSQL . " ORDER BY `itemDateAdded` DESC";
$twelveresult = mysqli_query($dbc,$SQL) or dielog("Query failed : " . mysqli_error($dbc));
$twelverecordcount = mysqli_num_rows($twelveresult);
if (isset($_SQLGET['format']) == 0) {//no format given, assume all
$format = "";
$formatSQL = "";
}
else {
if($_SQLGET['format']=="cd") {
$format = "cd";
$formatSQL = " AND (itemFormat LIKE '%CD%' OR itemFormat LIKE '%DVD%' OR itemFormat LIKE '%CDS%') ";
}
elseif ($_SQLGET['format']=="7in") {
$format = "7in";
$formatSQL = " AND (itemFormat LIKE '%7%') ";
}
elseif ($_SQLGET['format']=="12in") {
$format = "12in";
$formatSQL = " AND (itemFormat LIKE '%12%' OR itemFormat LIKE '%LP%') ";
}
else {
$format = "";
$formatSQL = "";//ignore any other get parameters
}
}
?>
Pulse Records - Secondhand Records and CDs
$num_of_pages) { //avoids a blank page being shown
$page = $num_of_pages;
}
if($num_of_pages>1 AND $page<$num_of_pages) {
$nextpage = $page + 1;
}
else {
$nextpage = 0;
}
if($num_of_pages>1 AND $page>1) {
$previouspage = $page - 1;
}
else {
$previouspage = 0;
}
if($recordcount==0) {//if there are no results for the search
$limitstart = 0;
}
else {
$limitstart = ($page * $limit) -$limit;
}
$firstrow = $limit*($page-1)+1;
if($recordcount > $limit) {
$lastrow = ($limit*($page-1))+$limit;
if($lastrow>$recordcount) {
$lastrow = $recordcount;
}
// print ", displaying " . $firstrow . " to " . $lastrow;
}
$SQL = $SQL . " LIMIT $limitstart,$limit;";
//print $SQL;
//limit code end
?>
()
()