require "includes/session.php"; $_SESSION['shop_return_url'] = $_SERVER['REQUEST_URI']; ?>
$pageTitle="Auction Lot"; ?> require 'includes/head.php'; ?> if($_GET['axcode']){ $ax_code = strtolower($_GET['axcode']); $ax_codeUC = strtoupper($ax_code); $ax_codeFldr = SUBSTR($ax_code, 0, 1).SUBSTR($ax_code, 2, 2); $ax_link = 'auction/graphics/'.$ax_codeFldr.'/'; }else{ $ax_code='oc10'; } SetToolsDB(); $SQL = "SELECT A_LOTS,SEQ_ORDER FROM auction_n WHERE NFULL_CODE ='$ax_codeUC'"; $Auction = mysql_db_query($dbname, $SQL) or die("Failed Query of " . $SQL); //do the query $AuctionCount=mysql_numrows($Auction); if ($_GET['next']=="true"){ if($AuctionCount!=0){ if($_GET['lotNum']==mysql_result($Auction,0,"A_LOTS")){ $SQL = "SELECT * FROM auction,auction_n WHERE auction.NAUCT_CODE=auction_n.NFULL_CODE AND NAUCT_CODE='$ax_codeUC' AND AUCT_NUMB=1"; }else{ $SQL = "SELECT * FROM auction,auction_n WHERE auction.NAUCT_CODE=auction_n.NFULL_CODE AND NAUCT_CODE='$ax_codeUC' AND AUCT_NUMB>".$_GET['lotNum']." ORDER BY AUCT_NUMB LIMIT 1"; } }else{ $SQL = "SELECT * FROM auction,auction_n WHERE auction.NAUCT_CODE=auction_n.NFULL_CODE AND NAUCT_CODE='$ax_codeUC' AND AUCT_NUMB>".$_GET['lotNum']." ORDER BY AUCT_NUMB LIMIT 1"; } }elseif($_GET['prev']=="true"){ if ($_GET['lotNum']==1){ $SQL = "SELECT * FROM auction,auction_n WHERE auction.NAUCT_CODE=auction_n.NFULL_CODE AND NAUCT_CODE='$ax_codeUC' AND AUCT_NUMB=".mysql_result($Auction,0,"A_LOTS"); }else{ $SQL = "SELECT * FROM auction,auction_n WHERE auction.NAUCT_CODE=auction_n.NFULL_CODE AND NAUCT_CODE='$ax_codeUC' AND AUCT_NUMB<".$_GET['lotNum']." ORDER BY AUCT_NUMB DESC LIMIT 1"; } }else{ $SQL = "SELECT * FROM auction,auction_n WHERE auction.NAUCT_CODE=auction_n.NFULL_CODE AND NAUCT_CODE='$ax_codeUC' AND AUCT_NUMB=".$_GET['lotNum']; } $Item_Results = mysql_db_query($dbname, $SQL) or die("Failed Query of " . $SQL); //do the query $ItemCount = mysql_numrows($Item_Results); ?> " /> " /> " /> require "includes/bodyPage.php";?> echo $curPath;?> if($ItemCount==0){ echo "| getSize($theimg,$theimglg)?> |
