\n"; ?> rik2 0) { $avdFIN = $avdFIN + 4; // {0,5,6,7,8} }else{ $avdFIN = 0; } $avdFIN = (string) $avdFIN; $avdSAM = (int) $avdnr + 64; $avdSAM = chr($avdSAM); $avdSAM = strtolower($avdSAM); // {@,a,b,c,d} if ($avdSAM == "@") { $avdSAM = "0"; } } if ($sprak == "sve") { $avd = (int) $avdnr; // {0,1,2,3,4} $avd = (string) $avd; } if ($sprak == "fin") { $avd = (int) $avdnr; if ($avd > 0) { $avd = $avd + 4; // {0,5,6,7,8} }else{ $avd = 0; } $avd = (string) $avd; } if ($sprak == "sam") { $avd = (int) $avdnr + 64; $avd = chr($avd); $avd = strtolower($avd); // {@,a,b,c,d} if ($avd == "@") { $avd = "0"; } } // echo $avd . " " . gettype($avd); //################################################################################################# ?> ">
Institutet för språk och folkminnen

 ORTNAMNSREGISTRET  |  Sök i hela Ortnamnsregistret  
 Till registrets startsida Till information 

 Skriv ett ortnamn och/eller lokal
 Sök på ortnamn    
 Sök på lokaltyp     

Bebyggelse- och naturnamn '); printf(''); printf(''); printf(''); printf(''); }else{ $elementsRadio2 = array( array('name' => 'Bebyggelse- och naturnamn ', 'value' => '0'), array('name' => 'Bebyggelse ', 'value' => '1'), array('name' => 'Natur ', 'value' => '2'), array('name' => 'Bebyggelse ', 'value' => '3'), array('name' => 'Natur ', 'value' => '4') ); foreach ($elementsRadio2 as $element) { printf('', $element['value'], (isset($_REQUEST['avdnr']) and $_REQUEST['avdnr'] == $element['value']) ? 'checked="checked"' : '', $element['name']); } } //$avdnr == "0" if ($sprak == "alla") { printf(''); printf(''); printf(''); printf(''); } if ($sprak == "sve") { printf(''); printf(''); printf(''); printf(''); } if ($sprak == "fin") { printf(''); printf(''); printf(''); printf(''); } if ($sprak == "sam") { printf(''); printf(''); printf(''); printf(''); } // ############################################################################################################ ?>
 Välj kategori  Välj språk
 Samtliga  Äldre namnformer  Uppteckningar  
Bebyggelsenamn Naturnamn Bebyggelsenamn Naturnamn %sAllaSvenska Finska Samiska AllaSvenska Finska Samiska AllaSvenska Finska Samiska AllaSvenska Finska Samiska 

' Visa endast tolkningar', 'value' => 'e') ); foreach ($elementsCheckEtym as $element) { printf('%s', $element['value'], (isset($_REQUEST['etym']) and $_REQUEST['etym'] == $element['value']) ? 'checked="checked"' : '', $element['name']); } ?>
  Söktips:
  %-tecken före eller efter sökord visar alla belägg som innehåller sökordet.
  Om stavningen är osäker; ersätt bokstav med understreck( _ ).
Error performing query: " . mysql_error() . "

"); exit(); } }else{ $result = mysql_query($sql2); if (!$result) { echo("

Error performing query: " . mysql_error() . "

"); exit(); } } }else{ //rubrik har värde if ($etym == true) { $result = mysql_query($sql3); if (!$result) { echo("

Error performing query: " . mysql_error() . "

"); exit(); } }else{ $result = mysql_query($sql4); if (!$result) { echo("

Error performing query: " . mysql_error() . "

"); exit(); } } } }else{ //if $avdnr != "0" if ($sprak == "alla") { $sql1 = "SELECT COUNT(*) AS alan FROM rik2 WHERE (SUBSTRING(rik2.akat FROM 2) = '$avdSVE' OR SUBSTRING(rik2.akat FROM 2) = '$avdFIN' OR SUBSTRING(rik2.akat FROM 2) = '$avdSAM') AND rik2.alok LIKE '$lokal' AND rik2.atol LIKE '1';"; $sql2 = "SELECT COUNT(*) AS alan FROM rik2 WHERE (SUBSTRING(rik2.akat FROM 2) = '$avdSVE' OR SUBSTRING(rik2.akat FROM 2) = '$avdFIN' OR SUBSTRING(rik2.akat FROM 2) = '$avdSAM') AND rik2.alok LIKE '$lokal';"; $sql3 = "SELECT COUNT(*) AS alan FROM rik2 WHERE (SUBSTRING(rik2.akat FROM 2) = '$avdSVE' OR SUBSTRING(rik2.akat FROM 2) = '$avdFIN' OR SUBSTRING(rik2.akat FROM 2) = '$avdSAM') AND rik2.asok LIKE '$rubrik' AND rik2.alok LIKE '$lokal' AND rik2.atol LIKE '1';"; $sql4 = "SELECT COUNT(*) AS alan FROM rik2 WHERE (SUBSTRING(rik2.akat FROM 2) = '$avdSVE' OR SUBSTRING(rik2.akat FROM 2) = '$avdFIN' OR SUBSTRING(rik2.akat FROM 2) = '$avdSAM') AND rik2.asok LIKE '$rubrik' AND rik2.alok LIKE '$lokal';"; $sql5 = "SELECT COUNT(*) AS alan FROM rik2,socken1 WHERE (SUBSTRING(rik2.akat FROM 2) = '$avdSVE' OR SUBSTRING(rik2.akat FROM 2) = '$avdFIN' OR SUBSTRING(rik2.akat FROM 2) = '$avdSAM') AND socken1.aort LIKE '$socken' AND socken1.anum = rik2.akod AND rik2.alok LIKE '$lokal' AND rik2.atol LIKE '1';"; $sql6 = "SELECT COUNT(*) AS alan FROM rik2,socken1 WHERE (SUBSTRING(rik2.akat FROM 2) = '$avdSVE' OR SUBSTRING(rik2.akat FROM 2) = '$avdFIN' OR SUBSTRING(rik2.akat FROM 2) = '$avdSAM') AND socken1.aort LIKE '$socken' AND socken1.anum = rik2.akod AND rik2.alok LIKE '$lokal';"; $sql7 = "SELECT COUNT(*) AS alan FROM rik2,socken1 WHERE (SUBSTRING(rik2.akat FROM 2) = '$avdSVE' OR SUBSTRING(rik2.akat FROM 2) = '$avdFIN' OR SUBSTRING(rik2.akat FROM 2) = '$avdSAM') AND socken1.aort LIKE '$socken' AND socken1.anum = rik2.akod AND rik2.asok LIKE '$rubrik' AND rik2.alok LIKE '$lokal' AND rik2.atol LIKE '1';"; $sql8 = "SELECT COUNT(*) AS alan FROM rik2,socken1 WHERE (SUBSTRING(rik2.akat FROM 2) = '$avdSVE' OR SUBSTRING(rik2.akat FROM 2) = '$avdFIN' OR SUBSTRING(rik2.akat FROM 2) = '$avdSAM') AND socken1.aort LIKE '$socken' AND socken1.anum = rik2.akod AND rik2.asok LIKE '$rubrik' AND rik2.alok LIKE '$lokal';"; $sql9 = "SELECT COUNT(*) AS alan FROM rik2,socken1 WHERE (SUBSTRING(rik2.akat FROM 2) = '$avdSVE' OR SUBSTRING(rik2.akat FROM 2) = '$avdFIN' OR SUBSTRING(rik2.akat FROM 2) = '$avdSAM') AND socken1.ahrd LIKE '$harad' AND socken1.anum = rik2.akod AND rik2.alok LIKE '$lokal' AND rik2.atol LIKE '1';"; $sqlA = "SELECT COUNT(*) AS alan FROM rik2,socken1 WHERE (SUBSTRING(rik2.akat FROM 2) = '$avdSVE' OR SUBSTRING(rik2.akat FROM 2) = '$avdFIN' OR SUBSTRING(rik2.akat FROM 2) = '$avdSAM') AND socken1.ahrd LIKE '$harad' AND socken1.anum = rik2.akod AND rik2.alok LIKE '$lokal';"; $sqlB = "SELECT COUNT(*) AS alan FROM rik2,socken1 WHERE (SUBSTRING(rik2.akat FROM 2) = '$avdSVE' OR SUBSTRING(rik2.akat FROM 2) = '$avdFIN' OR SUBSTRING(rik2.akat FROM 2) = '$avdSAM') AND socken1.ahrd LIKE '$harad' AND socken1.anum = rik2.akod AND rik2.asok LIKE '$rubrik' AND rik2.alok LIKE '$lokal' AND rik2.atol LIKE '1';"; $sqlC = "SELECT COUNT(*) AS alan FROM rik2,socken1 WHERE (SUBSTRING(rik2.akat FROM 2) = '$avdSVE' OR SUBSTRING(rik2.akat FROM 2) = '$avdFIN' OR SUBSTRING(rik2.akat FROM 2) = '$avdSAM') AND socken1.ahrd LIKE '$harad' AND socken1.anum = rik2.akod AND rik2.asok LIKE '$rubrik' AND rik2.alok LIKE '$lokal';"; } if ($sprak == "sve") { $sql1 = "SELECT COUNT(*) AS alan FROM rik2 WHERE SUBSTRING(rik2.akat FROM 2) = '$avd' AND (rik2.aurv LIKE '1' OR rik2.aurv LIKE '3') AND rik2.alok LIKE '$lokal' AND rik2.atol LIKE '1';"; $sql2 = "SELECT COUNT(*) AS alan FROM rik2 WHERE SUBSTRING(rik2.akat FROM 2) = '$avd' AND (rik2.aurv LIKE '1' OR rik2.aurv LIKE '3') AND rik2.alok LIKE '$lokal';"; $sql3 = "SELECT COUNT(*) AS alan FROM rik2 WHERE SUBSTRING(rik2.akat FROM 2) = '$avd' AND (rik2.aurv LIKE '1' OR rik2.aurv LIKE '3') AND rik2.asok LIKE '$rubrik' AND rik2.alok LIKE '$lokal' AND rik2.atol LIKE '1';"; $sql4 = "SELECT COUNT(*) AS alan FROM rik2 WHERE SUBSTRING(rik2.akat FROM 2) = '$avd' AND (rik2.aurv LIKE '1' OR rik2.aurv LIKE '3') AND rik2.asok LIKE '$rubrik' AND rik2.alok LIKE '$lokal';"; $sql5 = "SELECT COUNT(*) AS alan FROM rik2,socken1 WHERE SUBSTRING(rik2.akat FROM 2) = '$avd' AND (rik2.aurv LIKE '1' OR rik2.aurv LIKE '3') AND socken1.aort LIKE '$socken' AND socken1.anum = rik2.akod AND rik2.alok LIKE '$lokal' AND rik2.atol LIKE '1';"; $sql6 = "SELECT COUNT(*) AS alan FROM rik2,socken1 WHERE SUBSTRING(rik2.akat FROM 2) = '$avd' AND (rik2.aurv LIKE '1' OR rik2.aurv LIKE '3') AND socken1.aort LIKE '$socken' AND socken1.anum = rik2.akod AND rik2.alok LIKE '$lokal';"; $sql7 = "SELECT COUNT(*) AS alan FROM rik2,socken1 WHERE SUBSTRING(rik2.akat FROM 2) = '$avd' AND (rik2.aurv LIKE '1' OR rik2.aurv LIKE '3') AND socken1.aort LIKE '$socken' AND socken1.anum = rik2.akod AND rik2.asok LIKE '$rubrik' AND rik2.alok LIKE '$lokal' AND rik2.atol LIKE '1';"; $sql8 = "SELECT COUNT(*) AS alan FROM rik2,socken1 WHERE SUBSTRING(rik2.akat FROM 2) = '$avd' AND (rik2.aurv LIKE '1' OR rik2.aurv LIKE '3') AND socken1.aort LIKE '$socken' AND socken1.anum = rik2.akod AND rik2.asok LIKE '$rubrik' AND rik2.alok LIKE '$lokal';"; $sql9 = "SELECT COUNT(*) AS alan FROM rik2,socken1 WHERE SUBSTRING(rik2.akat FROM 2) = '$avd' AND (rik2.aurv LIKE '1' OR rik2.aurv LIKE '3') AND socken1.ahrd LIKE '$harad' AND socken1.anum = rik2.akod AND rik2.alok LIKE '$lokal' AND rik2.atol LIKE '1';"; $sqlA = "SELECT COUNT(*) AS alan FROM rik2,socken1 WHERE SUBSTRING(rik2.akat FROM 2) = '$avd' AND (rik2.aurv LIKE '1' OR rik2.aurv LIKE '3') AND socken1.ahrd LIKE '$harad' AND socken1.anum = rik2.akod AND rik2.alok LIKE '$lokal';"; $sqlB = "SELECT COUNT(*) AS alan FROM rik2,socken1 WHERE SUBSTRING(rik2.akat FROM 2) = '$avd' AND (rik2.aurv LIKE '1' OR rik2.aurv LIKE '3') AND socken1.ahrd LIKE '$harad' AND socken1.anum = rik2.akod AND rik2.asok LIKE '$rubrik' AND rik2.alok LIKE '$lokal' AND rik2.atol LIKE '1';"; $sqlC = "SELECT COUNT(*) AS alan FROM rik2,socken1 WHERE SUBSTRING(rik2.akat FROM 2) = '$avd' AND (rik2.aurv LIKE '1' OR rik2.aurv LIKE '3') AND socken1.ahrd LIKE '$harad' AND socken1.anum = rik2.akod AND rik2.asok LIKE '$rubrik' AND rik2.alok LIKE '$lokal';"; } if ($sprak == "fin") { $sql1 = "SELECT COUNT(*) AS alan FROM rik2 WHERE SUBSTRING(rik2.akat FROM 2) = '$avd' AND (rik2.aurv LIKE '5' OR rik2.aurv LIKE '7') AND rik2.alok LIKE '$lokal' AND rik2.atol LIKE '1';"; $sql2 = "SELECT COUNT(*) AS alan FROM rik2 WHERE SUBSTRING(rik2.akat FROM 2) = '$avd' AND (rik2.aurv LIKE '5' OR rik2.aurv LIKE '7') AND rik2.alok LIKE '$lokal';"; $sql3 = "SELECT COUNT(*) AS alan FROM rik2 WHERE SUBSTRING(rik2.akat FROM 2) = '$avd' AND (rik2.aurv LIKE '5' OR rik2.aurv LIKE '7') AND rik2.asok LIKE '$rubrik' AND rik2.alok LIKE '$lokal' AND rik2.atol LIKE '1';"; $sql4 = "SELECT COUNT(*) AS alan FROM rik2 WHERE SUBSTRING(rik2.akat FROM 2) = '$avd' AND (rik2.aurv LIKE '5' OR rik2.aurv LIKE '7') AND rik2.asok LIKE '$rubrik' AND rik2.alok LIKE '$lokal';"; $sql5 = "SELECT COUNT(*) AS alan FROM rik2,socken1 WHERE SUBSTRING(rik2.akat FROM 2) = '$avd' AND (rik2.aurv LIKE '5' OR rik2.aurv LIKE '7') AND socken1.aort LIKE '$socken' AND socken1.anum = rik2.akod AND rik2.alok LIKE '$lokal' AND rik2.atol LIKE '1';"; $sql6 = "SELECT COUNT(*) AS alan FROM rik2,socken1 WHERE SUBSTRING(rik2.akat FROM 2) = '$avd' AND (rik2.aurv LIKE '5' OR rik2.aurv LIKE '7') AND socken1.aort LIKE '$socken' AND socken1.anum = rik2.akod AND rik2.alok LIKE '$lokal';"; $sql7 = "SELECT COUNT(*) AS alan FROM rik2,socken1 WHERE SUBSTRING(rik2.akat FROM 2) = '$avd' AND (rik2.aurv LIKE '5' OR rik2.aurv LIKE '7') AND socken1.aort LIKE '$socken' AND socken1.anum = rik2.akod AND rik2.asok LIKE '$rubrik' AND rik2.alok LIKE '$lokal' AND rik2.atol LIKE '1';"; $sql8 = "SELECT COUNT(*) AS alan FROM rik2,socken1 WHERE SUBSTRING(rik2.akat FROM 2) = '$avd' AND (rik2.aurv LIKE '5' OR rik2.aurv LIKE '7') AND socken1.aort LIKE '$socken' AND socken1.anum = rik2.akod AND rik2.asok LIKE '$rubrik' AND rik2.alok LIKE '$lokal';"; $sql9 = "SELECT COUNT(*) AS alan FROM rik2,socken1 WHERE SUBSTRING(rik2.akat FROM 2) = '$avd' AND (rik2.aurv LIKE '5' OR rik2.aurv LIKE '7') AND socken1.ahrd LIKE '$harad' AND socken1.anum = rik2.akod AND rik2.alok LIKE '$lokal' AND rik2.atol LIKE '1';"; $sqlA = "SELECT COUNT(*) AS alan FROM rik2,socken1 WHERE SUBSTRING(rik2.akat FROM 2) = '$avd' AND (rik2.aurv LIKE '5' OR rik2.aurv LIKE '7') AND socken1.ahrd LIKE '$harad' AND socken1.anum = rik2.akod AND rik2.alok LIKE '$lokal';"; $sqlB = "SELECT COUNT(*) AS alan FROM rik2,socken1 WHERE SUBSTRING(rik2.akat FROM 2) = '$avd' AND (rik2.aurv LIKE '5' OR rik2.aurv LIKE '7') AND socken1.ahrd LIKE '$harad' AND socken1.anum = rik2.akod AND rik2.asok LIKE '$rubrik' AND rik2.alok LIKE '$lokal' AND rik2.atol LIKE '1';"; $sqlC = "SELECT COUNT(*) AS alan FROM rik2,socken1 WHERE SUBSTRING(rik2.akat FROM 2) = '$avd' AND (rik2.aurv LIKE '5' OR rik2.aurv LIKE '7') AND socken1.ahrd LIKE '$harad' AND socken1.anum = rik2.akod AND rik2.asok LIKE '$rubrik' AND rik2.alok LIKE '$lokal';"; } if ($sprak == "sam") { $sql1 = "SELECT COUNT(*) AS alan FROM rik2 WHERE SUBSTRING(rik2.akat FROM 2) = '$avd' AND (rik2.aurv LIKE 'a' OR rik2.aurv LIKE 'c') AND rik2.alok LIKE '$lokal' AND rik2.atol LIKE '1';"; $sql2 = "SELECT COUNT(*) AS alan FROM rik2 WHERE SUBSTRING(rik2.akat FROM 2) = '$avd' AND (rik2.aurv LIKE 'a' OR rik2.aurv LIKE 'c') AND rik2.alok LIKE '$lokal';"; $sql3 = "SELECT COUNT(*) AS alan FROM rik2 WHERE SUBSTRING(rik2.akat FROM 2) = '$avd' AND (rik2.aurv LIKE 'a' OR rik2.aurv LIKE 'c') AND rik2.asok LIKE '$rubrik' AND rik2.alok LIKE '$lokal' AND rik2.atol LIKE '1';"; $sql4 = "SELECT COUNT(*) AS alan FROM rik2 WHERE SUBSTRING(rik2.akat FROM 2) = '$avd' AND (rik2.aurv LIKE 'a' OR rik2.aurv LIKE 'c') AND rik2.asok LIKE '$rubrik' AND rik2.alok LIKE '$lokal';"; $sql5 = "SELECT COUNT(*) AS alan FROM rik2,socken1 WHERE SUBSTRING(rik2.akat FROM 2) = '$avd' AND (rik2.aurv LIKE 'a' OR rik2.aurv LIKE 'c') AND socken1.aort LIKE '$socken' AND socken1.anum = rik2.akod AND rik2.alok LIKE '$lokal' AND rik2.atol LIKE '1';"; $sql6 = "SELECT COUNT(*) AS alan FROM rik2,socken1 WHERE SUBSTRING(rik2.akat FROM 2) = '$avd' AND (rik2.aurv LIKE 'a' OR rik2.aurv LIKE 'c') AND socken1.aort LIKE '$socken' AND socken1.anum = rik2.akod AND rik2.alok LIKE '$lokal';"; $sql7 = "SELECT COUNT(*) AS alan FROM rik2,socken1 WHERE SUBSTRING(rik2.akat FROM 2) = '$avd' AND (rik2.aurv LIKE 'a' OR rik2.aurv LIKE 'c') AND socken1.aort LIKE '$socken' AND socken1.anum = rik2.akod AND rik2.asok LIKE '$rubrik' AND rik2.alok LIKE '$lokal' AND rik2.atol LIKE '1';"; $sql8 = "SELECT COUNT(*) AS alan FROM rik2,socken1 WHERE SUBSTRING(rik2.akat FROM 2) = '$avd' AND (rik2.aurv LIKE 'a' OR rik2.aurv LIKE 'c') AND socken1.aort LIKE '$socken' AND socken1.anum = rik2.akod AND rik2.asok LIKE '$rubrik' AND rik2.alok LIKE '$lokal';"; $sql9 = "SELECT COUNT(*) AS alan FROM rik2,socken1 WHERE SUBSTRING(rik2.akat FROM 2) = '$avd' AND (rik2.aurv LIKE 'a' OR rik2.aurv LIKE 'c') AND socken1.ahrd LIKE '$harad' AND socken1.anum = rik2.akod AND rik2.alok LIKE '$lokal' AND rik2.atol LIKE '1';"; $sqlA = "SELECT COUNT(*) AS alan FROM rik2,socken1 WHERE SUBSTRING(rik2.akat FROM 2) = '$avd' AND (rik2.aurv LIKE 'a' OR rik2.aurv LIKE 'c') AND socken1.ahrd LIKE '$harad' AND socken1.anum = rik2.akod AND rik2.alok LIKE '$lokal';"; $sqlB = "SELECT COUNT(*) AS alan FROM rik2,socken1 WHERE SUBSTRING(rik2.akat FROM 2) = '$avd' AND (rik2.aurv LIKE 'a' OR rik2.aurv LIKE 'c') AND socken1.ahrd LIKE '$harad' AND socken1.anum = rik2.akod AND rik2.asok LIKE '$rubrik' AND rik2.alok LIKE '$lokal' AND rik2.atol LIKE '1';"; $sqlC = "SELECT COUNT(*) AS alan FROM rik2,socken1 WHERE SUBSTRING(rik2.akat FROM 2) = '$avd' AND (rik2.aurv LIKE 'a' OR rik2.aurv LIKE 'c') AND socken1.ahrd LIKE '$harad' AND socken1.anum = rik2.akod AND rik2.asok LIKE '$rubrik' AND rik2.alok LIKE '$lokal';"; } if ($rubrik == "") { if ($etym == true) { $result = mysql_query($sql1); if (!$result) { echo("

Error performing query: " . mysql_error() . "

"); exit(); } }else{ $result = mysql_query($sql2); if (!$result) { echo("

Error performing query: " . mysql_error() . "

"); exit(); } } }else{ //rubrik har värde if ($etym == true) { $result = mysql_query($sql3); if (!$result) { echo("

Error performing query: " . mysql_error() . "

"); exit(); } }else{ $result = mysql_query($sql4); if (!$result) { echo("

Error performing query: " . mysql_error() . "

"); exit(); } } } } //if avdnr = 0 $total = @mysql_result($result,0); } // ############################################################################################################ if ($avdnr == "0") { if ($sprak == "alla") { $sql1 = "SELECT * FROM rik2 WHERE rik2.alok LIKE '$lokal' AND rik2.atol LIKE '1' LIMIT $fran,$antal;"; $sql2 = "SELECT * FROM rik2 WHERE rik2.alok LIKE '$lokal' LIMIT $fran,$antal;"; $sql3 = "SELECT * FROM rik2 WHERE rik2.asok LIKE '$rubrik' AND rik2.alok LIKE '$lokal' AND rik2.atol LIKE '1' LIMIT $fran,$antal;"; $sql4 = "SELECT * FROM rik2 WHERE rik2.asok LIKE '$rubrik' AND rik2.alok LIKE '$lokal' LIMIT $fran,$antal;"; $sql5 = "SELECT * FROM rik2,socken1 WHERE ((rik2.aurv LIKE '1' OR rik2.aurv LIKE '3') OR (rik2.aurv LIKE '5' OR rik2.aurv LIKE '7') OR (rik2.aurv LIKE 'a' OR rik2.aurv LIKE 'c')) AND socken1.aort LIKE '$socken' AND socken1.anum = rik2.akod AND rik2.alok LIKE '$lokal' AND rik2.atol LIKE '1' LIMIT $fran,$antal;"; $sql6 = "SELECT * FROM rik2,socken1 WHERE ((rik2.aurv LIKE '1' OR rik2.aurv LIKE '3') OR (rik2.aurv LIKE '5' OR rik2.aurv LIKE '7') OR (rik2.aurv LIKE 'a' OR rik2.aurv LIKE 'c')) AND socken1.aort LIKE '$socken' AND socken1.anum = rik2.akod AND rik2.alok LIKE '$lokal' LIMIT $fran,$antal;"; $sql7 = "SELECT * FROM rik2,socken1 WHERE ((rik2.aurv LIKE '1' OR rik2.aurv LIKE '3') OR (rik2.aurv LIKE '5' OR rik2.aurv LIKE '7') OR (rik2.aurv LIKE 'a' OR rik2.aurv LIKE 'c')) AND socken1.aort LIKE '$socken' AND socken1.anum = rik2.akod AND rik2.asok LIKE '$rubrik' AND rik2.alok LIKE '$lokal' AND rik2.atol LIKE '1' LIMIT $fran,$antal;"; $sql8 = "SELECT * FROM rik2,socken1 WHERE ((rik2.aurv LIKE '1' OR rik2.aurv LIKE '3') OR (rik2.aurv LIKE '5' OR rik2.aurv LIKE '7') OR (rik2.aurv LIKE 'a' OR rik2.aurv LIKE 'c')) AND socken1.aort LIKE '$socken' AND socken1.anum = rik2.akod AND rik2.asok LIKE '$rubrik' AND rik2.alok LIKE '$lokal' LIMIT $fran,$antal;"; $sql9 = "SELECT * FROM rik2,socken1 WHERE ((rik2.aurv LIKE '1' OR rik2.aurv LIKE '3') OR (rik2.aurv LIKE '5' OR rik2.aurv LIKE '7') OR (rik2.aurv LIKE 'a' OR rik2.aurv LIKE 'c')) AND socken1.ahrd LIKE '$harad' AND socken1.anum = rik2.akod AND rik2.alok LIKE '$lokal' AND rik2.atol LIKE '1' LIMIT $fran,$antal;"; $sqlA = "SELECT * FROM rik2,socken1 WHERE ((rik2.aurv LIKE '1' OR rik2.aurv LIKE '3') OR (rik2.aurv LIKE '5' OR rik2.aurv LIKE '7') OR (rik2.aurv LIKE 'a' OR rik2.aurv LIKE 'c')) AND socken1.ahrd LIKE '$harad' AND socken1.anum = rik2.akod AND rik2.alok LIKE '$lokal' LIMIT $fran,$antal;"; $sqlB = "SELECT * FROM rik2,socken1 WHERE ((rik2.aurv LIKE '1' OR rik2.aurv LIKE '3') OR (rik2.aurv LIKE '5' OR rik2.aurv LIKE '7') OR (rik2.aurv LIKE 'a' OR rik2.aurv LIKE 'c')) AND socken1.ahrd LIKE '$harad' AND socken1.anum = rik2.akod AND rik2.asok LIKE '$rubrik' AND rik2.alok LIKE '$lokal' AND rik2.atol LIKE '1' LIMIT $fran,$antal;"; $sqlC = "SELECT * FROM rik2,socken1 WHERE ((rik2.aurv LIKE '1' OR rik2.aurv LIKE '3') OR (rik2.aurv LIKE '5' OR rik2.aurv LIKE '7') OR (rik2.aurv LIKE 'a' OR rik2.aurv LIKE 'c')) AND socken1.ahrd LIKE '$harad' AND socken1.anum = rik2.akod AND rik2.asok LIKE '$rubrik' AND rik2.alok LIKE '$lokal' LIMIT $fran,$antal;"; } if ($sprak == "sve") { $sql1 = "SELECT * FROM rik2 WHERE (rik2.aurv LIKE '1' OR rik2.aurv LIKE '3') AND rik2.alok LIKE '$lokal' AND rik2.atol LIKE '1' LIMIT $fran,$antal;"; $sql2 = "SELECT * FROM rik2 WHERE (rik2.aurv LIKE '1' OR rik2.aurv LIKE '3') AND rik2.alok LIKE '$lokal' LIMIT $fran,$antal;"; $sql3 = "SELECT * FROM rik2 WHERE (rik2.aurv LIKE '1' OR rik2.aurv LIKE '3') AND rik2.asok LIKE '$rubrik' AND rik2.alok LIKE '$lokal' AND rik2.atol LIKE '1' LIMIT $fran,$antal;"; $sql4 = "SELECT * FROM rik2 WHERE (rik2.aurv LIKE '1' OR rik2.aurv LIKE '3') AND rik2.asok LIKE '$rubrik' AND rik2.alok LIKE '$lokal' LIMIT $fran,$antal;"; $sql5 = "SELECT * FROM rik2,socken1 WHERE (rik2.aurv LIKE '1' OR rik2.aurv LIKE '3') AND socken1.aort LIKE '$socken' AND socken1.anum = rik2.akod AND rik2.alok LIKE '$lokal' AND rik2.atol LIKE '1' LIMIT $fran,$antal;"; $sql6 = "SELECT * FROM rik2,socken1 WHERE (rik2.aurv LIKE '1' OR rik2.aurv LIKE '3') AND socken1.aort LIKE '$socken' AND socken1.anum = rik2.akod AND rik2.alok LIKE '$lokal' LIMIT $fran,$antal;"; $sql7 = "SELECT * FROM rik2,socken1 WHERE (rik2.aurv LIKE '1' OR rik2.aurv LIKE '3') AND socken1.aort LIKE '$socken' AND socken1.anum = rik2.akod AND rik2.asok LIKE '$rubrik' AND rik2.alok LIKE '$lokal' AND rik2.atol LIKE '1' LIMIT $fran,$antal;"; $sql8 = "SELECT * FROM rik2,socken1 WHERE (rik2.aurv LIKE '1' OR rik2.aurv LIKE '3') AND socken1.aort LIKE '$socken' AND socken1.anum = rik2.akod AND rik2.asok LIKE '$rubrik' AND rik2.alok LIKE '$lokal' LIMIT $fran,$antal;"; $sql9 = "SELECT * FROM rik2,socken1 WHERE (rik2.aurv LIKE '1' OR rik2.aurv LIKE '3') AND socken1.ahrd LIKE '$harad' AND socken1.anum = rik2.akod AND rik2.alok LIKE '$lokal' AND rik2.atol LIKE '1' LIMIT $fran,$antal;"; $sqlA = "SELECT * FROM rik2,socken1 WHERE (rik2.aurv LIKE '1' OR rik2.aurv LIKE '3') AND socken1.ahrd LIKE '$harad' AND socken1.anum = rik2.akod AND rik2.alok LIKE '$lokal' LIMIT $fran,$antal;"; $sqlB = "SELECT * FROM rik2,socken1 WHERE (rik2.aurv LIKE '1' OR rik2.aurv LIKE '3') AND socken1.ahrd LIKE '$harad' AND socken1.anum = rik2.akod AND rik2.asok LIKE '$rubrik' AND rik2.alok LIKE '$lokal' AND rik2.atol LIKE '1' LIMIT $fran,$antal;"; $sqlC = "SELECT * FROM rik2,socken1 WHERE (rik2.aurv LIKE '1' OR rik2.aurv LIKE '3') AND socken1.ahrd LIKE '$harad' AND socken1.anum = rik2.akod AND rik2.asok LIKE '$rubrik' AND rik2.alok LIKE '$lokal' LIMIT $fran,$antal;"; } if ($sprak == "fin") { $sql1 = "SELECT * FROM rik2 WHERE (rik2.aurv LIKE '5' OR rik2.aurv LIKE '7') AND rik2.alok LIKE '$lokal' AND rik2.atol LIKE '1' LIMIT $fran,$antal;"; $sql2 = "SELECT * FROM rik2 WHERE (rik2.aurv LIKE '5' OR rik2.aurv LIKE '7') AND rik2.alok LIKE '$lokal' LIMIT $fran,$antal;"; $sql3 = "SELECT * FROM rik2 WHERE (rik2.aurv LIKE '5' OR rik2.aurv LIKE '7') AND rik2.asok LIKE '$rubrik' AND rik2.alok LIKE '$lokal' AND rik2.atol LIKE '1' LIMIT $fran,$antal;"; $sql4 = "SELECT * FROM rik2 WHERE (rik2.aurv LIKE '5' OR rik2.aurv LIKE '7') AND rik2.asok LIKE '$rubrik' AND rik2.alok LIKE '$lokal' LIMIT $fran,$antal;"; $sql5 = "SELECT * FROM rik2,socken1 WHERE (rik2.aurv LIKE '5' OR rik2.aurv LIKE '7') AND socken1.aort LIKE '$socken' AND socken1.anum = rik2.akod AND rik2.alok LIKE '$lokal' AND rik2.atol LIKE '1' LIMIT $fran,$antal;"; $sql6 = "SELECT * FROM rik2,socken1 WHERE (rik2.aurv LIKE '5' OR rik2.aurv LIKE '7') AND socken1.aort LIKE '$socken' AND socken1.anum = rik2.akod AND rik2.alok LIKE '$lokal' LIMIT $fran,$antal;"; $sql7 = "SELECT * FROM rik2,socken1 WHERE (rik2.aurv LIKE '5' OR rik2.aurv LIKE '7') AND socken1.aort LIKE '$socken' AND socken1.anum = rik2.akod AND rik2.asok LIKE '$rubrik' AND rik2.alok LIKE '$lokal' AND rik2.atol LIKE '1' LIMIT $fran,$antal;"; $sql8 = "SELECT * FROM rik2,socken1 WHERE (rik2.aurv LIKE '5' OR rik2.aurv LIKE '7') AND socken1.aort LIKE '$socken' AND socken1.anum = rik2.akod AND rik2.asok LIKE '$rubrik' AND rik2.alok LIKE '$lokal' LIMIT $fran,$antal;"; $sql9 = "SELECT * FROM rik2,socken1 WHERE (rik2.aurv LIKE '5' OR rik2.aurv LIKE '7') AND socken1.ahrd LIKE '$harad' AND socken1.anum = rik2.akod AND rik2.alok LIKE '$lokal' AND rik2.atol LIKE '1' LIMIT $fran,$antal;"; $sqlA = "SELECT * FROM rik2,socken1 WHERE (rik2.aurv LIKE '5' OR rik2.aurv LIKE '7') AND socken1.ahrd LIKE '$harad' AND socken1.anum = rik2.akod AND rik2.alok LIKE '$lokal' LIMIT $fran,$antal;"; $sqlB = "SELECT * FROM rik2,socken1 WHERE (rik2.aurv LIKE '5' OR rik2.aurv LIKE '7') AND socken1.ahrd LIKE '$harad' AND socken1.anum = rik2.akod AND rik2.asok LIKE '$rubrik' AND rik2.alok LIKE '$lokal' AND rik2.atol LIKE '1' LIMIT $fran,$antal;"; $sqlC = "SELECT * FROM rik2,socken1 WHERE (rik2.aurv LIKE '5' OR rik2.aurv LIKE '7') AND socken1.ahrd LIKE '$harad' AND socken1.anum = rik2.akod AND rik2.asok LIKE '$rubrik' AND rik2.alok LIKE '$lokal' LIMIT $fran,$antal;"; } if ($sprak == "sam") { $sql1 = "SELECT * FROM rik2 WHERE (rik2.aurv LIKE 'a' OR rik2.aurv LIKE 'c') AND rik2.alok LIKE '$lokal' AND rik2.atol LIKE '1' LIMIT $fran,$antal;"; $sql2 = "SELECT * FROM rik2 WHERE (rik2.aurv LIKE 'a' OR rik2.aurv LIKE 'c') AND rik2.alok LIKE '$lokal' LIMIT $fran,$antal;"; $sql3 = "SELECT * FROM rik2 WHERE (rik2.aurv LIKE 'a' OR rik2.aurv LIKE 'c') AND rik2.asok LIKE '$rubrik' AND rik2.alok LIKE '$lokal' AND rik2.atol LIKE '1' LIMIT $fran,$antal;"; $sql4 = "SELECT * FROM rik2 WHERE (rik2.aurv LIKE 'a' OR rik2.aurv LIKE 'c') AND rik2.asok LIKE '$rubrik' AND rik2.alok LIKE '$lokal' LIMIT $fran,$antal;"; $sql5 = "SELECT * FROM rik2,socken1 WHERE (rik2.aurv LIKE 'a' OR rik2.aurv LIKE 'c') AND socken1.aort LIKE '$socken' AND socken1.anum = rik2.akod AND rik2.alok LIKE '$lokal' AND rik2.atol LIKE '1' LIMIT $fran,$antal;"; $sql6 = "SELECT * FROM rik2,socken1 WHERE (rik2.aurv LIKE 'a' OR rik2.aurv LIKE 'c') AND socken1.aort LIKE '$socken' AND socken1.anum = rik2.akod AND rik2.alok LIKE '$lokal' LIMIT $fran,$antal;"; $sql7 = "SELECT * FROM rik2,socken1 WHERE (rik2.aurv LIKE 'a' OR rik2.aurv LIKE 'c') AND socken1.aort LIKE '$socken' AND socken1.anum = rik2.akod AND rik2.asok LIKE '$rubrik' AND rik2.alok LIKE '$lokal' AND rik2.atol LIKE '1' LIMIT $fran,$antal;"; $sql8 = "SELECT * FROM rik2,socken1 WHERE (rik2.aurv LIKE 'a' OR rik2.aurv LIKE 'c') AND socken1.aort LIKE '$socken' AND socken1.anum = rik2.akod AND rik2.asok LIKE '$rubrik' AND rik2.alok LIKE '$lokal' LIMIT $fran,$antal;"; $sql9 = "SELECT * FROM rik2,socken1 WHERE (rik2.aurv LIKE 'a' OR rik2.aurv LIKE 'c') AND socken1.ahrd LIKE '$harad' AND socken1.anum = rik2.akod AND rik2.alok LIKE '$lokal' AND rik2.atol LIKE '1' LIMIT $fran,$antal;"; $sqlA = "SELECT * FROM rik2,socken1 WHERE (rik2.aurv LIKE 'a' OR rik2.aurv LIKE 'c') AND socken1.ahrd LIKE '$harad' AND socken1.anum = rik2.akod AND rik2.alok LIKE '$lokal' LIMIT $fran,$antal;"; $sqlB = "SELECT * FROM rik2,socken1 WHERE (rik2.aurv LIKE 'a' OR rik2.aurv LIKE 'c') AND socken1.ahrd LIKE '$harad' AND socken1.anum = rik2.akod AND rik2.asok LIKE '$rubrik' AND rik2.alok LIKE '$lokal' AND rik2.atol LIKE '1' LIMIT $fran,$antal;"; $sqlC = "SELECT * FROM rik2,socken1 WHERE (rik2.aurv LIKE 'a' OR rik2.aurv LIKE 'c') AND socken1.ahrd LIKE '$harad' AND socken1.anum = rik2.akod AND rik2.asok LIKE '$rubrik' AND rik2.alok LIKE '$lokal' LIMIT $fran,$antal;"; } if ($socken == "%Hela riket%") { if ($rubrik == "") { if ($etym == true) { $result = mysql_query($sql1); if (!$result) { echo("

Error performing query: " . mysql_error() . "

"); exit(); } }else{ $result = mysql_query($sql2); if (!$result) { echo("

Error performing query: " . mysql_error() . "

"); exit(); } } }else{ //rubrik har värde if ($etym == true) { $result = mysql_query($sql3); if (!$result) { echo("

Error performing query: " . mysql_error() . "

"); exit(); } }else{ $result = mysql_query($sql4); if (!$result) { echo("

Error performing query: " . mysql_error() . "

"); exit(); } } } }else{ //if socken <> "%Hela riket%" if ($harad == "") { if ($rubrik == "") { if ($etym == true) { $result = mysql_query($sql5); if (!$result) { echo("

Error performing query: " . mysql_error() . "

"); exit(); } }else{ $result = mysql_query($sql6); if (!$result) { echo("

Error performing query: " . mysql_error() . "

"); exit(); } } }else{ //rubrik has value if ($etym == true) { $result = mysql_query($sql7); if (!$result) { echo("

Error performing query: " . mysql_error() . "

"); exit(); } }else{ $result = mysql_query($sql8); if (!$result) { echo("

Error performing query: " . mysql_error() . "

"); exit(); } } } }else{ //if harad <> "" if ($rubrik == "") { if ($etym == true) { $result = mysql_query($sql9); if (!$result) { echo("

Error performing query: " . mysql_error() . "

"); exit(); } }else{ $result = mysql_query($sqlA); if (!$result) { echo("

Error performing query: " . mysql_error() . "

"); exit(); } } }else{ //rubrik has value if ($etym == true) { $result = mysql_query($sqlB); if (!$result) { echo("

Error performing query: " . mysql_error() . "

"); exit(); } }else{ $result = mysql_query($sqlC); if (!$result) { echo("

Error performing query: " . mysql_error() . "

"); exit(); } } } } // ends if harad = "" } //ends if socken = "%Hela riket%" }else{ //if avdnr <>0 if ($sprak == "alla") { $sql1 = "SELECT * FROM rik2 WHERE (SUBSTRING(rik2.akat FROM 2) = '$avdSVE' OR SUBSTRING(rik2.akat FROM 2) = '$avdFIN' OR SUBSTRING(rik2.akat FROM 2) = '$avdSAM') AND rik2.alok LIKE '$lokal' AND rik2.atol LIKE '1' LIMIT $fran,$antal;"; $sql2 = "SELECT * FROM rik2 WHERE (SUBSTRING(rik2.akat FROM 2) = '$avdSVE' OR SUBSTRING(rik2.akat FROM 2) = '$avdFIN' OR SUBSTRING(rik2.akat FROM 2) = '$avdSAM') AND rik2.alok LIKE '$lokal' LIMIT $fran,$antal;"; $sql3 = "SELECT * FROM rik2 WHERE (SUBSTRING(rik2.akat FROM 2) = '$avdSVE' OR SUBSTRING(rik2.akat FROM 2) = '$avdFIN' OR SUBSTRING(rik2.akat FROM 2) = '$avdSAM') AND rik2.asok LIKE '$rubrik' AND rik2.alok LIKE '$lokal' AND rik2.atol LIKE '1' LIMIT $fran,$antal;"; $sql4 = "SELECT * FROM rik2 WHERE (SUBSTRING(rik2.akat FROM 2) = '$avdSVE' OR SUBSTRING(rik2.akat FROM 2) = '$avdFIN' OR SUBSTRING(rik2.akat FROM 2) = '$avdSAM') AND rik2.asok LIKE '$rubrik' AND rik2.alok LIKE '$lokal' LIMIT $fran,$antal;"; $sql5 = "SELECT * FROM rik2,socken1 WHERE (SUBSTRING(rik2.akat FROM 2) = '$avdSVE' OR SUBSTRING(rik2.akat FROM 2) = '$avdFIN' OR SUBSTRING(rik2.akat FROM 2) = '$avdSAM') AND socken1.aort LIKE '$socken' AND socken1.anum = rik2.akod AND rik2.alok LIKE '$lokal' AND rik2.atol LIKE '1' LIMIT $fran,$antal;"; $sql6 = "SELECT * FROM rik2,socken1 WHERE (SUBSTRING(rik2.akat FROM 2) = '$avdSVE' OR SUBSTRING(rik2.akat FROM 2) = '$avdFIN' OR SUBSTRING(rik2.akat FROM 2) = '$avdSAM') AND socken1.aort LIKE '$socken' AND socken1.anum = rik2.akod AND rik2.alok LIKE '$lokal' LIMIT $fran,$antal;"; $sql7 = "SELECT * FROM rik2,socken1 WHERE (SUBSTRING(rik2.akat FROM 2) = '$avdSVE' OR SUBSTRING(rik2.akat FROM 2) = '$avdFIN' OR SUBSTRING(rik2.akat FROM 2) = '$avdSAM') AND socken1.aort LIKE '$socken' AND socken1.anum = rik2.akod AND rik2.asok LIKE '$rubrik'AND rik2.alok LIKE '$lokal' AND rik2.atol = '1' LIMIT $fran,$antal;"; $sql8 = "SELECT * FROM rik2,socken1 WHERE (SUBSTRING(rik2.akat FROM 2) = '$avdSVE' OR SUBSTRING(rik2.akat FROM 2) = '$avdFIN' OR SUBSTRING(rik2.akat FROM 2) = '$avdSAM') AND socken1.aort LIKE '$socken' AND socken1.anum = rik2.akod AND rik2.asok LIKE '$rubrik' AND rik2.alok LIKE '$lokal' LIMIT $fran,$antal;"; $sql9 = "SELECT * FROM rik2,socken1 WHERE (SUBSTRING(rik2.akat FROM 2) = '$avdSVE' OR SUBSTRING(rik2.akat FROM 2) = '$avdFIN' OR SUBSTRING(rik2.akat FROM 2) = '$avdSAM') AND socken1.ahrd LIKE '$harad' AND socken1.anum = rik2.akod AND rik2.alok LIKE '$lokal' AND rik2.atol LIKE '1' LIMIT $fran,$antal;"; $sqlA = "SELECT * FROM rik2,socken1 WHERE (SUBSTRING(rik2.akat FROM 2) = '$avdSVE' OR SUBSTRING(rik2.akat FROM 2) = '$avdFIN' OR SUBSTRING(rik2.akat FROM 2) = '$avdSAM') AND socken1.ahrd LIKE '$harad' AND socken1.anum = rik2.akod AND rik2.alok LIKE '$lokal' LIMIT $fran,$antal;"; $sqlB = "SELECT * FROM rik2,socken1 WHERE (SUBSTRING(rik2.akat FROM 2) = '$avdSVE' OR SUBSTRING(rik2.akat FROM 2) = '$avdFIN' OR SUBSTRING(rik2.akat FROM 2) = '$avdSAM') AND socken1.ahrd LIKE '$harad' AND socken1.anum = rik2.akod AND rik2.asok LIKE '$rubrik' AND rik2.alok LIKE '$lokal' AND rik2.atol LIKE '1' LIMIT $fran,$antal;"; $sqlC = "SELECT * FROM rik2,socken1 WHERE (SUBSTRING(rik2.akat FROM 2) = '$avdSVE' OR SUBSTRING(rik2.akat FROM 2) = '$avdFIN' OR SUBSTRING(rik2.akat FROM 2) = '$avdSAM') AND socken1.ahrd LIKE '$harad' AND socken1.anum = rik2.akod AND rik2.asok LIKE '$rubrik' AND rik2.alok LIKE '$lokal' LIMIT $fran,$antal;"; } if ($sprak == "sve") { $sql1 = "SELECT * FROM rik2 WHERE SUBSTRING(rik2.akat FROM 2) = '$avd' AND (rik2.aurv LIKE '1' OR rik2.aurv LIKE '3') AND rik2.alok LIKE '$lokal' AND rik2.atol LIKE '1' LIMIT $fran,$antal;"; $sql2 = "SELECT * FROM rik2 WHERE SUBSTRING(rik2.akat FROM 2) = '$avd' AND (rik2.aurv LIKE '1' OR rik2.aurv LIKE '3') AND rik2.alok LIKE '$lokal' LIMIT $fran,$antal;"; $sql3 = "SELECT * FROM rik2 WHERE SUBSTRING(rik2.akat FROM 2) = '$avd' AND (rik2.aurv LIKE '1' OR rik2.aurv LIKE '3') AND rik2.asok LIKE '$rubrik' AND rik2.alok LIKE '$lokal' AND rik2.atol LIKE '1' LIMIT $fran,$antal;"; $sql4 = "SELECT * FROM rik2 WHERE SUBSTRING(rik2.akat FROM 2) = '$avd' AND (rik2.aurv LIKE '1' OR rik2.aurv LIKE '3') AND rik2.asok LIKE '$rubrik' AND rik2.alok LIKE '$lokal' LIMIT $fran,$antal;"; $sql5 = "SELECT * FROM rik2,socken1 WHERE SUBSTRING(rik2.akat FROM 2) = '$avd' AND (rik2.aurv LIKE '1' OR rik2.aurv LIKE '3') AND socken1.aort LIKE '$socken' AND socken1.anum = rik2.akod AND rik2.alok LIKE '$lokal' AND rik2.atol LIKE '1' LIMIT $fran,$antal;"; $sql6 = "SELECT * FROM rik2,socken1 WHERE SUBSTRING(rik2.akat FROM 2) = '$avd' AND (rik2.aurv LIKE '1' OR rik2.aurv LIKE '3') AND socken1.aort LIKE '$socken' AND socken1.anum = rik2.akod AND rik2.alok LIKE '$lokal' LIMIT $fran,$antal;"; $sql7 = "SELECT * FROM rik2,socken1 WHERE SUBSTRING(rik2.akat FROM 2) = '$avd' AND (rik2.aurv LIKE '1' OR rik2.aurv LIKE '3') AND socken1.aort LIKE '$socken' AND socken1.anum = rik2.akod AND rik2.asok LIKE '$rubrik'AND rik2.alok LIKE '$lokal' AND rik2.atol = '1' LIMIT $fran,$antal;"; $sql8 = "SELECT * FROM rik2,socken1 WHERE SUBSTRING(rik2.akat FROM 2) = '$avd' AND (rik2.aurv LIKE '1' OR rik2.aurv LIKE '3') AND socken1.aort LIKE '$socken' AND socken1.anum = rik2.akod AND rik2.asok LIKE '$rubrik' AND rik2.alok LIKE '$lokal' LIMIT $fran,$antal;"; $sql9 = "SELECT * FROM rik2,socken1 WHERE SUBSTRING(rik2.akat FROM 2) = '$avd' AND (rik2.aurv LIKE '1' OR rik2.aurv LIKE '3') AND socken1.ahrd LIKE '$harad' AND socken1.anum = rik2.akod AND rik2.alok LIKE '$lokal' AND rik2.atol LIKE '1' LIMIT $fran,$antal;"; $sqlA = "SELECT * FROM rik2,socken1 WHERE SUBSTRING(rik2.akat FROM 2) = '$avd' AND (rik2.aurv LIKE '1' OR rik2.aurv LIKE '3') AND socken1.ahrd LIKE '$harad' AND socken1.anum = rik2.akod AND rik2.alok LIKE '$lokal' LIMIT $fran,$antal;"; $sqlB = "SELECT * FROM rik2,socken1 WHERE SUBSTRING(rik2.akat FROM 2) = '$avd' AND (rik2.aurv LIKE '1' OR rik2.aurv LIKE '3') AND socken1.ahrd LIKE '$harad' AND socken1.anum = rik2.akod AND rik2.asok LIKE '$rubrik' AND rik2.alok LIKE '$lokal' AND rik2.atol LIKE '1' LIMIT $fran,$antal;"; $sqlC = "SELECT * FROM rik2,socken1 WHERE SUBSTRING(rik2.akat FROM 2) = '$avd' AND (rik2.aurv LIKE '1' OR rik2.aurv LIKE '3') AND socken1.ahrd LIKE '$harad' AND socken1.anum = rik2.akod AND rik2.asok LIKE '$rubrik' AND rik2.alok LIKE '$lokal' LIMIT $fran,$antal;"; } if ($sprak == "fin") { $sql1 = "SELECT * FROM rik2 WHERE SUBSTRING(rik2.akat FROM 2) = '$avd' AND (rik2.aurv LIKE '5' OR rik2.aurv LIKE '7') AND rik2.alok LIKE '$lokal' AND rik2.atol LIKE '1' LIMIT $fran,$antal;"; $sql2 = "SELECT * FROM rik2 WHERE SUBSTRING(rik2.akat FROM 2) = '$avd' AND (rik2.aurv LIKE '5' OR rik2.aurv LIKE '7') AND rik2.alok LIKE '$lokal' LIMIT $fran,$antal;"; $sql3 = "SELECT * FROM rik2 WHERE SUBSTRING(rik2.akat FROM 2) = '$avd' AND (rik2.aurv LIKE '5' OR rik2.aurv LIKE '7') AND rik2.asok LIKE '$rubrik' AND rik2.alok LIKE '$lokal' AND rik2.atol LIKE '1' LIMIT $fran,$antal;"; $sql4 = "SELECT * FROM rik2 WHERE SUBSTRING(rik2.akat FROM 2) = '$avd' AND (rik2.aurv LIKE '5' OR rik2.aurv LIKE '7') AND rik2.asok LIKE '$rubrik' AND rik2.alok LIKE '$lokal' LIMIT $fran,$antal;"; $sql5 = "SELECT * FROM rik2,socken1 WHERE SUBSTRING(rik2.akat FROM 2) = '$avd' AND (rik2.aurv LIKE '5' OR rik2.aurv LIKE '7') AND socken1.aort LIKE '$socken' AND socken1.anum = rik2.akod AND rik2.alok LIKE '$lokal' AND rik2.atol LIKE '1' LIMIT $fran,$antal;"; $sql6 = "SELECT * FROM rik2,socken1 WHERE SUBSTRING(rik2.akat FROM 2) = '$avd' AND (rik2.aurv LIKE '5' OR rik2.aurv LIKE '7') AND socken1.aort LIKE '$socken' AND socken1.anum = rik2.akod AND rik2.alok LIKE '$lokal' LIMIT $fran,$antal;"; $sql7 = "SELECT * FROM rik2,socken1 WHERE SUBSTRING(rik2.akat FROM 2) = '$avd' AND (rik2.aurv LIKE '5' OR rik2.aurv LIKE '7') AND socken1.aort LIKE '$socken' AND socken1.anum = rik2.akod AND rik2.asok LIKE '$rubrik'AND rik2.alok LIKE '$lokal' AND rik2.atol = '1' LIMIT $fran,$antal;"; $sql8 = "SELECT * FROM rik2,socken1 WHERE SUBSTRING(rik2.akat FROM 2) = '$avd' AND (rik2.aurv LIKE '5' OR rik2.aurv LIKE '7') AND socken1.aort LIKE '$socken' AND socken1.anum = rik2.akod AND rik2.asok LIKE '$rubrik' AND rik2.alok LIKE '$lokal' LIMIT $fran,$antal;"; $sql9 = "SELECT * FROM rik2,socken1 WHERE SUBSTRING(rik2.akat FROM 2) = '$avd' AND (rik2.aurv LIKE '5' OR rik2.aurv LIKE '7') AND socken1.ahrd LIKE '$harad' AND socken1.anum = rik2.akod AND rik2.alok LIKE '$lokal' AND rik2.atol LIKE '1' LIMIT $fran,$antal;"; $sqlA = "SELECT * FROM rik2,socken1 WHERE SUBSTRING(rik2.akat FROM 2) = '$avd' AND (rik2.aurv LIKE '5' OR rik2.aurv LIKE '7') AND socken1.ahrd LIKE '$harad' AND socken1.anum = rik2.akod AND rik2.alok LIKE '$lokal' LIMIT $fran,$antal;"; $sqlB = "SELECT * FROM rik2,socken1 WHERE SUBSTRING(rik2.akat FROM 2) = '$avd' AND (rik2.aurv LIKE '5' OR rik2.aurv LIKE '7') AND socken1.ahrd LIKE '$harad' AND socken1.anum = rik2.akod AND rik2.asok LIKE '$rubrik' AND rik2.alok LIKE '$lokal' AND rik2.atol LIKE '1' LIMIT $fran,$antal;"; $sqlC = "SELECT * FROM rik2,socken1 WHERE SUBSTRING(rik2.akat FROM 2) = '$avd' AND (rik2.aurv LIKE '5' OR rik2.aurv LIKE '7') AND socken1.ahrd LIKE '$harad' AND socken1.anum = rik2.akod AND rik2.asok LIKE '$rubrik' AND rik2.alok LIKE '$lokal' LIMIT $fran,$antal;"; } if ($sprak == "sam") { $sql1 = "SELECT * FROM rik2 WHERE SUBSTRING(rik2.akat FROM 2) = '$avd' AND (rik2.aurv LIKE 'a' OR rik2.aurv LIKE 'c') AND rik2.alok LIKE '$lokal' AND rik2.atol LIKE '1' LIMIT $fran,$antal;"; $sql2 = "SELECT * FROM rik2 WHERE SUBSTRING(rik2.akat FROM 2) = '$avd' AND (rik2.aurv LIKE 'a' OR rik2.aurv LIKE 'c') AND rik2.alok LIKE '$lokal' LIMIT $fran,$antal;"; $sql3 = "SELECT * FROM rik2 WHERE SUBSTRING(rik2.akat FROM 2) = '$avd' AND (rik2.aurv LIKE 'a' OR rik2.aurv LIKE 'c') AND rik2.asok LIKE '$rubrik' AND rik2.alok LIKE '$lokal' AND rik2.atol LIKE '1' LIMIT $fran,$antal;"; $sql4 = "SELECT * FROM rik2 WHERE SUBSTRING(rik2.akat FROM 2) = '$avd' AND (rik2.aurv LIKE 'a' OR rik2.aurv LIKE 'c') AND rik2.asok LIKE '$rubrik' AND rik2.alok LIKE '$lokal' LIMIT $fran,$antal;"; $sql5 = "SELECT * FROM rik2,socken1 WHERE SUBSTRING(rik2.akat FROM 2) = '$avd' AND (rik2.aurv LIKE 'a' OR rik2.aurv LIKE 'c') AND socken1.aort LIKE '$socken' AND socken1.anum = rik2.akod AND rik2.alok LIKE '$lokal' AND rik2.atol LIKE '1' LIMIT $fran,$antal;"; $sql6 = "SELECT * FROM rik2,socken1 WHERE SUBSTRING(rik2.akat FROM 2) = '$avd' AND (rik2.aurv LIKE 'a' OR rik2.aurv LIKE 'c') AND socken1.aort LIKE '$socken' AND socken1.anum = rik2.akod AND rik2.alok LIKE '$lokal' LIMIT $fran,$antal;"; $sql7 = "SELECT * FROM rik2,socken1 WHERE SUBSTRING(rik2.akat FROM 2) = '$avd' AND (rik2.aurv LIKE 'a' OR rik2.aurv LIKE 'c') AND socken1.aort LIKE '$socken' AND socken1.anum = rik2.akod AND rik2.asok LIKE '$rubrik'AND rik2.alok LIKE '$lokal' AND rik2.atol = '1' LIMIT $fran,$antal;"; $sql8 = "SELECT * FROM rik2,socken1 WHERE SUBSTRING(rik2.akat FROM 2) = '$avd' AND (rik2.aurv LIKE 'a' OR rik2.aurv LIKE 'c') AND socken1.aort LIKE '$socken' AND socken1.anum = rik2.akod AND rik2.asok LIKE '$rubrik' AND rik2.alok LIKE '$lokal' LIMIT $fran,$antal;"; $sql9 = "SELECT * FROM rik2,socken1 WHERE SUBSTRING(rik2.akat FROM 2) = '$avd' AND (rik2.aurv LIKE 'a' OR rik2.aurv LIKE 'c') AND socken1.ahrd LIKE '$harad' AND socken1.anum = rik2.akod AND rik2.alok LIKE '$lokal' AND rik2.atol LIKE '1' LIMIT $fran,$antal;"; $sqlA = "SELECT * FROM rik2,socken1 WHERE SUBSTRING(rik2.akat FROM 2) = '$avd' AND (rik2.aurv LIKE 'a' OR rik2.aurv LIKE 'c') AND socken1.ahrd LIKE '$harad' AND socken1.anum = rik2.akod AND rik2.alok LIKE '$lokal' LIMIT $fran,$antal;"; $sqlB = "SELECT * FROM rik2,socken1 WHERE SUBSTRING(rik2.akat FROM 2) = '$avd' AND (rik2.aurv LIKE 'a' OR rik2.aurv LIKE 'c') AND socken1.ahrd LIKE '$harad' AND socken1.anum = rik2.akod AND rik2.asok LIKE '$rubrik' AND rik2.alok LIKE '$lokal' AND rik2.atol LIKE '1' LIMIT $fran,$antal;"; $sqlC = "SELECT * FROM rik2,socken1 WHERE SUBSTRING(rik2.akat FROM 2) = '$avd' AND (rik2.aurv LIKE 'a' OR rik2.aurv LIKE 'c') AND socken1.ahrd LIKE '$harad' AND socken1.anum = rik2.akod AND rik2.asok LIKE '$rubrik' AND rik2.alok LIKE '$lokal' LIMIT $fran,$antal;"; } if ($socken == "%Hela riket%") { if ($rubrik == "") { if ($etym == true) { $result = mysql_query($sql1); if (!$result) { echo("

Error performing query: " . mysql_error() . "

"); exit(); } }else{ $result = mysql_query($sql2); if (!$result) { echo("

Error performing query: " . mysql_error() . "

"); exit(); } } }else{ //rubrik har värde if ($etym == true) { $result = mysql_query($sql3); if (!$result) { echo("

Error performing query: " . mysql_error() . "

"); exit(); } }else{ $result = mysql_query($sql4); if (!$result) { echo("

Error performing query: " . mysql_error() . "

"); exit(); } } } }else{ //if socken <> "%Hela riket%" if ($harad == "") { if ($rubrik == "") { if ($etym == true) { $result = mysql_query($sql5); if (!$result) { echo("

Error performing query: " . mysql_error() . "

"); exit(); } }else{ $result = mysql_query($sql6); if (!$result) { echo("

Error performing query: " . mysql_error() . "

"); exit(); } } }else{ //rubrik has value if ($etym == true) { $result = mysql_query($sql7); if (!$result) { echo("

Error performing query: " . mysql_error() . "

"); exit(); } }else{ $result = mysql_query($sql8); if (!$result) { echo("

Error performing query: " . mysql_error() . "

"); exit(); } } } }else{ //if harad <> "" if ($rubrik == "") { if ($etym == true) { $result = mysql_query($sql9); if (!$result) { echo("

Error performing query: " . mysql_error() . "

"); exit(); } }else{ $result = mysql_query($sqlA); if (!$result) { echo("

Error performing query: " . mysql_error() . "

"); exit(); } } }else{ //rubrik has value if ($etym == true) { $result = mysql_query($sqlB); if (!$result) { echo("

Error performing query: " . mysql_error() . "

"); exit(); } }else{ $result = mysql_query($sqlC); if (!$result) { echo("

Error performing query: " . mysql_error() . "

"); exit(); } } } } //if harad = "" } //ends if socken = "%Hela riket%" } //ends if avdnr = 0 // ############################################################################################################ ?> $antal) { $sum = $fran + $antal; }else{ $sum = $num_rows; } $franx = $fran + 1; if ($sum > $total) { $sum = $total; } if ($sum == 0) { $franx = 0; } $sidan = ceil($sum / TABELL_LEN); $sidor = ceil($total / $antal); ?> $strAlan, "akod_" => $strAkod, "aurv_" => $strAurv, "akat_" => $strAkat, "adok_" => $strAdok, "asok_" => $strAsok, "arub_" => $strArub, "alok_" => $strAlok, "atol_" => $strAtol, "abel_" => $strAbel, "apub_" => $strApub ); */ $varde[$i] = $strAsok . ";" . $strArub . ";" . $sockenArr[1] . ";" . $sockenArr[2] . ";" . $sockenArr[3] . ";" . $strAlok . ";" . $strAtol . ";" . $strAbel . ";" . $strApub . ";" . $bild_hela_adress . ";" . $html_sida_pekare; $i++; } ?>
1) { $x = ($j - 1) * $antal; }else{ $x = 0; } if ($j == 1) { $xbw = $fran - TABELL_LEN; if ($xbw < 0) { $xbw = 0; } echo ""; echo ''; echo "<<"; } } ?> $total svar (nr $franx..$sum) sida $sidan($sidor)\n"; ?> 1) { $x = ($j - 1) * $antal; }else{ $x = 0; } if ($j == $sidor) { $xfw = $fran + TABELL_LEN; if ($xfw > ($sidor - 1) * TABELL_LEN) { $xfw = ($sidor - 1) * TABELL_LEN; } echo ""; echo ''; echo ">>"; } } ?>
 %s
", "Antal rader: " . $i . "
"); if ($varde[0] != "") { // setlocale(LC_ALL, 'Swedish'); setlocale(LC_ALL, 'swedish', 'sv_SE', 'sv_SE.ISO8859-1'); usort($varde,'strcoll'); // sort($varde,SORT_STRING); } $j = 0; while ( $j < $i ) { $pizza = $varde[$j]; $pieces = explode(";", $pizza); // printf(" %s
", $varde[$j]); // printf(" %s
", $pieces[1]); $strAsok = $pieces[0]; $strArub = $pieces[1]; $strAsoc = $pieces[2]; $strAhrd = $pieces[3]; $strAlfk = $pieces[4]; $strAlok = $pieces[5]; $strAtol = $pieces[6]; $strAbel = $pieces[7]; $strApub = $pieces[8]; $bild_hela_adress = $pieces[9]; $html_sida_pekare = $pieces[10]; printf(""); // printf(""); printf(""); printf(""); if (empty($strAsoc)) { printf("", "---"); }else{ printf("", $strAsoc); } if (empty($strAhrd)) { printf("", "---"); }else{ printf("", $strAhrd); } if (empty($strAlfk)) { printf("", "---"); }else{ printf("", $strAlfk); } printf("%s", ""); printf("%s", ""); printf("%s", ""); printf("%s\n", ""); $j++; } ?>
Nr Ortnamn Lokal Socken Härad Län Beläggsår Tolkning Tabell
%s",$j+1 . "  %s","$strAsok %s","$strArub %s","$strAlok%s %s%s %s%s%s%s", $strAbel); printf(" %s", $strAtol); printf("  %s", " "); printf("&>
$antal):?>
1) { $x = ($j - 1) * $antal; }else{ $x = 0; } if ($j == 1) { $xbw = $fran - TABELL_LEN; if ($xbw < 0) { $xbw = 0; } echo ""; echo ''; echo "<< "; } if ($sidan == $j) { echo "$j"; }else{ echo "$j"; } if ($j < $sidor) echo ", "; if ($j == $sidor) { $xfw = $fran + TABELL_LEN; if ($xfw > ($sidor - 1) * TABELL_LEN) { $xfw = ($sidor - 1) * TABELL_LEN; } echo " "; echo ''; echo ">>"; } } ?>

 ^