''){ echo "

'Other' Constructional and Allied Systems Info & Downloads

"; } else { echo "

'Other' Constructional and Allied Systems Forum

"; } if ($gpage <>''){ $zc = 1; $queryZC = $pdo->query("SELECT DISTINCT Country from Otherhits ORDER BY Country ASC"); while ($rowZC = $queryZC->fetch()) { $tcountry = $rowZC['Country']; if ($tcountry <> ''){ $country[$zc] = $tcountry; ++$zc; } } $p1 = 1; //Find Country choice $countrysel[0] = ''; $tscountry = 0; if (isset ($_POST['Country'])){ $tscountry = $_POST['Country']; $countrysel[$tscountry] = "selected"; }else if (isset ($_GET['Country'])){ $tscountry = $_GET['Country']; $countrysel[$tscountry] = "selected"; } else { $countrysel[0] = "selected"; } $scountry = ''; if ($tscountry > 0) { $scountry = $country[$tscountry]; } //Find Systype choice $systypesel[A] = ''; $systype = 'A'; if (isset ($_POST['Systype'])){ $systype = $_POST['Systype']; $systypesel[$systype] = "selected"; }else if (isset ($_GET['Systype'])){ $systype = $_GET['Systype']; $systypesel[$systype] = "selected"; } else { $systypesel[A] = "selected"; } //Find Sysfind text $Sysfind = ''; $Sysfindt = ''; if (isset ($_POST['Sysfind'])){ $Sysfindt = $_POST['Sysfind']; }else if (isset ($_GET['Sysfind'])){ $Sysfindt = $_GET['Sysfind']; } if ($Sysfindt <> ''){ $Sysfind = str_replace(str_split('\\/:*?"<>|+-'), '', $Sysfindt); $SSearch = "(Pdesc LIKE '%".$Sysfind."%' OR Pdesc2 LIKE '%".$Sysfind."%') AND"; } if ($scountry == ''){ if ($systype == 'A'){ $queryS1 = $pdo->query("SELECT Pdesc, Pdesc2, Pdesc3, Pdesc4, Pdesc5, Pdesc6 from Otherhits WHERE $SSearch Forder > 0"); } else if (strlen($systype) == 2){ $queryS1 = $pdo->prepare("SELECT Pdesc, Pdesc2, Pdesc3, Pdesc4, Pdesc5, Pdesc6 from Otherhits WHERE (Stype = ? OR Stype2 = ?) AND Forder > 0"); $queryS1->execute([$systype, $systype]); } else if ($systype == 'M'){ $queryS1 = $pdo->query("SELECT Pdesc, Pdesc2, Pdesc3, Pdesc4, Pdesc5, Pdesc6 from Otherhits WHERE Page NOT LIKE 'O-%' AND Forder > 0"); } else if ($systype == 'N'){ $queryS1 = $pdo->query("SELECT Pdesc, Pdesc2, Pdesc3, Pdesc4, Pdesc5, Pdesc6 from Otherhits WHERE Mtype <> '' AND Forder > 0"); } else { $queryS1 = $pdo->prepare("SELECT Pdesc, Pdesc2, Pdesc3, Pdesc4, Pdesc5, Pdesc6 from Otherhits WHERE (Mtype = ? OR Mtype2 = ?) AND Forder > 0"); $queryS1->execute([$systype, $systype]); } } else { if ($systype == 'A'){ $queryS1 = $pdo->prepare("SELECT Pdesc, Pdesc2, Pdesc3, Pdesc4, Pdesc5, Pdesc6 from Otherhits WHERE Country = ? OR Country2 = ? OR Country3 = ? OR Country4 = ? AND Forder > 0"); $queryS1->execute([$scountry, $scountry, $scountry, $scountry]); } else if (strlen($systype) == 2){ $queryS1 = $pdo->prepare("SELECT Pdesc, Pdesc2, Pdesc3, Pdesc4, Pdesc5, Pdesc6 from Otherhits WHERE (Stype = ? OR Stype2 = ?) AND (Country = ? OR Country2 = ? OR Country3 = ? OR Country4 = ?) AND Forder > 0"); $queryS1->execute([$systype, $systype, $scountry, $scountry, $scountry, $scountry]); } else if ($systype == 'M'){ $queryS1 = $pdo->prepare("SELECT Pdesc, Pdesc2, Pdesc3, Pdesc4, Pdesc5, Pdesc6 from Otherhits WHERE Page NOT LIKE 'O-%' AND (Country = ? OR Country2 = ? OR Country3 = ? OR Country4 = ?) AND Forder > 0"); $queryS1->execute([$scountry, $scountry, $scountry, $scountry]); } else if ($systype == 'N'){ $queryS1 = $pdo->prepare("SELECT Pdesc, Pdesc2, Pdesc3, Pdesc4, Pdesc5, Pdesc6 from Otherhits WHERE Mtype <> '' AND (Country = ? OR Country2 = ? OR Country3 = ? OR Country4 = ?) AND Forder > 0"); $queryS1->execute([$scountry, $scountry, $scountry, $scountry]); } else { $queryS1 = $pdo->prepare("SELECT Pdesc, Pdesc2, Pdesc3, Pdesc4, Pdesc5, Pdesc6 from Otherhits WHERE (Mtype = ? OR Mtype2 = ?) AND (Country = ? OR Country2 = ? OR Country3 = ? OR Country4 = ?) AND Forder > 0"); $queryS1->execute([$systype, $systype, $scountry, $scountry, $scountry, $scountry]); } } $sp1 = 1; while ($rowS1 = $queryS1->fetch()) { $tspdesc1 = $rowS1['Pdesc']; if ($tspdesc1 <> '' AND (stripos($tspdesc1, $Sysfind) !== false OR $Sysfind == '')){ $spdesc[$sp1] = $tspdesc1; ++$sp1; } $tspdesc2 = $rowS1['Pdesc2']; if ($tspdesc2 <> '' AND (stripos($tspdesc2, $Sysfind) !== false OR $Sysfind == '')){ $spdesc[$sp1] = $tspdesc2; ++$sp1; } $tspdesc3 = $rowS1['Pdesc3']; if ($tspdesc3 <> '' AND (stripos($tspdesc3, $Sysfind)!== false OR $Sysfind == '')){ $spdesc[$sp1] = $tspdesc3; ++$sp1; } $tspdesc4 = $rowS1['Pdesc4']; if ($tspdesc4 <> '' AND (stripos($tspdesc4,$Sysfind)!== false OR $Sysfind == '')){ $spdesc[$sp1] = $tspdesc4; ++$sp1; } $tspdesc5 = $rowS1['Pdesc5']; if ($tspdesc5 <> '' AND (stripos($tspdesc5,$Sysfind)!== false OR $Sysfind == '')){ $spdesc[$sp1] = $tspdesc5; ++$sp1; } $tspdesc6 = $rowS1['Pdesc6']; if ($tspdesc6 <> '' AND (stripos($tspdesc6,$Sysfind)!== false OR $Sysfind == '')){ $spdesc[$sp1] = $tspdesc6; ++$sp1; } } $tspdesc = array_unique($spdesc, SORT_REGULAR); $tsma = 1; $sma = 0; while ($tsma<$sp1){ if ($tspdesc[$tsma]<>''){ $Psdesc[$sma] = $tspdesc[$tsma]; ++$sma; } ++$tsma; } sort($Psdesc, SORT_NATURAL | SORT_FLAG_CASE); echo ""; } ?> Toggle main menu visibility

• Home
  • Meccano Home Page
  • Meccano Magazines
    • Meccano Magazines
    • Johnny's Meccano Magazines
    • Sheffield Meccano Guild Magazines
    • Schrauber und Sammler Magazines
  • Meccano Manual Info/Downloads
  • Meccano Ltd. Patents and Designs
  • Meccano Ltd. Engineering Drawings
  • Meccano Set Parts Lists
  • Meccano Ltd Brochures
  • Virtual Mec Files
  • My Meccano Models
  • 'Other' Construction Systems
  • Guestbook
  • Send a Message
  • Links to other Meccano websites
  • My Personal Home Page
• 'Other' Systems Home
  • 'Other' Systems Home Page
  • Other Systems Newsletter by Tony Knowles
  • Metal Constructional Systems Database
  • Metal Constructional Systems Books
  • 'Polylong' Type Sets
  • Non-Metal Constructional Systems
  • Search manufacturers
  • Short History of Metal Constructional Systems
  • Other Systems Discussion Forum

© 2010-2024 Timothy Edwards