
"; // 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 ""; } ?>
"; echo "
"; } // click to enlarge image in new window echo "View larger image (will open in new window)"; if (strlen($viewrow["Image2"]) > 0) { 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 "
" . $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 "
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 "
SALE price $ " . number_format($viewrow["SalePrice"], 2) . "
[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 "
"; } else { 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 "
"; //$simcounter = 0; if ($screenSize == "xs") { $simnewrow=2; $simperrow=2; } else { $simnewrow=4; $simperrow=4; } // echo "
"; echo "
Item # " . $rowSim["StockNo"]; if ($rowSim["Price"] == 0) { echo "
SALE price $ " . number_format($rowSim["SalePrice"], 2) . "
"; // end of row } } 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 "
Why not create a want list (via 'My Account')
"; 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 "
Iwidth: " . $Iwidth;
// echo "
Iheight: " . $Iheight;
if ($viewrow["StockImage"] == 1)
{
echo "
" . $viewrow["Description"] . "
"; if ($viewrow["SoldTo"] == 0) { // only showi pricing if item is not sold if ($viewrow["Price"] == 0) { echo "
[Quantity discount available]"; } echo "
Item # " . $viewrow["StockNo"]; } echo "
"; } } } echo "