$pageTitle="Auction List";?>
require "includes/head.php";?>
if($_GET['page']){
$start=($_GET['page'] - 1) * $itemsPerPage;
}else{
$start=0;
}
SetToolsDB();
//Used for pagination finds total number of records (must have same WHERE as next SQL
$SQL = "SELECT COUNT(*) as num FROM auction WHERE NAUCT_CODE='$ax_code'";
$total_records = mysql_fetch_array(mysql_db_query($dbname,$SQL));
$total_records = $total_records[num];
?>
require "includes/bodyPage.php";?>
echo $curPath;?>
Results per page:
SetToolsDB();
//$SQL = "SELECT AUCT_NAME1, SINGLEDATE, AUCT_LOC, AUCT_CITY, AUCT_STATE FROM auction_n WHERE NFULL_CODE='$ax_code'";
$SQL = "SELECT AUCT_NAME, SINGLEDATE, AUCT_LOC, AUCT_CITY, AUCT_STATE,F_ADDRESS, DATE_FORMAT($ax_dt, '%M %e, %Y, %l:%i%p') as START_TIME FROM auction_n WHERE NFULL_CODE='$ax_code'";
//select the home section
$Auct_Results = mysql_db_query($dbname, $SQL) or die("Failed Query of " . $SQL); //do the query
$RecCount = mysql_numrows($Auct_Results);
if($RecCount==0){
echo "";
}else{
?>
//SQL pull only records between start and items per page
SetToolsDB();
$SQL = "SELECT * FROM auction WHERE NAUCT_CODE='$ax_code' ORDER BY AUCT_NUMB";
if($itemsPerPage!="NA"){
$SQL=$SQL." LIMIT $start, $itemsPerPage;"; //select the home section
}
$results = mysql_db_query($dbname, $SQL) or die("Failed Query of " . $SQL); //do the query
$RecCount = mysql_numrows($results);
?>