select db error: " . @mysql_error); } $msgLogin = ""; //$testMsg = "0"; // LOGIN routines if(isset($_SESSION['mbrid'])) { //echo "

test0"; /* testing purposes Apr 30/13*/ //$testMsg .= "-0a"; if ($login=='No') { $loggedin="No"; unset($_SESSION['mbrid']); //echo "

test0a-unsetMbrId"; /* testing purposes Apr 30/13*/ } else { //$testMsg .= "-0b"; $fullname = $_SESSION['logname']; $mbrid = $_SESSION['mbrid']; //echo "

test0b"; /* testing purposes Apr 30/13*/ } } else { //$testMsg .= "-1"; $email=$_POST['emailz']; $pswd=$_POST['pswdz']; $remember=$_POST['autologin']; // Mar 1/17 $email=mysqli_real_escape_string($conn, $email); $pswd=mysqli_real_escape_string($conn, $pswd); //$testMsg .= $login . "-1a" . $email . $pswd; if (($login=='Yes') && (strlen($pswd) > 0)) { //echo "

test1"; //$testMsg .= "-1a" . $email . $pswd; $get = mysqli_query($conn, "SELECT * FROM PDFClient WHERE Email='$email' and Cus_Password='$pswd'") or die("Couldn't execute query login"); $result = mysqli_num_rows($get); //$testMsg .= "-1b"; //echo "

test2 " . $email . " " . $pswd . " Result: " . $result; if($result != 1) { $loggedin="No"; $_SESSION['logged']="No"; unset($_SESSION['mbrid']); /*echo "2a-unsetMbrId"; /* testing purposes Apr 30/13*/ //$testMsg .= "-1c"; if (strlen($email) == 0) { /* nothing was entered in the Email; do not show a message */ //echo "

test2a"; /* testing purposes Apr 30/13*/ //$testMsg .= "-1d"; } else { $msgLogin = "E-mail/password not found or incorrect. Try again!"; //echo "

test2b"; /* testing purposes Apr 30/13*/ $loggedin="No"; $_SESSION['logged']="No"; unset($_SESSION['mbrid']); $login = 'No'; } } else { //echo "

test3"; /* testing purposes Apr 30/13*/ //$testMsg .= "-2"; $sql = "SELECT * FROM PDFClient WHERE Email='$email' and Cus_Password='$pswd'"; $result2 = mysqli_query($conn, $sql); $row = mysqli_fetch_assoc($result2); if($row) { $fullname = $row["FirstName"] . " " . $row["LastName"]; $firstname = $row["FirstName"]; $lastview = $row["LastAccess"]; $lastupdate = $row["LastUpdated"]; $mbrid = $row["CusNo"]; $_SESSION['logname'] = $fullname; $_SESSION['mbrid'] = $mbrid; $_SESSION['MachinSite'] = $row["MachinSite"]; $mbrLevel = $row["MachinLevel"]; $_SESSION['PicFolder'] = "lowpics2022"; if (strlen($mbrLevel) > 0) { switch ($mbrLevel) { case "Novice": $_SESSION['MemberLevel'] = 1; break; case "Intermediate": $_SESSION['MemberLevel'] = 2; break; case "Specialized": $_SESSION['MemberLevel'] = 3; break; case "Full access": $_SESSION['MemberLevel'] = 4; $_SESSION['PicFolder'] = "hires"; $_SESSION['AlwaysHiRes'] = $row["MachinHiresAlways"]; break; } } else { $_SESSION['MemberLevel'] = 0; $_SESSION['PicFolder'] = "lowpics2022"; // lo-res folder } $rightnow = date('Y-m-d H:i:s'); $query = "UPDATE PDFClient SET LastAccess='$rightnow' WHERE CusNo='$mbrid'"; $uresult = mysqli_query($conn, $query); $loggedin="Yes"; $viewSQL = "INSERT INTO PDFLogins ( accessDate , CusNo, Module ) VALUES ('$rightnow', '$mbrid', 'Machin' )"; $appendresults = mysqli_query($conn, $viewSQL); if ($remember == 1) // login: 'remember me?' checked off { $cookie_value = $email; setcookie($cookie_name, $cookie_value, time() + (86400 * 30), "/"); // 86400 = 1 day } } else { /*echo "3";*/ //$testMsg .= "-3"; $message = "E-mail/password not found or incorrect. Try again!"; // echo "E-mail/password not found"; $loggedin="No"; } } } else { //echo "

test4"; /* testing purposes Apr 30/13*/ //$testMsg .= "-4"; $loggedin="No"; $_SESSION['logged']="No"; unset($_SESSION['mbrid']); /*echo "4-unsetMbrId"; /* testing purposes Apr 30/13*/ } } /* end of already logged in */ //$testMsg .= "-5"; //////// save member routine ///////////////// if ($_GET['profile'] == 'saveProfile') { $_SESSION['msg_email'] = ""; $_SESSION['msg_pwd'] = ""; $_SESSION['savembr_redo'] = "Yes"; $missing="No"; $email = mysqli_real_escape_string($conn, $_POST['email']); $pwd = mysqli_real_escape_string($conn, $_POST['pswd']); $MachinSite = 1; // force this, in case previous value was 0 $emailAlbum = mysqli_real_escape_string($conn, $_POST['emailAlbum']); if ($emailAlbum == 'on') { $emailAlbum = 1; } else { $emailAlbum = 0; } $emailDB = mysqli_real_escape_string($conn, $_POST['emailDB']); if ($emailDB == 'on') { $emailDB = 1; } else { $emailDB = 0; } $HiRes = mysqli_real_escape_string($conn, $_POST['HiRes']); if ($HiRes == 'on') { $HiRes = 1; $_SESSION['PicFolder'] = "hires"; } else { $HiRes = 0; $_SESSION['PicFolder'] = "lowpics2022"; } $_SESSION['AlwaysHiRes'] = $HiRes; $mbrno = $_SESSION['mbrid']; if (strlen($email) == 0) { $_SESSION['msg_email'] = "required"; $missing="Yes"; } if (strlen($pwd) == 0) { $_SESSION['msg_pwd'] = "required"; $missing="Yes"; } if ($missing == "No") { $sql = "SELECT PDFClient.* FROM PDFClient WHERE CusNo=" . $mbrno; //echo "

" . $sql . "

"; $mbrlist = mysqli_query($conn, $sql) or die("Couldn't execute query client save"); $row = mysqli_fetch_array($mbrlist, MYSQLI_BOTH); $bAny = "No"; // has any field changed? $bPwd = "No"; // has password changed? $bEmail = "No"; // has Email changed? $fldsupdated = ""; if ($email != $row["Email"]) { $mbrno = $row["CusNo"]; $oldEmail = $row["Email"]; $fldsupdated .= "Email='$email', "; $bAny = "Yes"; $bEmail = "Yes"; } if ($pwd != $row["Cus_Password"]) { $fldsupdated .= "Cus_Password='$pwd', "; $bAny = "Yes"; $bPwd = "Yes"; } /// if ($MachinSite != $row["MachinSite"]) { $fldsupdated .= "MachinSite='$MachinSite', "; $bAny = "Yes"; } if ($emailAlbum != $row["MachinEmailAlbum"]) { $fldsupdated .= "MachinEmailAlbum='$emailAlbum', "; $bAny = "Yes"; } if ($emailDB != $row["MachinEmailDB"]) { $fldsupdated .= "MachinEmailDB='$emailDB', "; $bAny = "Yes"; } if ($HiRes != $row["MachinHiResAlways"]) { $fldsupdated .= "MachinHiResAlways='$HiRes', "; $bAny = "Yes"; } $rightnow = date('Y-m-d H:i:s'); if ($bAny == "Yes") { // $fldsupdated .= "LastUpdatedDate='$rightnow', LastUpdatedBy='$mbrno', "; $fldsupdated .= "LastUpdated='$rightnow', "; } if ($bPwd == "Yes") { $fldsupdated .= "PswdChanged='$rightnow', "; } if (strlen($fldsupdated) == 0) { $_SESSION['savembr_message'] = "Nothing was changed; no need to save."; } else { /* save member edit entry */ $fldsupdated = substr($fldsupdated, 0, -2); // take off the last 2 characters $query = "UPDATE PDFClient SET " . $fldsupdated . " WHERE CusNo='$mbrno'"; $uresult = mysqli_query($conn, $query); if ($bEmail == "Yes") { // email changed: record old and new... $viewSQL = "INSERT INTO PDFEmailChanges ( `CusNo` , `OldEmail` , `NewEmail` , `ChangeDate` ) VALUES ('$mbrno', '$oldEmail', '$email', '$rightnow' )"; $appendresults = mysqli_query($conn, $viewSQL) or die("Couldn't execute query PDF email change"); } $_SESSION['savembr_message'] = "Changes have been recorded."; $_SESSION['savembr_redo'] = "No"; // everything has been completed; do not show old values in form } } else { $_SESSION['savembr_message'] = "Unable to save. Something is either missing or not quite right. Please try again. "; } } else { $_SESSION['savembr_message'] = ""; } //////////////////// end of save member routine $_SESSION['Item2Watch_message'] = ""; ////// Add 2 watch list //////// if ($_GET['Add2Watch'] == 'Add') { $item = $_GET['itemno']; $rightnow = date("Y/m/d H:s"); $get = mysqli_query($conn, "SELECT count(CusNo) as Total FROM tblMachinFavourites WHERE CusNo='" . $mbrid . "' And MachinId='" . $item . "'"); $dataExist=mysqli_fetch_assoc($get); if ($dataExist['Total'] == 0) { $queryCart = "INSERT INTO tblMachinFavourites ( CusNo, MachinId, DateAdded ) VALUES ('$mbrid', '$item', '$rightnow' )"; $_SESSION['Item2Watch_message'] = "Item added to My Favourites list"; unset($_SESSION['Details']); //echo "

add to favourite: " . $queryCart; $cresult = mysqli_query($conn, $queryCart) or die("Couldn't execute query Add to My Favourites list"); } else { $_SESSION['Item2Watch_message'] = "This item is already on your My Favourites list"; } } ////// end of Add 2 watch list //////// /////////// my favourite remove ////////////////////// if ($_GET['Add2Watch'] == 'Remove') { $delete = $_GET['itemno']; $query = "DELETE FROM tblMachinFavourites WHERE FavId='" . $delete . "' LIMIT 1"; //echo $query; $uresult = mysqli_query($conn, $query) or die("Couldn't execute query favourite remove"); $_SESSION['Item2Watch_message'] = "My Favourite entry has been removed."; } ////// END of my favourite remove ////////////////////// $_SESSION['AddWant_message'] = ""; //// REMOVE checklist / wantlist if(isset($_POST['RemoveCheckList'])) { $delete = $_POST['delete']; if ($delete == "Yes") { $mbrno = $_SESSION['mbrid']; $count = count($_POST["id"]); //echo "

 " ; for($i=0;$i<$count;$i++) { $query = "DELETE FROM tblMachinWantList WHERE CusNo='" . $mbrno . "' AND MachinId='" . $_POST['id'][$i] . "' LIMIT 1"; //echo "

" . $query; $uresult = mysqli_query($conn, $query) or die("Couldn't execute query check/want remove"); } $_SESSION['AddWant_message'] = "Check/Wants has been blanked out for this design."; } } //// end of REMOVE checklist / wantlist //// save checklist / wantlist if(isset($_POST['UpdateCheckList'])) { $mbrno = $_SESSION['mbrid']; $rightnow = date("Y/m/d H:s"); $_SESSION['AddWant_message'] = "Check/Wants has been updated."; //echo "

 "; // 0) set checkboxes to blank / update comment $count = count($_POST["id"]); for($i=0;$i<$count;$i++) { // does entry exist? If not, need to insert $sqlCart = "SELECT tblMachinWantList.* FROM tblMachinWantList WHERE CusNo='" . $mbrno . "' AND MachinId='" . $_POST['id'][$i] . "'"; $viewCnt = mysqli_query($conn, $sqlCart) or die("Couldn't execute query want count"); $cntWant = mysqli_num_rows($viewCnt); $comment = mysqli_real_escape_string($conn, $_POST['comment'][$i]); if ($cntWant == 1) { $sqlUpCart2 = "UPDATE tblMachinWantList SET HaveMint='0', HaveUsed='0', NeedIt='0', Comment='" . $comment . "' WHERE CusNo='" . $mbrno . "' AND MachinId='" . $_POST['id'][$i] . "'"; //echo "
" . $sqlUpCart2; $uresult = mysqli_query($conn, $sqlUpCart2) or die("Couldn't execute query update want list (comment)"); } else { if (strlen($comment) > 0) { $sqlUpCart2 = "INSERT INTO tblMachinWantList ( CusNo, MachinId, DateAdded, Comment ) VALUES ('$mbrno', '" . $_POST['id'][$i] . "', '$rightnow', '" . $comment . "' )"; //echo "

" . $sqlUpCart2; $uresult = mysqli_query($conn, $sqlUpCart2) or die("Couldn't execute query insert want list (comment)"); } } } // end of comment/blank checks // 1) Check Mint checkboxes $aMint = $_POST['mint']; if(empty($aMint)) { // echo("Nothing check in Mint"); } else { $N = count($aMint); // echo("You selected $N item(s): "); for($i=0; $i < $N; $i++) { // echo($aMint[$i] . " "); if ($aMint[$i] == 'on') { $mint = 1; } else { $mint = 0; } $sqlCart = "SELECT tblMachinWantList.* FROM tblMachinWantList WHERE CusNo='" . $mbrno . "' AND MachinId='" . $aMint[$i] . "'"; $viewCnt = mysqli_query($conn, $sqlCart) or die("Couldn't execute query want count"); $cntWant = mysqli_num_rows($viewCnt); if ($cntWant == 1) { $sqlUpCart2 = "UPDATE tblMachinWantList SET HaveMint='1' WHERE CusNo='" . $mbrno . "' AND MachinId='" . $aMint[$i] . "'"; //echo "
" . $sqlUpCart2; $uresult = mysqli_query($conn, $sqlUpCart2) or die("Couldn't execute query update want list (mint)"); } else { // $sqlUpCart2 = "INSERT INTO tblMachinWantList ( CusNo, MachinId, HaveMint, HaveUsed, NeedIt, DateAdded, Comment ) $sqlUpCart2 = "INSERT INTO tblMachinWantList ( CusNo, MachinId, HaveMint, DateAdded ) VALUES ('$mbrno', '" . $aMint[$i] . "', '1', '$rightnow' )"; //echo "

" . $sqlUpCart2; $uresult = mysqli_query($conn, $sqlUpCart2) or die("Couldn't execute query insert want list (mint)"); } } } // end of Mint boxes // 2) Check Used checkboxes $aUsed = $_POST['used']; if(empty($aUsed)) { // echo("Nothing check in Used"); } else { $N = count($aUsed); // echo("You selected $N item(s): "); for($i=0; $i < $N; $i++) { // echo($aUsed[$i] . " "); if ($aUsed[$i] == 'on') { $used = 1; } else { $used = 0; } $sqlCart = "SELECT tblMachinWantList.* FROM tblMachinWantList WHERE CusNo='" . $mbrno . "' AND MachinId='" . $aUsed[$i] . "'"; $viewCnt = mysqli_query($conn, $sqlCart) or die("Couldn't execute query want count"); $cntWant = mysqli_num_rows($viewCnt); if ($cntWant == 1) { $sqlUpCart2 = "UPDATE tblMachinWantList SET HaveUsed='1' WHERE CusNo='" . $mbrno . "' AND MachinId='" . $aUsed[$i] . "'"; //echo "
" . $sqlUpCart2; $uresult = mysqli_query($conn, $sqlUpCart2) or die("Couldn't execute query update want list (used)"); } else { // $sqlUpCart2 = "INSERT INTO tblMachinWantList ( CusNo, MachinId, HaveMint, HaveUsed, NeedIt, DateAdded, Comment ) $sqlUpCart2 = "INSERT INTO tblMachinWantList ( CusNo, MachinId, HaveUsed, DateAdded ) VALUES ('$mbrno', '" . $aUsed[$i] . "', '1', '$rightnow' )"; //echo "

" . $sqlUpCart2; $uresult = mysqli_query($conn, $sqlUpCart2) or die("Couldn't execute query insert want list (used)"); } } } // end of Used boxes // 3) Check Want/need checkboxes $aWant = $_POST['want']; if(empty($aWant)) { // echo("Nothing check in Want"); } else { $N = count($aWant); // echo("You selected $N item(s): "); for($i=0; $i < $N; $i++) { // echo($aWant[$i] . " "); if ($aWant[$i] == 'on') { $want = 1; } else { $want = 0; } $sqlCart = "SELECT tblMachinWantList.* FROM tblMachinWantList WHERE CusNo='" . $mbrno . "' AND MachinId='" . $aWant[$i] . "'"; $viewCnt = mysqli_query($conn, $sqlCart) or die("Couldn't execute query want count"); $cntWant = mysqli_num_rows($viewCnt); if ($cntWant == 1) { $sqlUpCart2 = "UPDATE tblMachinWantList SET NeedIt='1' WHERE CusNo='" . $mbrno . "' AND MachinId='" . $aWant[$i] . "'"; //echo "
" . $sqlUpCart2; $uresult = mysqli_query($conn, $sqlUpCart2) or die("Couldn't execute query update want list (need)"); } else { // $sqlUpCart2 = "INSERT INTO tblMachinWantList ( CusNo, MachinId, HaveMint, HaveUsed, NeedIt, DateAdded, Comment ) $sqlUpCart2 = "INSERT INTO tblMachinWantList ( CusNo, MachinId, NeedIt, DateAdded ) VALUES ('$mbrno', '" . $aWant[$i] . "', '1', '$rightnow' )"; //echo "

" . $sqlUpCart2; $uresult = mysqli_query($conn, $sqlUpCart2) or die("Couldn't execute query insert want list (need)"); } } } // end of Want/need boxes } //// end of save checklist / wantlist //////// log view $Details = $_GET['Details']; if(isset($Details)) { $rightnow = date('Y-m-d H:i:s'); $viewSQL = "INSERT INTO tblMachinViews ( What , CusNo , ViewDate ) VALUES ('$Details', '$mbrid', '$rightnow' )"; // Feb 20/25 $appendresults = mysqli_query($conn, $viewSQL) or die("Couldn't execute query record item view"); } /////// if(isset($_SESSION['sql_limitMachin'])) { } else { $_SESSION['sql_limitMachin'] = 24; } $FindIt = 0; // 0 = initial load // 1 = Face search // 2 = Detail search // 3 = Favourites list // 4 = Want list // 10 = My account $pageNo = $_GET['ListPage']; // is user browsing page by page? if(isset($pageNo)) { $_SESSION['sql_pageMachin'] = $pageNo; $FindIt = $_GET['FindType']; } else { $_SESSION['sql_pageMachin'] = 1; } if(!isset($_SESSION['layout'])) { $_SESSION['layout'] = 'Grid'; } $HomePage = "Yes"; $MyAccount = $_GET['MyAccount']; if (isset($MyAccount)) { $FindIt = 10; $HomePage = "No"; $rightnow = date('Y-m-d H:i:s'); $viewSQL = "INSERT INTO tblMachinViews ( What , CusNo , ViewDate ) VALUES ('MyAccount', '$mbrid', '$rightnow' )"; // Feb 20/25 $appendresults = mysqli_query($conn, $viewSQL) or die("Couldn't execute query record item view"); } $Benefits = $_GET['Benefits']; if (isset($Benefits)) { $FindIt = 11; $HomePage = "No"; $rightnow = date('Y-m-d H:i:s'); $viewSQL = "INSERT INTO tblMachinViews ( What , CusNo , ViewDate ) VALUES ('Benefits', '$mbrid', '$rightnow' )"; // Feb 20/25 $appendresults = mysqli_query($conn, $viewSQL) or die("Couldn't execute query record item view"); } $Links = $_GET['Links']; if (isset($Links)) { $FindIt = 12; $HomePage = "No"; $rightnow = date('Y-m-d H:i:s'); $viewSQL = "INSERT INTO tblMachinViews ( What , CusNo , ViewDate ) VALUES ('Links', '$mbrid', '$rightnow' )"; // Feb 20/25 $appendresults = mysqli_query($conn, $viewSQL) or die("Couldn't execute query record item view"); } $FAQ = $_GET['FAQ']; if (isset($FAQ)) { $FindIt = 13; $HomePage = "No"; $rightnow = date('Y-m-d H:i:s'); $viewSQL = "INSERT INTO tblMachinViews ( What , CusNo , ViewDate ) VALUES ('FAQ', '$mbrid', '$rightnow' )"; // Feb 20/25 $appendresults = mysqli_query($conn, $viewSQL) or die("Couldn't execute query record item view"); $appendresults = mysqli_query($conn, $viewSQL); } $BackPrint = $_GET['BackPrint']; if (isset($BackPrint)) { $FindIt = 14; $HomePage = "No"; $rightnow = date('Y-m-d H:i:s'); $viewSQL = "INSERT INTO tblMachinViews ( What , CusNo , ViewDate ) VALUES ('BackPrint', '$mbrid', '$rightnow' )"; // Feb 20/25 $appendresults = mysqli_query($conn, $viewSQL) or die("Couldn't execute query record item view"); } $Imperf = $_GET['Imperf']; if (isset($Imperf)) { $FindIt = 15; $HomePage = "No"; $rightnow = date('Y-m-d H:i:s'); $viewSQL = "INSERT INTO tblMachinViews ( What , CusNo , ViewDate ) VALUES ('Imperf', '$mbrid', '$rightnow' )"; // Feb 20/25 $appendresults = mysqli_query($conn, $viewSQL) or die("Couldn't execute query record item view"); } $PhosphorBars = $_GET['PhosphorBars']; if (isset($PhosphorBars)) { $FindIt = 16; $HomePage = "No"; $rightnow = date('Y-m-d H:i:s'); $viewSQL = "INSERT INTO tblMachinViews ( What , CusNo , ViewDate ) VALUES ('PhosphorBars', '$mbrid', '$rightnow' )"; // Feb 20/25 $appendresults = mysqli_query($conn, $viewSQL) or die("Couldn't execute query record item view"); } $HeadSymbol = $_GET['HeadSymbol']; if (isset($HeadSymbol)) { $FindIt = 17; $HomePage = "No"; $rightnow = date('Y-m-d H:i:s'); $viewSQL = "INSERT INTO tblMachinViews ( What , CusNo , ViewDate ) VALUES ('HeadSymbol', '$mbrid', '$rightnow' )"; // Feb 20/25 $appendresults = mysqli_query($conn, $viewSQL) or die("Couldn't execute query record item view"); } $Deegam = $_GET['Deegam']; if (isset($Deegam)) { $FindIt = 18; $HomePage = "No"; $rightnow = date('Y-m-d H:i:s'); $viewSQL = "INSERT INTO tblMachinViews ( What , CusNo , ViewDate ) VALUES ('Deegam', '$mbrid', '$rightnow' )"; // Feb 20/25 $appendresults = mysqli_query($conn, $viewSQL) or die("Couldn't execute query record item view"); } $Simply101 = $_GET['Simply101']; if (isset($Simply101)) { $FindIt = 19; $HomePage = "No"; $rightnow = date('Y-m-d H:i:s'); $viewSQL = "INSERT INTO tblMachinViews ( What , CusNo , ViewDate ) VALUES ('Simplify', '$mbrid', '$rightnow' )"; // Feb 20/25 $appendresults = mysqli_query($conn, $viewSQL) or die("Couldn't execute query record item view"); } $Album = $_GET['Album']; if (isset($Album)) { $FindIt = 20; $HomePage = "No"; $rightnow = date('Y-m-d H:i:s'); $viewSQL = "INSERT INTO tblMachinViews ( What , CusNo , ViewDate ) VALUES ('Album', '$mbrid', '$rightnow' )"; // Feb 20/25 $appendresults = mysqli_query($conn, $viewSQL) or die("Couldn't execute query record item view"); } $Ref_Varieties = $_GET['Ref_Varieties']; if (isset($Ref_Varieties)) { $FindIt = 21; $HomePage = "No"; $rightnow = date('Y-m-d H:i:s'); $viewSQL = "INSERT INTO tblMachinViews ( What , CusNo , ViewDate ) VALUES ('Ref_Varieties', '$mbrid', '$rightnow' )"; // Feb 20/25 $appendresults = mysqli_query($conn, $viewSQL) or die("Couldn't execute query record item view"); } $Ref_Terms = $_GET['Ref_Terms']; if (isset($Ref_Terms)) { $FindIt = 22; $HomePage = "No"; $rightnow = date('Y-m-d H:i:s'); $viewSQL = "INSERT INTO tblMachinViews ( What , CusNo , ViewDate ) VALUES ('Ref_Terms', '$mbrid', '$rightnow' )"; // Feb 20/25 $appendresults = mysqli_query($conn, $viewSQL) or die("Couldn't execute query record item view"); } $Ref_Timeline = $_GET['Ref_Timeline']; if (isset($Ref_Timeline)) { $FindIt = 23; $HomePage = "No"; $rightnow = date('Y-m-d H:i:s'); $viewSQL = "INSERT INTO tblMachinViews ( What , CusNo , ViewDate ) VALUES ('Ref_Timeline', '$mbrid', '$rightnow' )"; // Feb 20/25 $appendresults = mysqli_query($conn, $viewSQL) or die("Couldn't execute query record item view"); } $Ref_Rates = $_GET['Ref_Rates']; if (isset($Ref_Rates)) { $FindIt = 24; $HomePage = "No"; $rightnow = date('Y-m-d H:i:s'); $viewSQL = "INSERT INTO tblMachinViews ( What , CusNo , ViewDate ) VALUES ('Ref_Rates', '$mbrid', '$rightnow' )"; // Feb 20/25 $appendresults = mysqli_query($conn, $viewSQL) or die("Couldn't execute query record item view"); } $Intro = $_GET['Intro']; if (isset($Intro)) { $FindIt = 25; $HomePage = "No"; $rightnow = date('Y-m-d H:i:s'); $viewSQL = "INSERT INTO tblMachinViews ( What , CusNo , ViewDate ) VALUES ('Intro', '$mbrid', '$rightnow' )"; // Feb 20/25 $appendresults = mysqli_query($conn, $viewSQL) or die("Couldn't execute query record item view"); } $About = $_GET['About']; if (isset($About)) { $FindIt = 26; $HomePage = "No"; $rightnow = date('Y-m-d H:i:s'); $viewSQL = "INSERT INTO tblMachinViews ( What , CusNo , ViewDate ) VALUES ('About', '$mbrid', '$rightnow' )"; // Feb 20/25 $appendresults = mysqli_query($conn, $viewSQL) or die("Couldn't execute query record item view"); } $LoginMenu = $_GET['LoginMenu']; if (isset($LoginMenu)) { $FindIt = 27; $HomePage = "No"; } $Ref_RatesFletcher = $_GET['Ref_RatesFletcher']; if (isset($Ref_RatesFletcher)) { $FindIt = 28; $HomePage = "No"; $rightnow = date('Y-m-d H:i:s'); $viewSQL = "INSERT INTO tblMachinViews ( What , CusNo , ViewDate ) VALUES ('Ref_RatesFletcher', '$mbrid', '$rightnow' )"; // Feb 20/25 $appendresults = mysqli_query($conn, $viewSQL) or die("Couldn't execute query record item view"); } $AlbumUpgrade = $_GET['AlbumUpgrade']; if (isset($AlbumUpgrade)) { $FindIt = 29; $HomePage = "No"; } // Quick year $QuickYear = $_GET['QuickYear']; if (isset($QuickYear)) { $FindIt = 2000; $HomePage = "No"; $who = "Quick Year - " . $QuickYear; $rightnow = date('Y-m-d H:i:s'); $viewSQL = "INSERT INTO tblMachinViews ( What , CusNo , ViewDate ) VALUES ('$who', '$mbrid', '$rightnow' )"; // Feb 20/25 $appendresults = mysqli_query($conn, $viewSQL) or die("Couldn't execute query record item view"); } // end of Quick Year // Quick list $Quick = $_GET['Quick']; if (isset($Quick)) { $_SESSION['QuickWho'] = $_GET['Who']; $_SESSION['QuickWhoName'] = "test"; $QuickImage = "image name"; $Qsql = "SELECT DesignNo, Face, Currency, Colour, Feature FROM tblMachinFace "; $QsqlCnt = "SELECT DesignNo FROM tblMachinFace "; switch ($_SESSION['QuickWho']) { case 1: $_SESSION['QuickWhoName'] = "Pre-Decimal"; $strCriteria .= " And (tblMachinFace.Feature = 'Pre-Decimal')"; $QuickImage = "md0005z.jpg"; break; case 2: $_SESSION['QuickWhoName'] = "Decimal"; $strCriteria .= " And (tblMachinFace.Feature <> 'Pre-Decimal')"; $QuickImage = "m010tz.jpg"; break; case 3: $_SESSION['QuickWhoName'] = "Anniversary"; $strCriteria .= " And (tblMachinFace.Feature Like '%Anniversary%')"; $QuickImage = "mann29z.jpg"; break; case 10: $_SESSION['QuickWhoName'] = "Data Matrix"; $strCriteria .= " And (tblMachinFace.Feature = 'Data Matrix Code')"; $QuickImage = "m200-DMCz-.jpg"; break; case 4: $_SESSION['QuickWhoName'] = "NVI"; $strCriteria .= " And (tblMachinFace.Feature Like '%NVI%' OR tblMachinFace.Feature Like '%PIP%' OR tblMachinFace.Feature = 'BarCode')"; $QuickImage = "m1nvi-R2z.jpg"; break; case 5: $_SESSION['QuickWhoName'] = "Northern Ireland"; $strCriteria .= " And (tblMachinFace.VarNorthern='1')"; $QuickImage = "/ni/mn012gz.jpg"; break; case 6: $_SESSION['QuickWhoName'] = "Scotland"; $strCriteria .= " And (tblMachinFace.VarScotland='1')"; $QuickImage = "/scot/ms026rz.jpg"; break; case 7: $_SESSION['QuickWhoName'] = "Wales"; $strCriteria .= " And (tblMachinFace.VarWales='1')"; $QuickImage = "/wale/mw030z.jpg"; break; case 8: $_SESSION['QuickWhoName'] = "Isle of Man"; $strCriteria .= " And (tblMachinFace.VarIsle='1')"; $QuickImage = "/isle/mi0025z.jpg"; break; case 9: $_SESSION['QuickWhoName'] = "Miscellaneous"; $strCriteria .= " And (tblMachinFace.Feature = 'Service Inscribed' OR tblMachinFace.Feature = 'Airmail' OR tblMachinFace.Feature = 'BarCode')"; $QuickImage = "air-eur2z-.jpg"; break; } If (strlen($strCriteria) > 3) { $strCriteria = substr($strCriteria, 5, strlen($strCriteria) - 5); $Qsql .= " WHERE (" . $strCriteria . ")"; $QsqlCnt .= " WHERE (" . $strCriteria . ")"; } $strOrder = " ORDER BY Feature, DesignNo"; $Qsql .= $strOrder; $FindIt = 1000; $HomePage = "No"; $who = "Quick List - " . $_SESSION['QuickWhoName']; $rightnow = date('Y-m-d H:i:s'); $viewSQL = "INSERT INTO tblMachinViews ( What , CusNo , ViewDate ) VALUES ('$who', '$mbrid', '$rightnow' )"; // Feb 20/25 $appendresults = mysqli_query($conn, $viewSQL) or die("Couldn't execute query record item view"); } // end of Quick List $ShowFavs = $_GET['ShowFavourites']; if ((isset($ShowFavs)) && ($login == "Yes")) { $_SESSION['defReg'] = 0; $showRegionalOnly = 0; $FindIt = 1; $HomePage = "No"; // $sql = "SELECT tblMachinFace.* FROM tblMachinFace WHERE DesignNo = 53 ORDER BY FirstSeen, DesignNo"; $sql = "SELECT tblMachinFace.* FROM tblMachinFace INNER JOIN tblMachinFavourites ON tblMachinFace.DesignNo = tblMachinFavourites.MachinId WHERE (((tblMachinFavourites.CusNo)=" . $mbrid . ")) ORDER BY FirstSeen, DesignNo"; // $sqlCnt = "SELECT tblMachinFace.FaceUnique FROM tblMachinFace WHERE DesignNo = 53 "; $sqlCnt = "SELECT tblMachinFace.FaceUnique FROM tblMachinFace INNER JOIN tblMachinFavourites ON tblMachinFace.DesignNo = tblMachinFavourites.MachinId WHERE (((tblMachinFavourites.CusNo)=" . $mbrid . "))"; $strFind = "My Favourites"; $_SESSION['sql_stampsM'] = $sql; $_SESSION['sql_stamps_countM'] = $sqlCnt; $_SESSION['sql_findM'] = $strFind; } $ShowWants = $_GET['ShowWants']; if ((isset($ShowWants)) && ($login == "Yes")) { $_SESSION['defReg'] = 0; $showRegionalOnly = 0; $FindIt = 2; $HomePage = "No"; $sql = "SELECT tblMachinFace.*, tblMachins.*, tblMachinWantList.HaveMint, tblMachinWantList.HaveUsed, tblMachinWantList.NeedIt, tblMachinWantList.DateAdded, tblMachinWantList.Comment, tblMachinWantList.WantId FROM (tblMachinFace LEFT JOIN tblMachins ON tblMachinFace.DesignNo = tblMachins.DesignNo) LEFT JOIN tblMachinWantList ON tblMachins.Adminware = tblMachinWantList.MachinId WHERE (((tblMachinWantList.CusNo)=" . $mbrid . ") AND (tblMachinWantList.NeedIt=1)) ORDER BY tblMachinFace.DesignNo, Sequence, Bars, Paper, IssueDate"; $sqlCnt = "SELECT tblMachinFace.FaceUnique, tblMachins.Adminware, tblMachinWantList.WantId FROM (tblMachinFace LEFT JOIN tblMachins ON tblMachinFace.DesignNo = tblMachins.DesignNo) LEFT JOIN tblMachinWantList ON tblMachins.Adminware = tblMachinWantList.MachinId WHERE (((tblMachinWantList.CusNo)=" . $mbrid . "))"; $strFind = "My Want List"; $_SESSION['sql_stampsM'] = $sql; $_SESSION['sql_stamps_countM'] = $sqlCnt; $_SESSION['sql_findM'] = $strFind; } $ShowPanes = $_GET['ShowPanes']; if ((isset($ShowPanes)) && ($login == "Yes")) { $FindIt = 100; } $RecentAdditions = $_GET['RecentAdditions']; if (isset($RecentAdditions)) { $_SESSION['defReg'] = 0; $showRegionalOnly = 0; $FindIt = 2; $HomePage = "No"; $sql = "SELECT tblMachins.* FROM tblMachins WHERE LEFT(DateAdded, 4) <> '0000' ORDER BY DateAdded DESC, DesignNo"; $sqlCnt = "SELECT tblMachins.DesignNo FROM tblMachins WHERE LEFT(DateAdded, 4) <> '0000'"; $strFind = "Recent additions"; $_SESSION['sql_stampsM'] = $sql; $_SESSION['sql_stamps_countM'] = $sqlCnt; $_SESSION['sql_findM'] = $strFind; $rightnow = date('Y-m-d H:i:s'); $viewSQL = "INSERT INTO tblMachinViews ( What , CusNo , ViewDate ) VALUES ('Recent additions', '$mbrid', '$rightnow' )"; // Feb 20/25 $appendresults = mysqli_query($conn, $viewSQL) or die("Couldn't execute query record item view"); } //$sql = "SELECT tblMachinFace.* FROM tblMachinFace ORDER BY FirstSeen, DesignNo"; //$sqlCnt = "SELECT tblMachinFace.MachinUnique FROM tblMachinFace "; $showRegionalOnly = 0; // has regional list-only been selected? // FACE searching $FindMachins = $_GET['FindMachins']; if(isset($FindMachins)) { $strFind = ""; $sql = "SELECT tblMachinFace.* FROM tblMachinFace "; // $sqlCnt = "SELECT tblMachinFace.MachinUnique FROM tblMachinFace "; $sqlCnt = "SELECT tblMachinFace.* FROM tblMachinFace "; $_SESSION['defReg'] = 0; if ($_POST['fWho'] == "Pre") { $strCriteria .= " And (tblMachinFace.Feature = 'Pre-Decimal')"; $strFind .= " | Pre-decimal" ; $_SESSION['defReg'] = 1; } if ($_POST['fWho'] == "Dec") { $strCriteria .= " And (tblMachinFace.Feature <> 'Pre-Decimal')"; $strFind .= " | Decimal" ; $_SESSION['defReg'] = 2; } if ($_POST['fWho'] == "Ann") { $strCriteria .= " And (tblMachinFace.Feature Like '%Anniversary%')"; $strFind .= " | Anniversary" ; $_SESSION['defReg'] = 3; } if ($_POST['fWho'] == "NVI") { $strCriteria .= " And (tblMachinFace.Feature Like '%NVI%' OR tblMachinFace.Feature Like '%PIP%' OR tblMachinFace.Feature = 'Data Matrix Code')"; $strFind .= " | Non-value Indicated" ; $_SESSION['defReg'] = 4; } if ($_POST['fWho'] == "DMC") { $strCriteria .= " And (tblMachinFace.Feature = 'Data Matrix Code')"; $strFind .= " | Data Matrix Code" ; $_SESSION['defReg'] = 10; } if ($_POST['fWho'] == "NI") { $strCriteria .= " And (tblMachinFace.VarNorthern='1')"; $strFind .= " | Northern Ireland" ; $_SESSION['defReg'] = 5; $showRegionalOnly = 1; } if ($_POST['fWho'] == "Scot") { $strCriteria .= " And (tblMachinFace.VarScotland='1')"; $strFind .= " | Scotland" ; $_SESSION['defReg'] = 6; $showRegionalOnly = 2; } if ($_POST['fWho'] == "Wale") { $strCriteria .= " And (tblMachinFace.VarWales='1')"; $strFind .= " | Wales" ; $_SESSION['defReg'] = 7; $showRegionalOnly = 3; } if ($_POST['fWho'] == "Isle") { $strCriteria .= " And (tblMachinFace.VarIsle='1')"; $strFind .= " | Isle of Man" ; $_SESSION['defReg'] = 8; $showRegionalOnly = 4; } if ($_POST['fWho'] == "Misc") { $strCriteria .= " And (tblMachinFace.Feature = 'Service Inscribed' OR tblMachinFace.Feature = 'Airmail')"; $strFind .= " | Miscellaneous" ; $_SESSION['defReg'] = 9; } $_SESSION['defFace'] = ""; if (isset($_POST['fFaceValue'])) { if (strlen($_POST['fFaceValue']) > 0) { $strCriteria .= " And (tblMachinFace.Face Like '%" . $_POST['fFaceValue'] . "%')"; $strFind .= " | Face value = " . $_POST['fFaceValue'] ; $_SESSION['defFace'] = $_POST['fFaceValue']; } } $_SESSION['defYear'] = ""; if (isset($_POST['fYear'])) { $strCriteria .= " And (tblMachinFace.FirstSeen Like '%" . $_POST['fYear'] . "%')"; $strFind .= " | Year of issue = " . $_POST['fYear'] ; $_SESSION['defYear'] = $_POST['fYear']; } $_SESSION['defHue'] = ""; if (isset($_POST['fHue'])) { $strCriteria .= " And (tblMachinFace.Hue = '" . $_POST['fHue'] . "')"; $strFind .= " | Hue = " . $_POST['fHue'] ; $_SESSION['defHue'] = $_POST['fHue']; } If (strlen($strCriteria) > 3) { $strCriteria = substr($strCriteria, 5, strlen($strCriteria) - 5); $sql .= " WHERE (" . $strCriteria . ")"; $sqlCnt .= " WHERE (" . $strCriteria . ")"; } If (strlen($strFind) > 3) { $strFind = substr($strFind, 3, strlen($strFind) - 3); } if ($_POST['sSort'] == "Date") { $strOrder = " ORDER BY FirstSeen, DesignNo "; // $strSort = "Sort by Date of issue" ; $_SESSION['defSort'] = 1; } if ($_POST['sSort'] == "Design") { $strOrder = " ORDER BY DesignNo"; // $strSort = "Sort by Design" ; $_SESSION['defSort'] = 2; } $sql .= $strOrder; //echo "here 1: " . $sql . "

"; $FindIt = 1; } else { // DETAIL searching $FindDetails = $_GET['FindDetails']; if(isset($FindDetails)) { $_SESSION['defReg'] = 0; $showRegionalOnly = 0; $strFind = ""; $sql = "SELECT tblMachins.DesignNo, tblMachins.Country, tblMachins.Face, tblMachins.Currency, tblMachins.Colour, Format, Bars, Paper, PtgMethod, Printer, tblMachins.IssueDate AS FirstSeen, tblMachins.PicName1 AS PicName, MachinUnique, Adminware FROM tblMachins "; $sqlCnt = "SELECT tblMachins.* FROM tblMachins "; $_SESSION['defYearDet'] = ""; if (isset($_POST['fdetailYear'])) { $strCriteria .= " And (tblMachins.IssueDate Like '%" . $_POST['fdetailYear'] . "%')"; $strFind .= " | Year of issue = " . $_POST['fdetailYear'] ; $_SESSION['defYearDet'] = $_POST['fdetailYear']; } $_SESSION['defPtr'] = ""; if (strlen($_POST['fdetailPrinter']) > 0) { $strCriteria .= " And (tblMachins.Printer = '" . $_POST['fdetailPrinter'] . "')"; $strFind .= " | Printer = " . $_POST['fdetailPrinter'] ; $_SESSION['defPtr'] = $_POST['fdetailPrinter']; } $_SESSION['defSource'] = ""; if (strlen($_POST['fdetailFormat']) > 0) { $strCriteria .= " And (tblMachins.Format = '" . $_POST['fdetailFormat'] . "')"; $strFind .= " | Format/source = " . $_POST['fdetailFormat'] ; $_SESSION['defSource'] = $_POST['fdetailFormat']; } $_SESSION['defMethod'] = ""; if (strlen($_POST['fdetailPtgMethod']) > 0) { $strCriteria .= " And (tblMachins.PtgMethod = '" . $_POST['fdetailPtgMethod'] . "')"; $strFind .= " | Printing method = " . $_POST['fdetailPtgMethod'] ; $_SESSION['defMethod'] = $_POST['fdetailPtgMethod']; } $_SESSION['defBars'] = ""; if (strlen($_POST['fdetailBars']) > 0) { $strCriteria .= " And (tblMachins.Bars = '" . $_POST['fdetailBars'] . "')"; $strFind .= " | Phosphor bars = " . $_POST['fdetailBars'] ; $_SESSION['defBars'] = $_POST['fdetailBars']; } $_SESSION['defPaper'] = ""; if (strlen($_POST['fdetailPaper']) > 0) { $strCriteria .= " And (tblMachins.Paper = '" . $_POST['fdetailPaper'] . "')"; $strFind .= " | Paper = " . $_POST['fdetailPaper'] ; $_SESSION['defPaper'] = $_POST['fdetailPaper']; } /////////////// $_SESSION['defGum'] = 0; if ($_POST['sGum'] == "Water") { $strCriteria .= " And (tblMachins.SelfAd = '0')"; $strFind .= " | Water-activated gum" ; $_SESSION['defGum'] = 1; } if ($_POST['sGum'] == "SA") { $strCriteria .= " And (tblMachins.SelfAd = 1)"; $strFind .= " | Self-adhesive" ; $_SESSION['defGum'] = 2; } If (strlen($strCriteria) > 3) { $strCriteria = substr($strCriteria, 5, strlen($strCriteria) - 5); $sql .= " WHERE (" . $strCriteria . ")"; $sqlCnt .= " WHERE (" . $strCriteria . ")"; } If (strlen($strFind) > 3) { $strFind = substr($strFind, 3, strlen($strFind) - 3); } if ($_POST['sSort'] == "Date") { $strOrder = " ORDER BY tblMachins.IssueDate, tblMachins.DesignNo "; // $strSort = "Sort by Date of issue" ; $_SESSION['defSortDet'] = 1; } if ($_POST['sSort'] == "Design") { $strOrder = " ORDER BY tblMachins.DesignNo"; // $strSort = "Sort by Design" ; $_SESSION['defSortDet'] = 2; } $sql .= $strOrder; $FindIt = 2; } else { $sql = $_SESSION['sql_stampsM']; $sqlCnt = $_SESSION['sql_stamps_countM']; $strFind = $_SESSION['sql_findM']; } } $_SESSION['sql_stampsM'] = $sql; $_SESSION['sql_stamps_countM'] = $sqlCnt; $_SESSION['sql_findM'] = $strFind; ?>

 

 

 

"; if ($Details > 1) { $sqlPrev = "SELECT Face, Currency, Colour FROM tblMachinFace WHERE DesignNo=" . ($Details-1) . ";"; $prevList = mysqli_query($conn, $sqlPrev) or die("Couldn't execute query prev item"); $prevrow=mysqli_fetch_array($prevList); echo "

Previous"; echo "
" . getFace($prevrow["Face"], $prevrow["Currency"]) . " " . $prevrow["Colour"]; echo "

"; } // watch for 'last' item in Face table; if so, then disable 'Next' button $sqlMax = "SELECT Max(FaceUnique) AS LastItem FROM tblMachinFace;"; $maxList = mysqli_query($conn, $sqlMax) or die("Couldn't execute query max list"); $row=mysqli_fetch_array($maxList); if ($Details < $row["LastItem"] ) { $sqlPrev = "SELECT Face, Currency, Colour FROM tblMachinFace WHERE DesignNo=" . ($Details+1) . ";"; $prevList = mysqli_query($conn, $sqlPrev) or die("Couldn't execute query next item"); $prevrow=mysqli_fetch_array($prevList); echo "

Next"; echo "
" . getFace($prevrow["Face"], $prevrow["Currency"]) . " " . $prevrow["Colour"]; echo "

"; } echo ""; } // if ($_SESSION['MemberLevel'] == 4) // { echo "

"; echo "Quick list... "; echo "

"; echo "
• Pre-Decimal
"; echo "
• Decimal
"; echo "
• Anniversary
"; echo "
• NVI
"; echo "
• Data Matrix Code
"; echo "
• Miscellaneous
"; echo "
"; echo "
• Isle of Man
"; echo "
• Northern Ireland
"; echo "
• Scotland
"; echo "
• Wales
"; echo "
"; $thisyear = substr(date('Y-m-d'), 0, 4); echo "
• " . $thisyear . " issues
"; echo "
• " . ($thisyear-1) . " issues
"; echo "
• " . ($thisyear-2) . " issues
"; echo "
• " . ($thisyear-3) . " issues
"; echo "

"; echo "

"; echo "

 "; // } echo "Recent additions

"; echo "

"; echo "

Find

"; echo "

"; echo "

"; ?>

> Pre-Decimal

> Decimal

> Anniversary

> NVI

> Data Matrix Code

> Northern Ireland

> Scotland

> Wales

> Isle of Man

> Other

> All

---

"; echo ""; echo "

"; // YEAR OF ISSUE echo "

"; echo ""; echo ""; $sqlYear = "SELECT DISTINCT Left(FirstSeen,4) AS YearOfIssue FROM tblMachinFace WHERE ( (LENGTH(FirstSeen)) > 1) ORDER BY FirstSeen;"; $yearList = mysqli_query($conn, $sqlYear) or die("Couldn't execute query year list"); echo "Face Year of issue"; while($yearrow = mysqli_fetch_array($yearList)) { // echo "" . $yearrow["YearOfIssue"] . ""; if($yearrow["YearOfIssue"] == $_SESSION['defYear']) { echo "$yearrow[YearOfIssue]"; }else { echo "" . $yearrow["YearOfIssue"] . ""; } } echo ""; echo "

"; // HUE echo "

"; echo ""; echo ""; $sqlYear = "SELECT DISTINCT Hue FROM tblMachinFace WHERE ( (LENGTH(Hue)) > 1) ORDER BY Hue;"; $yearList = mysqli_query($conn, $sqlYear) or die("Couldn't execute query hue list"); echo "Hue (colour)"; while($yearrow = mysqli_fetch_array($yearList)) { // echo "" . $yearrow["Hue"] . ""; if($yearrow["Hue"] == $_SESSION['defHue']) { echo "$yearrow[Hue]"; }else { echo "" . $yearrow["Hue"] . ""; } } echo ""; echo "

"; ?>

Sort:

checked> Date of issue

> Design

   Find   

My Favourites"; if ($TotFavs > 0) { echo " (" . $TotFavs . ")"; } echo ""; echo "

 "; $TotWants = 0; echo "Want List"; if ($TotWants > 0) { echo " (" . $TotWants . ")"; } echo ""; ////// //echo "Want List"; ?>

Detail Find

"; } // YEAR OF ISSUE echo "

"; echo ""; echo ""; $sqlYear = "SELECT DISTINCT Left(IssueDate,4) AS YearOfIssue FROM tblMachins WHERE ( (LENGTH(IssueDate)) > 1) ORDER BY IssueDate;"; $yearList = mysqli_query($conn, $sqlYear) or die("Couldn't execute query detail year list"); echo "Detail Year of issue"; while($yearrow = mysqli_fetch_array($yearList)) { // echo "" . $yearrow["YearOfIssue"] . ""; if($yearrow["YearOfIssue"] == $_SESSION['defYearDet']) { echo "$yearrow[YearOfIssue]"; }else { echo "" . $yearrow["YearOfIssue"] . ""; } } echo ""; echo "

"; // PRINTER echo "

"; echo ""; echo ""; $sqlPtr = "SELECT DISTINCT Printer FROM tblMachins WHERE ( (LENGTH(Printer)) > 1) ORDER BY Printer;"; $ptrList = mysqli_query($conn, $sqlPtr) or die("Couldn't execute query printer list"); echo "Printer"; while($ptrrow = mysqli_fetch_array($ptrList)) { // echo "" . $ptrrow["Printer"] . ""; if($ptrrow["Printer"] == $_SESSION['defPtr']) { echo "$ptrrow[Printer]"; }else { echo "" . $ptrrow["Printer"] . ""; } } echo ""; echo "

"; // FORMAT echo "

"; echo ""; echo ""; $sqlPtr = "SELECT DISTINCT Format FROM tblMachins WHERE ( (LENGTH(Format)) > 1) ORDER BY Format;"; $ptrList = mysqli_query($conn, $sqlPtr) or die("Couldn't execute query Format list"); echo "Format/source"; while($ptrrow = mysqli_fetch_array($ptrList)) { // echo "" . $ptrrow["Format"] . ""; if($ptrrow["Format"] == $_SESSION['defSource']) { echo "$ptrrow[Format]"; }else { echo "" . $ptrrow["Format"] . ""; } } echo ""; echo "

"; // Printing method echo "

"; echo ""; echo ""; $sqlPtr = "SELECT DISTINCT PtgMethod FROM tblMachins WHERE ( (LENGTH(PtgMethod)) > 1) ORDER BY Bars;"; $ptrList = mysqli_query($conn, $sqlPtr) or die("Couldn't execute query PtgMethod list"); echo "Printing method"; while($ptrrow = mysqli_fetch_array($ptrList)) { // echo "" . $ptrrow["PtgMethod"] . ""; if($ptrrow["PtgMethod"] == $_SESSION['defMethod']) { echo "$ptrrow[PtgMethod]"; }else { echo "" . $ptrrow["PtgMethod"] . ""; } } echo ""; echo "

"; // BARS echo "

"; echo ""; echo ""; $sqlPtr = "SELECT DISTINCT Bars FROM tblMachins WHERE ( (LENGTH(Bars)) > 1) ORDER BY Bars;"; $ptrList = mysqli_query($conn, $sqlPtr) or die("Couldn't execute query Bars list"); echo "Phosphor Bars"; while($ptrrow = mysqli_fetch_array($ptrList)) { // echo "" . $ptrrow["Bars"] . ""; if($ptrrow["Bars"] == $_SESSION['defBars']) { echo "$ptrrow[Bars]"; }else { echo "" . $ptrrow["Bars"] . ""; } } echo ""; echo "

"; // Paper echo "

"; echo ""; echo ""; $sqlPtr = "SELECT DISTINCT Paper FROM tblMachins WHERE ( (LENGTH(Paper)) > 1) ORDER BY Paper;"; $ptrList = mysqli_query($conn, $sqlPtr) or die("Couldn't execute query Paper list"); echo "Paper"; while($ptrrow = mysqli_fetch_array($ptrList)) { // echo "" . $ptrrow["Bars"] . ""; if($ptrrow["Paper"] == $_SESSION['defPaper']) { echo "$ptrrow[Paper]"; }else { echo "" . $ptrrow["Paper"] . ""; } } echo ""; echo "

"; ?>

Gum:

> Water-activated

> Self-adhesive

> All

---

Sort:

> Date of issue

> Design

"; echo "   Find   "; echo ""; echo ""; echo "

"; echo "

"; // // Jan 10/22 ... for now, only show if ME if ($_SESSION['mbrid'] == 1) { echo "Panes"; echo ""; } echo "
"; echo "

"; $sqlSummaryCnt = "SELECT tblMachinFace.FaceUnique FROM tblMachinFace"; $viewCnt = mysqli_query($conn, $sqlSummaryCnt) or die("Couldn't execute query face count"); $cntFace = mysqli_num_rows($viewCnt); echo "

Face different: " . $cntFace . " ¹"; $sqlSummaryDetail = "SELECT tblMachins.MachinUnique FROM tblMachins"; $viewCnt = mysqli_query($conn, $sqlSummaryDetail) or die("Couldn't execute query detail count"); $cnt = mysqli_num_rows($viewCnt); echo "
Detail entries: " . $cnt . " ²"; $sqlSummaryDetail = "SELECT tblMachins.MachinUnique FROM tblMachins WHERE Length(PicName1) > 0"; $viewCnt = mysqli_query($conn, $sqlSummaryDetail) or die("Couldn't execute query image count"); $cnt = mysqli_num_rows($viewCnt); echo "
Detail images: " . $cnt . " ³"; echo "

---

"; echo "¹ plus 188 regionals
"; echo "² plus cut, SBP (± 1000)
"; echo "³ plus SBP, panes (±425)
"; ?>

 

Like this site?

"; } ?>