Adminware: For Sale
"; ?>
Sign In

Forgot password?
First-time register
The login/password used here is the same as that used in the PDF book downloads and Machin website; one login works in all areas.

  
"; echo "
Cart

"; // TOTAL number of CART items $sqlCart = "SELECT tblShopCart.CartId FROM tblShopCart WHERE CusNo=" . $mbrid; $cartlist = mysqli_query($conn, $sqlCart) or die("Couldn't execute query cart count"); $totalCart = mysqli_num_rows($cartlist); echo ""; echo $totalCart; echo "

"; echo ""; } ?>
0) { echo "

"; echo "×"; echo $_SESSION['Item2Cart_message']; echo "
"; } ?>

 

"; ?>Find
0) { echo ""; } if (strlen($_SESSION['defMonth']) > 0) { echo ""; } if (strlen($_SESSION['defSeason']) > 0) { echo ""; } echo "
"; echo "

"; $getC = mysqli_query($conn, "SELECT tblShopStock.ProductId FROM tblShopStock WHERE Country='Canada'") or die("Couldn't execute query Canada count"); $resultC = mysqli_num_rows($getC); $getU = mysqli_query($conn, "SELECT tblShopStock.ProductId FROM tblShopStock WHERE Country='USA'") or die("Couldn't execute query USA count"); $resultU = mysqli_num_rows($getU); $getG = mysqli_query($conn, "SELECT tblShopStock.ProductId FROM tblShopStock WHERE Country='Great Britain'") or die("Couldn't execute query GB count"); $resultG = mysqli_num_rows($getG); echo "

"; echo " "; echo ""; echo "
"; echo "
"; echo " "; echo ""; echo "
"; echo "
"; echo " "; echo ""; echo "
"; $getSt = mysqli_query($conn, "SELECT tblShopStock.ProductId FROM tblShopStock WHERE Category='Stamps'") or die("Couldn't execute query Canada count"); $resultSt = mysqli_num_rows($getSt); $getLit = mysqli_query($conn, "SELECT tblShopStock.ProductId FROM tblShopStock WHERE Category='Literature'") or die("Couldn't execute query Canada count"); $resultLit = mysqli_num_rows($getLit); $getPDF = mysqli_query($conn, "SELECT tblShopStock.ProductId FROM tblShopStock WHERE Category='PDF'") or die("Couldn't execute query Canada count"); $resulPDF = mysqli_num_rows($getPDF); echo "
"; echo "
"; echo " "; echo ""; echo "
"; echo "
"; echo " "; echo ""; echo "
"; echo "
"; echo " "; echo ""; echo "
"; ?>

"; echo ""; echo "

"; echo "
"; echo ""; echo "
"; // SERIES echo "
"; echo ""; echo "
"; // YEAR OF ISSUE echo "
"; echo ""; echo "
"; // TOPIC echo "
"; echo ""; echo "
"; // Mint/Used echo "
"; echo ""; echo "
"; ?>

Sort:

>
>

"; echo ""; echo ""; echo "
"; ?>

 

Note: Series, Year of Issue and Topic searches will only work for 'Canada' items.

0) { echo "

 

"; echo "×"; echo $_SESSION['Item2Watch_message']; echo "
"; } if(isset($UseStkNo)) { // request was for stkno; need to lookup ProductId first $sql = "SELECT tblShopStock.ProductId FROM tblShopStock WHERE StockNo = '" . $Details . "'"; $viewthis = mysqli_query($conn, $sql) or die("Couldn't execute query show item detail stkNo"); $viewrow = mysqli_fetch_array($viewthis, MYSQLI_BOTH); $Details = $viewrow["ProductId"]; } // $_SESSION['Details'] = $Details; $sql = "SELECT tblShopStock.* FROM tblShopStock WHERE ProductId = '" . $Details . "'"; //echo "mbrid: " . $mbrid; //echo $sql; $viewthis = mysqli_query($conn, $sql) or die("Couldn't execute query show item detail"); $viewrow = mysqli_fetch_array($viewthis, MYSQLI_BOTH); $stkNo = $viewrow["StockNo"]; //////// log view $NoRecord = $_GET['NoRecord']; if ($NoRecord != 'y') { $recentView = "No"; if ($mbrid > 0) { // if CusNo <> 0, check to see if this view is in the last 6 $viewSql = "SELECT tblShopStockViews.* FROM tblShopStockViews"; $viewSql .= " WHERE CusNo = " . $mbrid; $viewSql .= " ORDER BY ViewDate DESC LIMIT 6"; $viewlist = mysqli_query($conn, $viewSql) or die("Couldn't execute query last 6 views"); while($row = mysqli_fetch_array($viewlist, MYSQLI_BOTH)) { if ($row["StkNo"] == $stkNo) { $recentView = "Yes"; } } } //echo "viewed: " . $recentView; if ($recentView == "No") { $randid = $_SESSION['RandomId']; $rightnow = date('Y-m-d H:i:s'); $viewSQL = "INSERT INTO tblShopStockViews ( StkNo , CusNo , RandomView ) VALUES ('$stkNo', '$mbrid', '$randid' )"; //echo $viewSQL; // testing $appendresults = mysqli_query($conn, $viewSQL) or die("Couldn't execute query record stock view"); } } /////// echo "

 

"; echo "

"; echo "
"; echo "
"; if ($viewrow["StockImage"] == 1) { echo "(this is a stock image; item sold will be this or one similar)

"; } // click to enlarge image in new window echo "View larger image (will open in new window)"; if (strlen($viewrow["Image2"]) > 0) { echo "

"; } if (strlen($viewrow["Image3"]) > 0) { echo "

"; } echo "

 

Item # " . $viewrow["StockNo"]; if (strlen($viewrow["SeeAlsoStkNo"]) > 0) { echo "

" . $viewrow["SeeAlsoText"] . " " . $viewrow["SeeAlsoStkNo"] . "."; } // any similar items (based on Sc#)? $sqlSimilar = "SELECT tblShopStock.* FROM tblShopStock WHERE QtyOnHand > 0 And DoNotShow = 0 And Country = '" . $viewrow["Country"] . "' And Length(CatNo) > 1 And CatNo = '" . $viewrow["CatNo"] . "' And ProductId <> '" . $viewrow["ProductId"] . "' ORDER BY ProductId DESC "; // $sqlSimilar = "SELECT tblShopStock.* FROM tblShopStock WHERE QtyOnHand > 0 And DoNotShow = 0 And Country = '" . $viewrow["Country"] . "' And (CatNo = '" . $viewrow["CatNo"] . "' OR CatNoSort = '" . $viewrow["CatNo"] . "') And ProductId <> '" . $viewrow["ProductId"] . "' ORDER BY ProductId DESC "; if(isset($Similar)) { // similar items will be displayed below... } else { $similarList = mysqli_query($conn, $sqlSimilar) or die("Couldn't execute query similar items count"); $similarCnt = mysqli_num_rows($similarList); if ($similarCnt > 0) { echo "

 

" . $similarCnt . " similar items found - "; echo "view"; } } echo "

"; // left column (of pictures) echo "
"; echo "

" . $viewrow["Title"] . "

"; echo "

" . $viewrow["Description"] ; // MORE DETAILS HERE if (strlen($viewrow["OtherInfo"]) > 0) { echo "

" . $viewrow["OtherInfo"] . ""; } if (strlen($viewrow["ArticleLink"]) > 0) { echo "

For further research relevant to this item, click for more details (will open in new window)"; } echo "


"; if (strlen($viewrow["Country"]) > 0) { echo "

Country: " . $viewrow["Country"] . ""; } if (strlen($viewrow["Type"]) > 0) { echo "

Type: " . $viewrow["Type"]; } if (strlen($viewrow["CatNo"]) > 0) { echo "

" . $viewrow["Catalogue"] . " # " . $viewrow["CatNo"]; } if (strlen($viewrow["MintUsed"]) > 0) { echo "

Mint/used: " . $viewrow["MintUsed"]; } if (strlen($viewrow["ItemCondition"]) > 0) { echo "

Condition: " . $viewrow["ItemCondition"]; } if ($viewrow["CatVal"] > 0) { echo "

Catalogue value: $ " . number_format($viewrow["CatVal"], 2); } if ($viewrow["Weight"] > 0) { echo "

Weight: " . $viewrow["Weight"] . " grams    parcel shipping ($" . $viewrow["Postage"] . ")"; } if ($viewrow["SoldTo"] > 0) { // item is SOLD echo "

 

Currently out of stock

"; } else { if ($viewrow["Price"] == 0) { echo "

Price: Free!

"; } else { if ($viewrow["SalePrice"] > 0) { echo "

Price: $ " . number_format($viewrow["Price"], 2) . ""; echo "

SALE price $ " . number_format($viewrow["SalePrice"], 2) . "

"; } else { $ThisFeature = ""; $ThisDiscount = 0; if (($_SESSION['defWeek'] > 0) && ($viewrow["SpecialWeek"] == $_SESSION['defWeek'])) { $ThisFeature = "Weekly Feature ending " . $_SESSION['defWeekE']; $ThisDiscount = $_SESSION['defWeekD']; } if ((strlen($_SESSION['defMonth']) > 0) && ($viewrow["SpecialMonth"] == $_SESSION['defMonth'])) { $ThisFeature = $_SESSION['defMonth'] . " Feature"; $ThisDiscount = $_SESSION['defMonthD']; } if ((strlen($_SESSION['defSeason']) > 0) && ($viewrow["SpecialSeason"] == $_SESSION['defSeason'])) { $ThisFeature = $_SESSION['defSeason'] . " Feature"; $ThisDiscount = $_SESSION['defSeasonD']; } if ($ThisDiscount > 0) { echo "

Price: $ " . number_format($viewrow["Price"], 2) . "

"; echo "

" . $ThisFeature . " at " . $ThisDiscount . "% off = $ " . number_format(($viewrow["Price"] - ($viewrow["Price"] * $ThisDiscount/100)), 2) . "

"; } else { echo "

Price: $ " . number_format($viewrow["Price"], 2) . "

"; } } } // wholesale/qty discount? if (($viewrow["Discount"] > 0) && ($viewrow["DiscountQty"] > 0)) { echo "

[Quantity discount of " . $viewrow["Discount"] . "% available for orders of " . $viewrow["DiscountQty"] . " or more of same title (exact postage to be determined).]"; } } // Oct 1/21 // At moment, MUST BE Logged in to add to cart // // nned to watch to ensure Qty <> 0 in tblShopStock if ($login == 'Yes') // if ($viewrow["QtyOnHand"] == 0) if ($viewrow["SoldTo"] > 0) { if (strlen($_SESSION['Item2Watch_message']) == 0) { // no need to offer link as it was JUST added to want list echo "

"; } } else { if (($viewrow["QtyOnHand"] <= 1) || ($viewrow["Category"] == "PDF")) { // check to see if in cart... $chkCartsql = "SELECT tblShopCart.* FROM tblShopCart WHERE CusNo = " . $mbrid . " And StockNo = '" . $viewrow["StockNo"] . "'"; $chkCartlist = mysqli_query($conn, $chkCartsql) or die("Couldn't execute query check client stamp cart"); $chkCartCnt = mysqli_num_rows($chkCartlist); if ($chkCartCnt > 0) { echo "

 

"; } else { echo "

 

Add to cart

"; } } else { // check to see if in cart... $chkCartsql = "SELECT tblShopCart.* FROM tblShopCart WHERE CusNo = " . $mbrid . " And StockNo = '" . $viewrow["StockNo"] . "'"; $chkCartlist = mysqli_query($conn, $chkCartsql) or die("Couldn't execute query check client stamp cart"); $chkCartCnt = mysqli_num_rows($chkCartlist); if ($chkCartCnt > 0) { echo "

 

"; } else { echo "

 

"; echo "
"; echo ""; echo ""; echo "
"; echo "  "; echo "
"; } } if (strlen($_SESSION['Item2Watch_message']) == 0) { // no need to offer link as it was JUST added to watch list echo "

 

Add to watch list"; } } else { // NOT logged in... echo "

 

"; if ($viewrow["SoldTo"] == 0) { echo "(sign in to add to cart)"; } else { echo "(sign in to add to want list)"; } echo "

"; } echo "
"; // column echo "
"; // row if(isset($Similar)) { // show similar items... $similarList = mysqli_query($conn, $sqlSimilar) or die("Couldn't execute query similar items list"); echo "


Similar items...

"; //$simcounter = 0; if ($screenSize == "xs") { $simnewrow=2; $simperrow=2; } else { $simnewrow=4; $simperrow=4; } // echo "

"; while($rowSim = mysqli_fetch_array($similarList, MYSQLI_BOTH)) { if ($simnewrow == $simperrow) { echo "
"; $simnewrow=0; } echo "
"; echo "
"; // show picture; echo "
"; echo "

"; echo "

Item # " . $rowSim["StockNo"]; if ($rowSim["Price"] == 0) { echo "

Price: Free!

"; } else { if ($rowSim["SalePrice"] > 0) { echo "

Price: $ " . number_format($rowSim["Price"], 2) . ""; echo "

SALE price $ " . number_format($rowSim["SalePrice"], 2) . "

"; } else { echo "

Price: $ " . number_format($rowSim["Price"], 2) . "

"; } } $simnewrow++; echo "
"; // column if ($simnewrow == $simperrow) { echo "


"; // end of row } } echo "

"; // row } } // end of showing details of selected item else { ///////////////////////////////////////////////////// ///////////////////////////////////////////////////// // Display how many entries are in current view, and total in current search criteria // echo "
"; echo "
"; if(isset($_SESSION['todayCount'])) { } else { // get number of new additions; show just once $_SESSION['todayCount'] = 1; $n2_daysAgo = date('Y-m-d', strtotime('-2 days')); $sqlDayCnt = "SELECT tblShopStock.ProductId FROM tblShopStock WHERE DoNotShow = 0 And WantListTo = 0 And DateAdded >= '" . $n2_daysAgo . "'"; $dayCount = mysqli_query($conn, $sqlDayCnt) or die("Couldn't execute query Stamp Stock 2-day count"); $cnt2days = mysqli_num_rows($dayCount); echo "

 

"; echo "×"; if ($cnt2days > 0) { echo "" . $cnt2days . " items have been added for sale in the last two (2) days." ; } else { // nothing added in last TWO days, so check last WEEK $n2_daysAgo = date('Y-m-d', strtotime('-7 days')); $sqlDayCnt = "SELECT tblShopStock.ProductId FROM tblShopStock WHERE DoNotShow = 0 And WantListTo = 0 And DateAdded >= '" . $n2_daysAgo . "'"; $dayCount = mysqli_query($conn, $sqlDayCnt) or die("Couldn't execute query Stamp Stock 2-day count"); $cnt2days = mysqli_num_rows($dayCount); echo "" . $cnt2days . " items have been added for sale in the last week." ; } echo "
"; } echo "

 

"; echo "

September 17: The extra postage on the 'fabric' stock items is for shipments in Canada; rates outside of Canada will be higher - please request the cost."; echo "

August 29: Effective August 29, orders to the United States are suspended due to the recent tariffs improsed by the Trump Administration."; echo "

"; $lowview = ($activePage * $maxPerPage - $maxPerPage + 1); $highview = ($activePage * $maxPerPage); if ($highview > $totalStock) { $highview = $totalStock; } if ($totalStock == 0) { $msg = "none found"; } else { $msg = $lowview . "-" . $highview . " of " . $totalStock; } echo " 

" . $strFind . " (" . $msg . ")

"; echo "
"; // echo "
"; if ($totalStock > $maxPerPage) { $numPages = intval($totalStock / $maxPerPage) + 1; echo "
    "; echo "
  • Previous
  • "; if ($numPages <= 8) { // list is short enought, show ALL 8 pages for ($i = 1; $i <= $numPages; $i++) { echo "
  • " . $i . "
  • "; } } else { // list first and last couple, and some in between // first 2 if ($activePage <= 4) { for ($i = 1; $i <= 4; $i++) { echo "
  • " . $i . "
  • "; } } else { echo "
  • 1
  • "; } // some in between echo "
  • ...
  • "; if (($activePage > 4) && ($activePage < $numPages - 3)) { for ($i = ($activePage - 1); $i <= $activePage + 1; $i++) { echo "
  • " . $i . "
  • "; } echo "
  • ...
  • "; } // last 2 if ($activePage >= ($numPages - 3)) { for ($i = ($numPages - 3); $i <= $numPages; $i++) { echo "
  • " . $i . "
  • "; } } else { echo "
  • " . $numPages . "
  • "; } } echo "
  • Next
  • "; // echo "'>Next"; echo "
"; } /////////////// // show year options if ($_SESSION['defShowYear'] <> 0) { echo "
Year: " . ($_SESSION['defShowYear'] - 2) . ""; echo "  " . ($_SESSION['defShowYear'] - 1) . ""; echo "  " . $_SESSION['defShowYear'] . ""; echo "  " . ($_SESSION['defShowYear'] + 1) . ""; echo "  " . ($_SESSION['defShowYear'] + 2) . ""; echo ""; } // end of show year options echo "
"; // echo "
"; // // Display results of current search criteria if ($totalStock == 0) { echo "

 

"; echo "×"; echo "Sorry, no items found at this time for '" . $strFind . "'.

Why not create a want list (via 'My Account')"; echo "

"; } else { echo "All prices in Canadian dollars."; if ($login <> 'Yes') { echo " Sign in to add items to cart."; } echo "

"; //echo "

" . $sql; // testing purposes $counter = 0; if ($screenSize == "xs") { $newrow=2; $perrow=2; } else { $newrow=3; $perrow=3; } while($viewrow = mysqli_fetch_array($viewlist, MYSQLI_BOTH)) { // $thisType = $viewrow["ProductType"]; // if ($newrow == 3) if ($newrow == $perrow) { echo "

"; $newrow=0; } // start column for current stock item if (($viewrow["DoNotShow"] == 0) && ($viewrow["WantListTo"] == 0)) // do NOT show if value = -1 { echo "
"; echo "
"; if ($viewrow["SoldTo"] > 0) { echo "
"; } else { if ($viewrow["SalePrice"] > 0) { echo "
Price reduced
"; } $ThisDiscount = 0; if (($_SESSION['defWeek'] > 0) && ($viewrow["SpecialWeek"] == $_SESSION['defWeek'])) { echo "
Weekly Feature ending " . $_SESSION['defWeekE'] . " (" . $_SESSION['defWeekD'] . "% off)
"; $ThisDiscount = $_SESSION['defWeekD']; } if ((strlen($_SESSION['defMonth']) > 0) && ($viewrow["SpecialMonth"] == $_SESSION['defMonth'])) // if ($viewrow["SpecialMonth"] == $_SESSION['defMonth']) { echo "
" . $_SESSION['defMonth'] . " Feature (" . $_SESSION['defMonthD'] . "% off)
"; $ThisDiscount = $_SESSION['defMonthD']; } if ((strlen($_SESSION['defSeason']) > 0) && ($viewrow["SpecialSeason"] == $_SESSION['defSeason'])) { echo "
" . $_SESSION['defSeason'] . " Feature (" . $_SESSION['defSeasonD'] . "% off)
"; $ThisDiscount = $_SESSION['defSeasonD']; } echo "
"; } echo "

" . $viewrow["Title"] . "

"; if ((strlen($viewrow["Country"]) > 0) && ($viewrow["Country"] != "Canada")) { echo "" . $viewrow["Country"] . " "; } if (strlen($viewrow["CatNo"]) > 0) { if (strlen($viewrow["Catalogue"]) > 0) { echo $viewrow["Catalogue"] . " " . $viewrow["CatNo"] . "
"; } else { echo "Cat# " . $viewrow["CatNo"] . "
"; } } if ((strlen($viewrow["MintUsed"]) > 0) && ($viewrow["Type"] <> "Used single")) { echo $viewrow["MintUsed"]; } if (strlen($viewrow["Type"]) > 0) { if ((strlen($viewrow["MintUsed"]) > 0) && ($viewrow["Type"] <> "Used single")) { echo " | "; } echo $viewrow["Type"]; } echo "

"; // show picture; $fname = "pics/" . $viewrow["Image"]; list($Iwidth, $Iheight, $Itype, $Iattr) = getimagesize($fname); if ($Iwidth > 275) { //echo "1"; if ($Iheight > ($Iwidth * 1.75)) { //echo "a"; echo "
"; } else { //echo "b"; echo "
"; } } else { //echo "2"; echo "
"; } echo "
"; // echo "

Iwidth: " . $Iwidth; // echo "
Iheight: " . $Iheight; if ($viewrow["StockImage"] == 1) { echo "

[Stock image]
"; } echo "

" . $viewrow["Description"] . "

"; if ($viewrow["SoldTo"] == 0) { // only showi pricing if item is not sold if ($viewrow["Price"] == 0) { echo "

Free!

"; } else { if ($viewrow["SalePrice"] > 0) { echo "
$ " . number_format($viewrow["Price"], 2) . "
"; echo "

SALE $ " . number_format($viewrow["SalePrice"], 2) . "

"; } else { if ($ThisDiscount > 0) { echo "
$ " . number_format($viewrow["Price"], 2) . "
"; echo "

Feature at " . $ThisDiscount . "% off = $ " . number_format(($viewrow["Price"] - ($viewrow["Price"] * $ThisDiscount/100)), 2) . "

"; } else { echo "

$ " . number_format($viewrow["Price"], 2) . "

"; } } } } $wait4details = "yes"; if ($wait4details == "no") { if ($viewrow["Weight"] > 0) { echo " parcel shipping ($" . $viewrow["Postage"] . ")"; } if (($viewrow["Discount"] > 0) && ($viewrow["DiscountQty"] > 0)) { echo "

[Quantity discount available]"; } echo "

Item # " . $viewrow["StockNo"]; } echo "

"; // end of panel if ($viewrow["SoldTo"] > 0) { echo ""; } else { if ($login == 'Yes') { // check to see if in cart... $chkCartsql = "SELECT tblShopCart.* FROM tblShopCart WHERE CusNo = " . $mbrid . " And StockNo = '" . $viewrow["StockNo"] . "'"; $chkCartlist = mysqli_query($conn, $chkCartsql) or die("Couldn't execute query check client stamp cart"); $chkCartCnt = mysqli_num_rows($chkCartlist); if ($chkCartCnt > 0) { echo "
"; } else { if ($viewrow["Weight"] > 0) { echo "
parcel shipping
"; } echo "

"; // echo "

"; } } } echo "

"; // end of body $newrow++; if ($newrow == 3) { echo "
"; // end of row } echo "
"; // end of column } // end of IF DoNotShow=0 (only show products that are available for sale $counter++; } // end of while echo "
"; } echo "
"; // BOTTOM of listings pagination if ($totalStock > $maxPerPage) { $numPages = intval($totalStock / $maxPerPage) + 1; echo ""; } echo "
"; } // end of listing results ?>

Adminware Corporation
© 1996-2025, 2026 Robin Harris
Adminware is a trademark of Adminware Corporation.