< space XXX space LÄN > $sockenort = "%"; $haradort = "%"; $landskap = "%"; } if ($sockenort != "%") { // $haradort = "%"; // $lanort = "%"; // $landskap = "%"; } if ($haradort != "%") { // $lanort = "%"; // $landskap = "%"; } if (empty($belaggartal)) $belaggartal = "%"; if (empty($pubdatum)) $pubdatum = "%"; if (empty($etym)): $etym = false; endif; if (empty($alfasort)): $alfasort = false; endif; if (empty($avdnr)) $avdnr = "0"; if (empty($sprak)) $sprak = "alla"; if (empty($socken)) $socken = ""; if (empty($harad)) $harad = ""; //************************************************************************************************* if ($sprak == "alla") { $avdSVE = (int) $avdnr; // {0,1,2,3,4} $avdSVE = (string) $avdSVE; $avdFIN = (int) $avdnr; if ($avdFIN > 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); //################################################################################################# ?> getMessage(); } */ /* if ( isset($_REQUEST['formular']) ) { echo "setTimeout('setfocus2()',1);"; }else{ echo "setTimeout('setfocus1()',1);"; } */ @mysql_close($dbcnx); set_time_limit(0); $dbcnx = @mysql_connect("loopback", "soresigv", "Dox.rint") or die("Unable to connect to the placenames database at this time."); @mysql_select_db("ortnamndb") or die("Selection impossible at this time."); if ( isset($_REQUEST['formular']) ) { echo "setTimeout('setfocus2()',1);"; }else{ echo "setTimeout('setfocus1()',1);"; } ?> >
ORTNAMNSREGISTRET
© Institutet för språk och folkminnen

Sök i hela Ortnamnsregistret  
Till registrets startsida
Sök på 
Ortnamn (uteslut i Ortnamn )
Lokal (uteslut i Lokal       )
Socken  
Härad  
Län  
Landskap  
Land/område  

Bebyggelse- och naturnamn '); printf(''); printf(''); printf(''); printf(''); }else{ $elementsRadio2 = array( array('name' => 'Bebyggelse- och naturnamn ', 'value' => '0'), array('name' => 'Bebyggelsenamn ', 'value' => '1'), array('name' => 'Naturnamn ', 'value' => '2'), array('name' => 'Bebyggelsenamn ', 'value' => '3'), array('name' => 'Naturnamn ', '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 

' Ordna sidnummer alfabetiskt  (Obs: kan ta tid!)', 'value' => 'e') ); foreach ($elementsCheckAlfasort as $element) { printf('%s', $element['value'], (isset($_REQUEST['alfasort']) and $_REQUEST['alfasort'] == $element['value']) ? 'checked="checked"' : '', $element['name']); } */ ?>
' 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:  med % menas vilket antal tecken som helst och med understreck( _ ) ett enskilt tecken utelämnat.  Önskas uteslutning av ett/flera tecken använd uteslut-textrutorna.
"; $letter = array(); $total = 0; for ($j=0;$j<29;$j++){ //for ($j=0;$j<7;$j++){ if ($j < 26) { $bokst = chr(ord('A')+$j) . "%"; }else{ switch ($j) { case 26: $bokst = "Å%"; break; case 27: $bokst = "Ä%"; break; case 28: $bokst = "Ö%"; break; } } if ($avdnr == "0") { if ($sprak == "alla") { $sql1 = "SELECT * FROM nau_ortnamn WHERE asok LIKE '$rubrik' AND alok LIKE '$lokal' AND aort LIKE '$sockenort' AND ahrd LIKE '$haradort' AND alfk LIKE '$lanort' AND alkp LIKE '$landskap' AND aomr LIKE '$landomrade' AND abea LIKE '$belaggartal' AND apub LIKE '$pubdatum' AND atol LIKE '1' AND LEFT(asok,1) LIKE '$bokst';"; $sql2 = "SELECT * FROM nau_ortnamn WHERE asok LIKE '$rubrik' AND alok LIKE '$lokal' AND aort LIKE '$sockenort' AND ahrd LIKE '$haradort' AND alfk LIKE '$lanort' AND alkp LIKE '$landskap' AND aomr LIKE '$landomrade' AND abea LIKE '$belaggartal' AND apub LIKE '$pubdatum' AND LEFT(asok,1) LIKE '$bokst';"; if ($nixrubrik != "") { $sql1 = "SELECT * FROM nau_ortnamn WHERE asok LIKE '$rubrik' AND asok NOT LIKE '$nixrubrik' AND alok LIKE '$lokal' AND aort LIKE '$sockenort' AND ahrd LIKE '$haradort' AND alfk LIKE '$lanort' AND alkp LIKE '$landskap' AND aomr LIKE '$landomrade' AND abea LIKE '$belaggartal' AND apub LIKE '$pubdatum' AND atol LIKE '1' AND LEFT(asok,1) LIKE '$bokst';"; $sql2 = "SELECT * FROM nau_ortnamn WHERE asok LIKE '$rubrik' AND asok NOT LIKE '$nixrubrik' AND alok LIKE '$lokal' AND aort LIKE '$sockenort' AND ahrd LIKE '$haradort' AND alfk LIKE '$lanort' AND alkp LIKE '$landskap' AND aomr LIKE '$landomrade' AND abea LIKE '$belaggartal' AND apub LIKE '$pubdatum' AND LEFT(asok,1) LIKE '$bokst';"; } } if ($sprak == "sve") { $sql1 = "SELECT * FROM nau_ortnamn WHERE (aurv LIKE '1' OR aurv LIKE '3') AND asok LIKE '$rubrik' AND alok LIKE '$lokal' AND aort LIKE '$sockenort' AND ahrd LIKE '$haradort' AND alfk LIKE '$lanort' AND alkp LIKE '$landskap' AND aomr LIKE '$landomrade' AND abea LIKE '$belaggartal' AND apub LIKE '$pubdatum' AND atol LIKE '1' AND LEFT(asok,1) LIKE '$bokst';"; $sql2 = "SELECT * FROM nau_ortnamn WHERE (aurv LIKE '1' OR aurv LIKE '3') AND asok LIKE '$rubrik' AND alok LIKE '$lokal' AND aort LIKE '$sockenort' AND ahrd LIKE '$haradort' AND alfk LIKE '$lanort' AND alkp LIKE '$landskap' AND aomr LIKE '$landomrade' AND abea LIKE '$belaggartal' AND apub LIKE '$pubdatum' AND LEFT(asok,1) LIKE '$bokst';"; } if ($sprak == "fin") { $sql1 = "SELECT * FROM nau_ortnamn WHERE (aurv LIKE '5' OR aurv LIKE '7') AND asok LIKE '$rubrik' AND alok LIKE '$lokal' AND aort LIKE '$sockenort' AND ahrd LIKE '$haradort' AND alfk LIKE '$lanort' AND alkp LIKE '$landskap' AND aomr LIKE '$landomrade' AND abea LIKE '$belaggartal' AND apub LIKE '$pubdatum' AND atol LIKE '1' AND LEFT(asok,1) LIKE '$bokst';"; $sql2 = "SELECT * FROM nau_ortnamn WHERE (aurv LIKE '5' OR aurv LIKE '7') AND asok LIKE '$rubrik' AND alok LIKE '$lokal' AND aort LIKE '$sockenort' AND ahrd LIKE '$haradort' AND alfk LIKE '$lanort' AND alkp LIKE '$landskap' AND aomr LIKE '$landomrade' AND abea LIKE '$belaggartal' AND apub LIKE '$pubdatum' AND LEFT(asok,1) LIKE '$bokst';"; } if ($sprak == "sam") { $sql1 = "SELECT * FROM nau_ortnamn WHERE (aurv LIKE 'a' OR aurv LIKE 'c') AND asok LIKE '$rubrik' AND alok LIKE '$lokal' AND aort LIKE '$sockenort' AND ahrd LIKE '$haradort' AND alfk LIKE '$lanort' AND alkp LIKE '$landskap' AND aomr LIKE '$landomrade' AND abea LIKE '$belaggartal' AND apub LIKE '$pubdatum' AND atol LIKE '1' AND LEFT(asok,1) LIKE '$bokst';"; $sql2 = "SELECT * FROM nau_ortnamn WHERE (aurv LIKE 'a' OR aurv LIKE 'c') AND asok LIKE '$rubrik' AND alok LIKE '$lokal' AND aort LIKE '$sockenort' AND ahrd LIKE '$haradort' AND alfk LIKE '$lanort' AND alkp LIKE '$landskap' AND aomr LIKE '$landomrade' AND abea LIKE '$belaggartal' AND apub LIKE '$pubdatum' AND LEFT(asok,1) LIKE '$bokst';"; } }else{ if ($sprak == "alla") { $sql1 = "SELECT * FROM nau_ortnamn WHERE (SUBSTRING(akat FROM 2) = '$avdSVE' OR SUBSTRING(akat FROM 2) = '$avdFIN' OR SUBSTRING(akat FROM 2) = '$avdSAM') AND asok LIKE '$rubrik' AND alok LIKE '$lokal' AND aort LIKE '$sockenort' AND ahrd LIKE '$haradort' AND alfk LIKE '$lanort' AND alkp LIKE '$landskap' AND aomr LIKE '$landomrade' AND abea LIKE '$belaggartal' AND apub LIKE '$pubdatum' AND atol LIKE '1' AND LEFT(asok,1) LIKE '$bokst';"; $sql2 = "SELECT * FROM nau_ortnamn WHERE (SUBSTRING(akat FROM 2) = '$avdSVE' OR SUBSTRING(akat FROM 2) = '$avdFIN' OR SUBSTRING(akat FROM 2) = '$avdSAM') AND asok LIKE '$rubrik' AND alok LIKE '$lokal' AND aort LIKE '$sockenort' AND ahrd LIKE '$haradort' AND alfk LIKE '$lanort' AND alkp LIKE '$landskap' AND aomr LIKE '$landomrade' AND abea LIKE '$belaggartal' AND apub LIKE '$pubdatum' AND LEFT(asok,1) LIKE '$bokst';"; } if ($sprak == "sve") { $sql1 = "SELECT * FROM nau_ortnamn WHERE SUBSTRING(akat FROM 2) = '$avd' AND (aurv LIKE '1' OR aurv LIKE '3') AND asok LIKE '$rubrik' AND alok LIKE '$lokal' AND aort LIKE '$sockenort' AND ahrd LIKE '$haradort' AND alfk LIKE '$lanort' AND alkp LIKE '$landskap' AND aomr LIKE '$landomrade' AND abea LIKE '$belaggartal' AND apub LIKE '$pubdatum' AND atol LIKE '1' AND LEFT(asok,1) LIKE '$bokst';"; $sql2 = "SELECT * FROM nau_ortnamn WHERE SUBSTRING(akat FROM 2) = '$avd' AND (aurv LIKE '1' OR aurv LIKE '3') AND asok LIKE '$rubrik' AND alok LIKE '$lokal' AND aort LIKE '$sockenort' AND ahrd LIKE '$haradort' AND alfk LIKE '$lanort' AND alkp LIKE '$landskap' AND aomr LIKE '$landomrade' AND abea LIKE '$belaggartal' AND apub LIKE '$pubdatum' AND LEFT(asok,1) LIKE '$bokst';"; } if ($sprak == "fin") { $sql1 = "SELECT * FROM nau_ortnamn WHERE SUBSTRING(akat FROM 2) = '$avd' AND (aurv LIKE '5' OR aurv LIKE '7') AND asok LIKE '$rubrik' AND alok LIKE '$lokal' AND aort LIKE '$sockenort' AND ahrd LIKE '$haradort' AND alfk LIKE '$lanort' AND alkp LIKE '$landskap' AND aomr LIKE '$landomrade' AND abea LIKE '$belaggartal' AND apub LIKE '$pubdatum' AND atol LIKE '1' AND LEFT(asok,1) LIKE '$bokst';"; $sql2 = "SELECT * FROM nau_ortnamn WHERE SUBSTRING(akat FROM 2) = '$avd' AND (aurv LIKE '5' OR aurv LIKE '7') AND asok LIKE '$rubrik' AND alok LIKE '$lokal' AND aort LIKE '$sockenort' AND ahrd LIKE '$haradort' AND alfk LIKE '$lanort' AND alkp LIKE '$landskap' AND aomr LIKE '$landomrade' AND abea LIKE '$belaggartal' AND apub LIKE '$pubdatum' AND LEFT(asok,1) LIKE '$bokst';"; } if ($sprak == "sam") { $sql1 = "SELECT * FROM nau_ortnamn WHERE SUBSTRING(akat FROM 2) = '$avd' AND (aurv LIKE 'a' OR aurv LIKE 'c') AND asok LIKE '$rubrik' AND alok LIKE '$lokal' AND aort LIKE '$sockenort' AND ahrd LIKE '$haradort' AND alfk LIKE '$lanort' AND alkp LIKE '$landskap' AND aomr LIKE '$landomrade' AND abea LIKE '$belaggartal' AND apub LIKE '$pubdatum' AND atol LIKE '1' AND LEFT(asok,1) LIKE '$bokst';"; $sql2 = "SELECT * FROM nau_ortnamn WHERE SUBSTRING(akat FROM 2) = '$avd' AND (aurv LIKE 'a' OR aurv LIKE 'c') AND asok LIKE '$rubrik' AND alok LIKE '$lokal' AND aort LIKE '$sockenort' AND ahrd LIKE '$haradort' AND alfk LIKE '$lanort' AND alkp LIKE '$landskap' AND aomr LIKE '$landomrade' AND abea LIKE '$belaggartal' AND apub LIKE '$pubdatum' AND LEFT(asok,1) LIKE '$bokst';"; } } // **************************************************************************************** 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(); } } $letter[$j] = mysql_num_rows($result); $total = $total + $letter[$j]; if ($j < 26) { echo chr(ord('A')+$j) . "=" . $letter[$j] .", "; }else{ switch ($j) { case 26: echo "Å=" . $letter[26] . ", "; break; case 27: echo "Ä=" . $letter[27] . ", "; break; case 28: echo "Ö=" . $letter[28] . "

"; break; } } } //end_of $j //##################################################################### $m=0; for ($k=0;$k<29;$k++){ $m = $m + $letter[$k]; } //echo "Summa: " . $m . "

"; $n=1; $m=0; $justera=0; $summarader=0; $sve=0; $svetkn = array('Å','Ä','Ö'); $teckenvad = array(); $teckensid = array(); $bokstavindex = 0; for ($k=0;$k<29;$k++){ if (($letter[$k] > 0)) { $summarader = $summarader + $letter[$k]; $m = $m + ceil($letter[$k]/TABELL_LEN); $justera = ceil($summarader/TABELL_LEN); if ($m > $justera){ $m = $justera; } //echo "
" . $m . "
"; //echo $justera . "
"; if ((chr(ord('A')+$k)<='Z')) { $teckenvad[$bokstavindex] = chr(ord('A')+$k); $teckensid[$bokstavindex] = $n; //echo $teckenvad[$bokstavindex] . "= " . $n . "-" . $m . "
"; $bokstavindex++; }else{ $teckenvad[$bokstavindex] = $svetkn[$sve]; $teckensid[$bokstavindex] = $n; //echo $teckenvad[$bokstavindex] . "= " . $n . "-" . $m . "
"; $bokstavindex++; $sve++; } $n = $m; } } //echo $summarader . "
"; //if ($n > floor(($summarader+$rest) / TABELL_LEN)){ // $teckensid[$bokstavindex-1]--; //} $teckensid[$bokstavindex] = -1; // ############################################################################################################ // slut här om alfabetisering // ££££££££££££££££££££££££££££££££££££££££££££££££££££££££££££££££££££££££££££££££££££££££££££££££££££££££££££ // ££££££££££££££££££££££££££££££££££££££££££££££££££££££££££££££££££££££££££££££££££££££££££££££££££££££££££££ // ££££££££££££££££££££££££££££££££££££££££££££££££££££££££££££££££££££££££££££££££££££££££££££££££££££££££££££ }else{ // if not alfasort if ($avdnr == "0") { if ($sprak == "alla") { $sql1 = "SELECT COUNT(*) AS alan FROM nau_ortnamn WHERE asok LIKE '$rubrik' AND alok LIKE '$lokal' AND aort LIKE '$sockenort' AND ahrd LIKE '$haradort' AND alfk LIKE '$lanort' AND alkp LIKE '$landskap' AND aomr LIKE '$landomrade' AND abea LIKE '$belaggartal' AND apub LIKE '$pubdatum' AND atol LIKE '1';"; $sql2 = "SELECT COUNT(*) AS alan FROM nau_ortnamn WHERE asok LIKE '$rubrik' AND alok LIKE '$lokal' AND aort LIKE '$sockenort' AND ahrd LIKE '$haradort' AND alfk LIKE '$lanort' AND alkp LIKE '$landskap' AND aomr LIKE '$landomrade' AND abea LIKE '$belaggartal' AND apub LIKE '$pubdatum';"; if ( strlen($nixrubrik . $nixlokal) > 0 ) { $sql1 = "SELECT COUNT(*) AS alan FROM nau_ortnamn WHERE asok LIKE '$rubrik' AND asok NOT LIKE '$nixrubrik' AND alok LIKE '$lokal' AND alok NOT LIKE '$nixlokal' AND aort LIKE '$sockenort' AND ahrd LIKE '$haradort' AND alfk LIKE '$lanort' AND alkp LIKE '$landskap' AND aomr LIKE '$landomrade' AND abea LIKE '$belaggartal' AND apub LIKE '$pubdatum' AND atol LIKE '1';"; $sql2 = "SELECT COUNT(*) AS alan FROM nau_ortnamn WHERE asok LIKE '$rubrik' AND asok NOT LIKE '$nixrubrik' AND alok LIKE '$lokal' AND alok NOT LIKE '$nixlokal' AND aort LIKE '$sockenort' AND ahrd LIKE '$haradort' AND alfk LIKE '$lanort' AND alkp LIKE '$landskap' AND aomr LIKE '$landomrade' AND abea LIKE '$belaggartal' AND apub LIKE '$pubdatum';"; } //$sql2 = "SELECT COUNT(*) FROM nau_ortnamn WHERE asok LIKE '%ik' AND asok NOT LIKE '%vik';"; } if ($sprak == "sve") { $sql1 = "SELECT COUNT(*) AS alan FROM nau_ortnamn WHERE (aurv LIKE '1' OR aurv LIKE '3') AND asok LIKE '$rubrik' AND alok LIKE '$lokal' AND aort LIKE '$sockenort' AND ahrd LIKE '$haradort' AND alfk LIKE '$lanort' AND alkp LIKE '$landskap' AND aomr LIKE '$landomrade' AND abea LIKE '$belaggartal' AND apub LIKE '$pubdatum' AND atol LIKE '1';"; $sql2 = "SELECT COUNT(*) AS alan FROM nau_ortnamn WHERE (aurv LIKE '1' OR aurv LIKE '3') AND asok LIKE '$rubrik' AND alok LIKE '$lokal' AND aort LIKE '$sockenort' AND ahrd LIKE '$haradort' AND alfk LIKE '$lanort' AND alkp LIKE '$landskap' AND aomr LIKE '$landomrade' AND abea LIKE '$belaggartal' AND apub LIKE '$pubdatum';"; if ( strlen($nixrubrik . $nixlokal) > 0 ) { $sql1 = "SELECT COUNT(*) AS alan FROM nau_ortnamn WHERE (aurv LIKE '1' OR aurv LIKE '3') AND asok LIKE '$rubrik' AND asok NOT LIKE '$nixrubrik' AND alok LIKE '$lokal' AND alok NOT LIKE '$nixlokal' AND aort LIKE '$sockenort' AND ahrd LIKE '$haradort' AND alfk LIKE '$lanort' AND alkp LIKE '$landskap' AND aomr LIKE '$landomrade' AND abea LIKE '$belaggartal' AND apub LIKE '$pubdatum' AND atol LIKE '1';"; $sql2 = "SELECT COUNT(*) AS alan FROM nau_ortnamn WHERE (aurv LIKE '1' OR aurv LIKE '3') AND asok LIKE '$rubrik' AND asok NOT LIKE '$nixrubrik' AND alok LIKE '$lokal' AND alok NOT LIKE '$nixlokal' AND aort LIKE '$sockenort' AND ahrd LIKE '$haradort' AND alfk LIKE '$lanort' AND alkp LIKE '$landskap' AND aomr LIKE '$landomrade' AND abea LIKE '$belaggartal' AND apub LIKE '$pubdatum';"; } } if ($sprak == "fin") { $sql1 = "SELECT COUNT(*) AS alan FROM nau_ortnamn WHERE (aurv LIKE '5' OR aurv LIKE '7') AND asok LIKE '$rubrik' AND alok LIKE '$lokal' AND aort LIKE '$sockenort' AND ahrd LIKE '$haradort' AND alfk LIKE '$lanort' AND alkp LIKE '$landskap' AND aomr LIKE '$landomrade' AND abea LIKE '$belaggartal' AND apub LIKE '$pubdatum' AND atol LIKE '1';"; $sql2 = "SELECT COUNT(*) AS alan FROM nau_ortnamn WHERE (aurv LIKE '5' OR aurv LIKE '7') AND asok LIKE '$rubrik' AND alok LIKE '$lokal' AND aort LIKE '$sockenort' AND ahrd LIKE '$haradort' AND alfk LIKE '$lanort' AND alkp LIKE '$landskap' AND aomr LIKE '$landomrade' AND abea LIKE '$belaggartal' AND apub LIKE '$pubdatum';"; if ( strlen($nixrubrik . $nixlokal) > 0 ) { $sql1 = "SELECT COUNT(*) AS alan FROM nau_ortnamn WHERE (aurv LIKE '5' OR aurv LIKE '7') AND asok LIKE '$rubrik' AND asok NOT LIKE '$nixrubrik' AND alok LIKE '$lokal' AND alok NOT LIKE '$nixlokal' AND aort LIKE '$sockenort' AND ahrd LIKE '$haradort' AND alfk LIKE '$lanort' AND alkp LIKE '$landskap' AND aomr LIKE '$landomrade' AND abea LIKE '$belaggartal' AND apub LIKE '$pubdatum' AND atol LIKE '1';"; $sql2 = "SELECT COUNT(*) AS alan FROM nau_ortnamn WHERE (aurv LIKE '5' OR aurv LIKE '7') AND asok LIKE '$rubrik' AND asok NOT LIKE '$nixrubrik' AND alok LIKE '$lokal' AND alok NOT LIKE '$nixlokal' AND aort LIKE '$sockenort' AND ahrd LIKE '$haradort' AND alfk LIKE '$lanort' AND alkp LIKE '$landskap' AND aomr LIKE '$landomrade' AND abea LIKE '$belaggartal' AND apub LIKE '$pubdatum';"; } } if ($sprak == "sam") { $sql1 = "SELECT COUNT(*) AS alan FROM nau_ortnamn WHERE (aurv LIKE 'a' OR aurv LIKE 'c') AND asok LIKE '$rubrik' AND alok LIKE '$lokal' AND aort LIKE '$sockenort' AND ahrd LIKE '$haradort' AND alfk LIKE '$lanort' AND alkp LIKE '$landskap' AND aomr LIKE '$landomrade' AND abea LIKE '$belaggartal' AND apub LIKE '$pubdatum' AND atol LIKE '1';"; $sql2 = "SELECT COUNT(*) AS alan FROM nau_ortnamn WHERE (aurv LIKE 'a' OR aurv LIKE 'c') AND asok LIKE '$rubrik' AND alok LIKE '$lokal' AND aort LIKE '$sockenort' AND ahrd LIKE '$haradort' AND alfk LIKE '$lanort' AND alkp LIKE '$landskap' AND aomr LIKE '$landomrade' AND abea LIKE '$belaggartal' AND apub LIKE '$pubdatum';"; if ( strlen($nixrubrik . $nixlokal) > 0 ) { $sql1 = "SELECT COUNT(*) AS alan FROM nau_ortnamn WHERE (aurv LIKE 'a' OR aurv LIKE 'c') AND asok LIKE '$rubrik' AND asok NOT LIKE '$nixrubrik' AND alok LIKE '$lokal' AND alok NOT LIKE '$nixlokal' AND aort LIKE '$sockenort' AND ahrd LIKE '$haradort' AND alfk LIKE '$lanort' AND alkp LIKE '$landskap' AND aomr LIKE '$landomrade' AND abea LIKE '$belaggartal' AND apub LIKE '$pubdatum' AND atol LIKE '1';"; $sql2 = "SELECT COUNT(*) AS alan FROM nau_ortnamn WHERE (aurv LIKE 'a' OR aurv LIKE 'c') AND asok LIKE '$rubrik' AND asok NOT LIKE '$nixrubrik' AND alok LIKE '$lokal' AND alok NOT LIKE '$nixlokal' AND aort LIKE '$sockenort' AND ahrd LIKE '$haradort' AND alfk LIKE '$lanort' AND alkp LIKE '$landskap' AND aomr LIKE '$landomrade' AND abea LIKE '$belaggartal' AND apub LIKE '$pubdatum';"; } } }else{ if ($sprak == "alla") { $sql1 = "SELECT COUNT(*) AS alan FROM nau_ortnamn WHERE (SUBSTRING(akat FROM 2) = '$avdSVE' OR SUBSTRING(akat FROM 2) = '$avdFIN' OR SUBSTRING(akat FROM 2) = '$avdSAM') AND asok LIKE '$rubrik' AND alok LIKE '$lokal' AND aort LIKE '$sockenort' AND ahrd LIKE '$haradort' AND alfk LIKE '$lanort' AND alkp LIKE '$landskap' AND aomr LIKE '$landomrade' AND abea LIKE '$belaggartal' AND apub LIKE '$pubdatum' AND atol LIKE '1';"; $sql2 = "SELECT COUNT(*) AS alan FROM nau_ortnamn WHERE (SUBSTRING(akat FROM 2) = '$avdSVE' OR SUBSTRING(akat FROM 2) = '$avdFIN' OR SUBSTRING(akat FROM 2) = '$avdSAM') AND asok LIKE '$rubrik' AND alok LIKE '$lokal' AND aort LIKE '$sockenort' AND ahrd LIKE '$haradort' AND alfk LIKE '$lanort' AND alkp LIKE '$landskap' AND aomr LIKE '$landomrade' AND abea LIKE '$belaggartal' AND apub LIKE '$pubdatum';"; if ( strlen($nixrubrik . $nixlokal) > 0 ) { $sql1 = "SELECT COUNT(*) AS alan FROM nau_ortnamn WHERE (SUBSTRING(akat FROM 2) = '$avdSVE' OR SUBSTRING(akat FROM 2) = '$avdFIN' OR SUBSTRING(akat FROM 2) = '$avdSAM') AND asok LIKE '$rubrik' AND asok NOT LIKE '$nixrubrik' AND alok LIKE '$lokal' AND alok NOT LIKE '$nixlokal' AND aort LIKE '$sockenort' AND ahrd LIKE '$haradort' AND alfk LIKE '$lanort' AND alkp LIKE '$landskap' AND aomr LIKE '$landomrade' AND abea LIKE '$belaggartal' AND apub LIKE '$pubdatum' AND atol LIKE '1';"; $sql2 = "SELECT COUNT(*) AS alan FROM nau_ortnamn WHERE (SUBSTRING(akat FROM 2) = '$avdSVE' OR SUBSTRING(akat FROM 2) = '$avdFIN' OR SUBSTRING(akat FROM 2) = '$avdSAM') AND asok LIKE '$rubrik' AND asok NOT LIKE '$nixrubrik' AND alok LIKE '$lokal' AND alok NOT LIKE '$nixlokal' AND aort LIKE '$sockenort' AND ahrd LIKE '$haradort' AND alfk LIKE '$lanort' AND alkp LIKE '$landskap' AND aomr LIKE '$landomrade' AND abea LIKE '$belaggartal' AND apub LIKE '$pubdatum';"; } } if ($sprak == "sve") { $sql1 = "SELECT COUNT(*) AS alan FROM nau_ortnamn WHERE SUBSTRING(akat FROM 2) = '$avd' AND (aurv LIKE '1' OR aurv LIKE '3') AND asok LIKE '$rubrik' AND alok LIKE '$lokal' AND aort LIKE '$sockenort' AND ahrd LIKE '$haradort' AND alfk LIKE '$lanort' AND alkp LIKE '$landskap' AND aomr LIKE '$landomrade' AND abea LIKE '$belaggartal' AND apub LIKE '$pubdatum' AND atol LIKE '1';"; $sql2 = "SELECT COUNT(*) AS alan FROM nau_ortnamn WHERE SUBSTRING(akat FROM 2) = '$avd' AND (aurv LIKE '1' OR aurv LIKE '3') AND asok LIKE '$rubrik' AND alok LIKE '$lokal' AND aort LIKE '$sockenort' AND ahrd LIKE '$haradort' AND alfk LIKE '$lanort' AND alkp LIKE '$landskap' AND aomr LIKE '$landomrade' AND abea LIKE '$belaggartal' AND apub LIKE '$pubdatum';"; if ( strlen($nixrubrik . $nixlokal) > 0 ) { $sql1 = "SELECT COUNT(*) AS alan FROM nau_ortnamn WHERE SUBSTRING(akat FROM 2) = '$avd' AND (aurv LIKE '1' OR aurv LIKE '3') AND asok LIKE '$rubrik' AND asok NOT LIKE '$nixrubrik' AND alok LIKE '$lokal' AND alok NOT LIKE '$nixlokal' AND aort LIKE '$sockenort' AND ahrd LIKE '$haradort' AND alfk LIKE '$lanort' AND alkp LIKE '$landskap' AND aomr LIKE '$landomrade' AND abea LIKE '$belaggartal' AND apub LIKE '$pubdatum' AND atol LIKE '1';"; $sql2 = "SELECT COUNT(*) AS alan FROM nau_ortnamn WHERE SUBSTRING(akat FROM 2) = '$avd' AND (aurv LIKE '1' OR aurv LIKE '3') AND asok LIKE '$rubrik' AND asok NOT LIKE '$nixrubrik' AND alok LIKE '$lokal' AND alok NOT LIKE '$nixlokal' AND aort LIKE '$sockenort' AND ahrd LIKE '$haradort' AND alfk LIKE '$lanort' AND alkp LIKE '$landskap' AND aomr LIKE '$landomrade' AND abea LIKE '$belaggartal' AND apub LIKE '$pubdatum';"; } } if ($sprak == "fin") { $sql1 = "SELECT COUNT(*) AS alan FROM nau_ortnamn WHERE SUBSTRING(akat FROM 2) = '$avd' AND (aurv LIKE '5' OR aurv LIKE '7') AND asok LIKE '$rubrik' AND alok LIKE '$lokal' AND aort LIKE '$sockenort' AND ahrd LIKE '$haradort' AND alfk LIKE '$lanort' AND alkp LIKE '$landskap' AND aomr LIKE '$landomrade' AND abea LIKE '$belaggartal' AND apub LIKE '$pubdatum' AND atol LIKE '1';"; $sql2 = "SELECT COUNT(*) AS alan FROM nau_ortnamn WHERE SUBSTRING(akat FROM 2) = '$avd' AND (aurv LIKE '5' OR aurv LIKE '7') AND asok LIKE '$rubrik' AND alok LIKE '$lokal' AND aort LIKE '$sockenort' AND ahrd LIKE '$haradort' AND alfk LIKE '$lanort' AND alkp LIKE '$landskap' AND aomr LIKE '$landomrade' AND abea LIKE '$belaggartal' AND apub LIKE '$pubdatum';"; if ( strlen($nixrubrik . $nixlokal) > 0 ) { $sql1 = "SELECT COUNT(*) AS alan FROM nau_ortnamn WHERE SUBSTRING(akat FROM 2) = '$avd' AND (aurv LIKE '5' OR aurv LIKE '7') AND asok LIKE '$rubrik' AND asok NOT LIKE '$nixrubrik' AND alok LIKE '$lokal' AND alok NOT LIKE '$nixlokal' AND aort LIKE '$sockenort' AND ahrd LIKE '$haradort' AND alfk LIKE '$lanort' AND alkp LIKE '$landskap' AND aomr LIKE '$landomrade' AND abea LIKE '$belaggartal' AND apub LIKE '$pubdatum' AND atol LIKE '1';"; $sql2 = "SELECT COUNT(*) AS alan FROM nau_ortnamn WHERE SUBSTRING(akat FROM 2) = '$avd' AND (aurv LIKE '5' OR aurv LIKE '7') AND asok LIKE '$rubrik' AND asok NOT LIKE '$nixrubrik' AND alok LIKE '$lokal' AND alok NOT LIKE '$nixlokal' AND aort LIKE '$sockenort' AND ahrd LIKE '$haradort' AND alfk LIKE '$lanort' AND alkp LIKE '$landskap' AND aomr LIKE '$landomrade' AND abea LIKE '$belaggartal' AND apub LIKE '$pubdatum';"; } } if ($sprak == "sam") { $sql1 = "SELECT COUNT(*) AS alan FROM nau_ortnamn WHERE SUBSTRING(akat FROM 2) = '$avd' AND (aurv LIKE 'a' OR aurv LIKE 'c') AND asok LIKE '$rubrik' AND alok LIKE '$lokal' AND aort LIKE '$sockenort' AND ahrd LIKE '$haradort' AND alfk LIKE '$lanort' AND alkp LIKE '$landskap' AND aomr LIKE '$landomrade' AND abea LIKE '$belaggartal' AND apub LIKE '$pubdatum' AND atol LIKE '1';"; $sql2 = "SELECT COUNT(*) AS alan FROM nau_ortnamn WHERE SUBSTRING(akat FROM 2) = '$avd' AND (aurv LIKE 'a' OR aurv LIKE 'c') AND asok LIKE '$rubrik' AND alok LIKE '$lokal' AND aort LIKE '$sockenort' AND ahrd LIKE '$haradort' AND alfk LIKE '$lanort' AND alkp LIKE '$landskap' AND aomr LIKE '$landomrade' AND abea LIKE '$belaggartal' AND apub LIKE '$pubdatum';"; if ( strlen($nixrubrik . $nixlokal) > 0 ) { $sql1 = "SELECT COUNT(*) AS alan FROM nau_ortnamn WHERE SUBSTRING(akat FROM 2) = '$avd' AND (aurv LIKE 'a' OR aurv LIKE 'c') AND asok LIKE '$rubrik' AND asok NOT LIKE '$nixrubrik' AND alok LIKE '$lokal' AND alok NOT LIKE '$nixlokal' AND aort LIKE '$sockenort' AND ahrd LIKE '$haradort' AND alfk LIKE '$lanort' AND alkp LIKE '$landskap' AND aomr LIKE '$landomrade' AND abea LIKE '$belaggartal' AND apub LIKE '$pubdatum' AND atol LIKE '1';"; $sql2 = "SELECT COUNT(*) AS alan FROM nau_ortnamn WHERE SUBSTRING(akat FROM 2) = '$avd' AND (aurv LIKE 'a' OR aurv LIKE 'c') AND asok LIKE '$rubrik' AND asok NOT LIKE '$nixrubrik' AND alok LIKE '$lokal' AND alok NOT LIKE '$nixlokal' AND aort LIKE '$sockenort' AND ahrd LIKE '$haradort' AND alfk LIKE '$lanort' AND alkp LIKE '$landskap' AND aomr LIKE '$landomrade' AND abea LIKE '$belaggartal' AND apub LIKE '$pubdatum';"; } } } 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(); } } $total = @mysql_result($result,0); } // if alfasort } //if empty total // ############################################################################################################ if ($avdnr == "0") { if ($sprak == "alla") { $sql1 = "SELECT * FROM nau_ortnamn WHERE asok LIKE '$rubrik' AND alok LIKE '$lokal' AND aort LIKE '$sockenort' AND ahrd LIKE '$haradort' AND alfk LIKE '$lanort' AND alkp LIKE '$landskap' AND aomr LIKE '$landomrade' AND abea LIKE '$belaggartal' AND apub LIKE '$pubdatum' AND atol LIKE '1' LIMIT $fran,$antal;"; $sql2 = "SELECT * FROM nau_ortnamn WHERE asok LIKE '$rubrik' AND alok LIKE '$lokal' AND aort LIKE '$sockenort' AND ahrd LIKE '$haradort' AND alfk LIKE '$lanort' AND alkp LIKE '$landskap' AND aomr LIKE '$landomrade' AND abea LIKE '$belaggartal' AND apub LIKE '$pubdatum' LIMIT $fran,$antal;"; if ( strlen($nixrubrik . $nixlokal) > 0 ) { $sql1 = "SELECT * FROM nau_ortnamn WHERE asok LIKE '$rubrik' AND asok NOT LIKE '$nixrubrik' AND alok LIKE '$lokal' AND alok NOT LIKE '$nixlokal' AND aort LIKE '$sockenort' AND ahrd LIKE '$haradort' AND alfk LIKE '$lanort' AND alkp LIKE '$landskap' AND aomr LIKE '$landomrade' AND abea LIKE '$belaggartal' AND apub LIKE '$pubdatum' AND atol LIKE '1' LIMIT $fran,$antal;"; $sql2 = "SELECT * FROM nau_ortnamn WHERE asok LIKE '$rubrik' AND asok NOT LIKE '$nixrubrik' AND alok LIKE '$lokal' AND alok NOT LIKE '$nixlokal' AND aort LIKE '$sockenort' AND ahrd LIKE '$haradort' AND alfk LIKE '$lanort' AND alkp LIKE '$landskap' AND aomr LIKE '$landomrade' AND abea LIKE '$belaggartal' AND apub LIKE '$pubdatum' LIMIT $fran,$antal;"; } //$sql2 = "SELECT * FROM nau_ortnamn WHERE asok LIKE '%ik' AND asok NOT LIKE '%vik';"; } if ($sprak == "sve") { $sql1 = "SELECT * FROM nau_ortnamn WHERE (aurv LIKE '1' OR aurv LIKE '3') AND asok LIKE '$rubrik' AND alok LIKE '$lokal' AND aort LIKE '$sockenort' AND ahrd LIKE '$haradort' AND alfk LIKE '$lanort' AND alkp LIKE '$landskap' AND aomr LIKE '$landomrade' AND abea LIKE '$belaggartal' AND apub LIKE '$pubdatum' AND atol LIKE '1' LIMIT $fran,$antal;"; $sql2 = "SELECT * FROM nau_ortnamn WHERE (aurv LIKE '1' OR aurv LIKE '3') AND asok LIKE '$rubrik' AND alok LIKE '$lokal' AND aort LIKE '$sockenort' AND ahrd LIKE '$haradort' AND alfk LIKE '$lanort' AND alkp LIKE '$landskap' AND aomr LIKE '$landomrade' AND abea LIKE '$belaggartal' AND apub LIKE '$pubdatum' LIMIT $fran,$antal;"; if ( strlen($nixrubrik . $nixlokal) > 0 ) { $sql1 = "SELECT * FROM nau_ortnamn WHERE (aurv LIKE '1' OR aurv LIKE '3') AND asok LIKE '$rubrik' AND asok NOT LIKE '$nixrubrik' AND alok LIKE '$lokal' AND alok NOT LIKE '$nixlokal' AND aort LIKE '$sockenort' AND ahrd LIKE '$haradort' AND alfk LIKE '$lanort' AND alkp LIKE '$landskap' AND aomr LIKE '$landomrade' AND abea LIKE '$belaggartal' AND apub LIKE '$pubdatum' AND atol LIKE '1' LIMIT $fran,$antal;"; // $sql2 = "SELECT * FROM nau_ortnamn WHERE (aurv LIKE '1' OR aurv LIKE '3') AND asok LIKE '$rubrik' AND asok NOT LIKE '$nixrubrik' AND alok LIKE '$lokal' AND alok NOT LIKE '$nixlokal' AND aort LIKE '$sockenort' AND ahrd LIKE '$haradort' AND alfk LIKE '$lanort' AND alkp LIKE '$landskap' AND aomr LIKE '$landomrade' AND abea LIKE '$belaggartal' AND apub LIKE '$pubdatum' LIMIT $fran,$antal;"; $sql2 = "SELECT * FROM nau_ortnamn WHERE (aurv LIKE '1' OR aurv LIKE '3') AND asok LIKE '$rubrik' AND (aurv LIKE '1' OR aurv LIKE '3') AND asok NOT LIKE '$nixrubrik' AND alok LIKE '$lokal' AND alok NOT LIKE '$nixlokal' AND aort LIKE '$sockenort' AND ahrd LIKE '$haradort' AND alfk LIKE '$lanort' AND alkp LIKE '$landskap' AND aomr LIKE '$landomrade' AND abea LIKE '$belaggartal' AND apub LIKE '$pubdatum' LIMIT $fran,$antal;"; } } if ($sprak == "fin") { $sql1 = "SELECT * FROM nau_ortnamn WHERE (aurv LIKE '5' OR aurv LIKE '7') AND asok LIKE '$rubrik' AND alok LIKE '$lokal' AND aort LIKE '$sockenort' AND ahrd LIKE '$haradort' AND alfk LIKE '$lanort' AND alkp LIKE '$landskap' AND aomr LIKE '$landomrade' AND abea LIKE '$belaggartal' AND apub LIKE '$pubdatum' AND atol LIKE '1' LIMIT $fran,$antal;"; $sql2 = "SELECT * FROM nau_ortnamn WHERE (aurv LIKE '5' OR aurv LIKE '7') AND asok LIKE '$rubrik' AND alok LIKE '$lokal' AND aort LIKE '$sockenort' AND ahrd LIKE '$haradort' AND alfk LIKE '$lanort' AND alkp LIKE '$landskap' AND aomr LIKE '$landomrade' AND abea LIKE '$belaggartal' AND apub LIKE '$pubdatum' LIMIT $fran,$antal;"; if ( strlen($nixrubrik . $nixlokal) > 0 ) { $sql1 = "SELECT * FROM nau_ortnamn WHERE (aurv LIKE '5' OR aurv LIKE '7') AND asok LIKE '$rubrik' AND asok NOT LIKE '$nixrubrik' AND alok LIKE '$lokal' AND alok NOT LIKE '$nixlokal' AND aort LIKE '$sockenort' AND ahrd LIKE '$haradort' AND alfk LIKE '$lanort' AND alkp LIKE '$landskap' AND aomr LIKE '$landomrade' AND abea LIKE '$belaggartal' AND apub LIKE '$pubdatum' AND atol LIKE '1' LIMIT $fran,$antal;"; $sql2 = "SELECT * FROM nau_ortnamn WHERE (aurv LIKE '5' OR aurv LIKE '7') AND asok LIKE '$rubrik' AND asok NOT LIKE '$nixrubrik' AND alok LIKE '$lokal' AND alok NOT LIKE '$nixlokal' AND aort LIKE '$sockenort' AND ahrd LIKE '$haradort' AND alfk LIKE '$lanort' AND alkp LIKE '$landskap' AND aomr LIKE '$landomrade' AND abea LIKE '$belaggartal' AND apub LIKE '$pubdatum' LIMIT $fran,$antal;"; } } if ($sprak == "sam") { $sql1 = "SELECT * FROM nau_ortnamn WHERE (aurv LIKE 'a' OR aurv LIKE 'c') AND asok LIKE '$rubrik' AND alok LIKE '$lokal' AND aort LIKE '$sockenort' AND ahrd LIKE '$haradort' AND alfk LIKE '$lanort' AND alkp LIKE '$landskap' AND aomr LIKE '$landomrade' AND abea LIKE '$belaggartal' AND apub LIKE '$pubdatum' AND atol LIKE '1' LIMIT $fran,$antal;"; $sql2 = "SELECT * FROM nau_ortnamn WHERE (aurv LIKE 'a' OR aurv LIKE 'c') AND asok LIKE '$rubrik' AND alok LIKE '$lokal' AND aort LIKE '$sockenort' AND ahrd LIKE '$haradort' AND alfk LIKE '$lanort' AND alkp LIKE '$landskap' AND aomr LIKE '$landomrade' AND abea LIKE '$belaggartal' AND apub LIKE '$pubdatum' LIMIT $fran,$antal;"; if ( strlen($nixrubrik . $nixlokal) > 0 ) { $sql1 = "SELECT * FROM nau_ortnamn WHERE (aurv LIKE 'a' OR aurv LIKE 'c') AND asok LIKE '$rubrik' AND asok NOT LIKE '$nixrubrik' AND alok LIKE '$lokal' AND alok NOT LIKE '$nixlokal' AND aort LIKE '$sockenort' AND ahrd LIKE '$haradort' AND alfk LIKE '$lanort' AND alkp LIKE '$landskap' AND aomr LIKE '$landomrade' AND abea LIKE '$belaggartal' AND apub LIKE '$pubdatum' AND atol LIKE '1' LIMIT $fran,$antal;"; $sql2 = "SELECT * FROM nau_ortnamn WHERE (aurv LIKE 'a' OR aurv LIKE 'c') AND asok LIKE '$rubrik' AND asok NOT LIKE '$nixrubrik' AND alok LIKE '$lokal' AND alok NOT LIKE '$nixlokal' AND aort LIKE '$sockenort' AND ahrd LIKE '$haradort' AND alfk LIKE '$lanort' AND alkp LIKE '$landskap' AND aomr LIKE '$landomrade' AND abea LIKE '$belaggartal' AND apub LIKE '$pubdatum' LIMIT $fran,$antal;"; } } }else{ if ($sprak == "alla") { $sql1 = "SELECT * FROM nau_ortnamn WHERE (SUBSTRING(akat FROM 2) = '$avdSVE' OR SUBSTRING(akat FROM 2) = '$avdFIN' OR SUBSTRING(akat FROM 2) = '$avdSAM') AND asok LIKE '$rubrik' AND alok LIKE '$lokal' AND aort LIKE '$sockenort' AND ahrd LIKE '$haradort' AND alfk LIKE '$lanort' AND alkp LIKE '$landskap' AND aomr LIKE '$landomrade' AND abea LIKE '$belaggartal' AND apub LIKE '$pubdatum' AND atol LIKE '1' LIMIT $fran,$antal;"; $sql2 = "SELECT * FROM nau_ortnamn WHERE (SUBSTRING(akat FROM 2) = '$avdSVE' OR SUBSTRING(akat FROM 2) = '$avdFIN' OR SUBSTRING(akat FROM 2) = '$avdSAM') AND asok LIKE '$rubrik' AND alok LIKE '$lokal' AND aort LIKE '$sockenort' AND ahrd LIKE '$haradort' AND alfk LIKE '$lanort' AND alkp LIKE '$landskap' AND aomr LIKE '$landomrade' AND abea LIKE '$belaggartal' AND apub LIKE '$pubdatum' LIMIT $fran,$antal;"; if ( strlen($nixrubrik . $nixlokal) > 0 ) { $sql1 = "SELECT * FROM nau_ortnamn WHERE (SUBSTRING(akat FROM 2) = '$avdSVE' OR SUBSTRING(akat FROM 2) = '$avdFIN' OR SUBSTRING(akat FROM 2) = '$avdSAM') AND asok LIKE '$rubrik' AND asok NOT LIKE '$nixrubrik' AND alok LIKE '$lokal' AND alok NOT LIKE '$nixlokal' AND aort LIKE '$sockenort' AND ahrd LIKE '$haradort' AND alfk LIKE '$lanort' AND alkp LIKE '$landskap' AND aomr LIKE '$landomrade' AND abea LIKE '$belaggartal' AND apub LIKE '$pubdatum' AND atol LIKE '1' LIMIT $fran,$antal;"; $sql2 = "SELECT * FROM nau_ortnamn WHERE (SUBSTRING(akat FROM 2) = '$avdSVE' OR SUBSTRING(akat FROM 2) = '$avdFIN' OR SUBSTRING(akat FROM 2) = '$avdSAM') AND asok LIKE '$rubrik' AND asok NOT LIKE '$nixrubrik' AND alok LIKE '$lokal' AND alok NOT LIKE '$nixlokal' AND aort LIKE '$sockenort' AND ahrd LIKE '$haradort' AND alfk LIKE '$lanort' AND alkp LIKE '$landskap' AND aomr LIKE '$landomrade' AND abea LIKE '$belaggartal' AND apub LIKE '$pubdatum' LIMIT $fran,$antal;"; } } if ($sprak == "sve") { $sql1 = "SELECT * FROM nau_ortnamn WHERE SUBSTRING(akat FROM 2) = '$avd' AND (aurv LIKE '1' OR aurv LIKE '3') AND asok LIKE '$rubrik' AND alok LIKE '$lokal' AND aort LIKE '$sockenort' AND ahrd LIKE '$haradort' AND alfk LIKE '$lanort' AND alkp LIKE '$landskap' AND aomr LIKE '$landomrade' AND abea LIKE '$belaggartal' AND apub LIKE '$pubdatum' AND atol LIKE '1' LIMIT $fran,$antal;"; $sql2 = "SELECT * FROM nau_ortnamn WHERE SUBSTRING(akat FROM 2) = '$avd' AND (aurv LIKE '1' OR aurv LIKE '3') AND asok LIKE '$rubrik' AND alok LIKE '$lokal' AND aort LIKE '$sockenort' AND ahrd LIKE '$haradort' AND alfk LIKE '$lanort' AND alkp LIKE '$landskap' AND aomr LIKE '$landomrade' AND abea LIKE '$belaggartal' AND apub LIKE '$pubdatum' LIMIT $fran,$antal;"; if ( strlen($nixrubrik . $nixlokal) > 0 ) { //echo ("Hej2"); $sql1 = "SELECT * FROM nau_ortnamn WHERE SUBSTRING(akat FROM 2) = '$avd' AND (aurv LIKE '1' OR aurv LIKE '3') AND asok LIKE '$rubrik' AND asok NOT LIKE '$nixrubrik' AND alok LIKE '$lokal' AND alok NOT LIKE '$nixlokal' AND aort LIKE '$sockenort' AND ahrd LIKE '$haradort' AND alfk LIKE '$lanort' AND alkp LIKE '$landskap' AND aomr LIKE '$landomrade' AND abea LIKE '$belaggartal' AND apub LIKE '$pubdatum' AND atol LIKE '1' LIMIT $fran,$antal;"; $sql2 = "SELECT * FROM nau_ortnamn WHERE SUBSTRING(akat FROM 2) = '$avd' AND (aurv LIKE '1' OR aurv LIKE '3') AND asok LIKE '$rubrik' AND asok NOT LIKE '$nixrubrik' AND alok LIKE '$lokal' AND alok NOT LIKE '$nixlokal' AND aort LIKE '$sockenort' AND ahrd LIKE '$haradort' AND alfk LIKE '$lanort' AND alkp LIKE '$landskap' AND aomr LIKE '$landomrade' AND abea LIKE '$belaggartal' AND apub LIKE '$pubdatum' LIMIT $fran,$antal;"; } } if ($sprak == "fin") { $sql1 = "SELECT * FROM nau_ortnamn WHERE SUBSTRING(akat FROM 2) = '$avd' AND (aurv LIKE '5' OR aurv LIKE '7') AND asok LIKE '$rubrik' AND alok LIKE '$lokal' AND aort LIKE '$sockenort' AND ahrd LIKE '$haradort' AND alfk LIKE '$lanort' AND alkp LIKE '$landskap' AND aomr LIKE '$landomrade' AND abea LIKE '$belaggartal' AND apub LIKE '$pubdatum' AND atol LIKE '1' LIMIT $fran,$antal;"; $sql2 = "SELECT * FROM nau_ortnamn WHERE SUBSTRING(akat FROM 2) = '$avd' AND (aurv LIKE '5' OR aurv LIKE '7') AND asok LIKE '$rubrik' AND alok LIKE '$lokal' AND aort LIKE '$sockenort' AND ahrd LIKE '$haradort' AND alfk LIKE '$lanort' AND alkp LIKE '$landskap' AND aomr LIKE '$landomrade' AND abea LIKE '$belaggartal' AND apub LIKE '$pubdatum' LIMIT $fran,$antal;"; if ( strlen($nixrubrik . $nixlokal) > 0 ) { $sql1 = "SELECT * FROM nau_ortnamn WHERE SUBSTRING(akat FROM 2) = '$avd' AND (aurv LIKE '5' OR aurv LIKE '7') AND asok LIKE '$rubrik' AND asok NOT LIKE '$nixrubrik' AND alok LIKE '$lokal' AND alok NOT LIKE '$nixlokal' AND aort LIKE '$sockenort' AND ahrd LIKE '$haradort' AND alfk LIKE '$lanort' AND alkp LIKE '$landskap' AND aomr LIKE '$landomrade' AND abea LIKE '$belaggartal' AND apub LIKE '$pubdatum' AND atol LIKE '1' LIMIT $fran,$antal;"; $sql2 = "SELECT * FROM nau_ortnamn WHERE SUBSTRING(akat FROM 2) = '$avd' AND (aurv LIKE '5' OR aurv LIKE '7') AND asok LIKE '$rubrik' AND asok NOT LIKE '$nixrubrik' AND alok LIKE '$lokal' AND alok NOT LIKE '$nixlokal' AND aort LIKE '$sockenort' AND ahrd LIKE '$haradort' AND alfk LIKE '$lanort' AND alkp LIKE '$landskap' AND aomr LIKE '$landomrade' AND abea LIKE '$belaggartal' AND apub LIKE '$pubdatum' LIMIT $fran,$antal;"; } } if ($sprak == "sam") { $sql1 = "SELECT * FROM nau_ortnamn WHERE SUBSTRING(akat FROM 2) = '$avd' AND (aurv LIKE 'a' OR aurv LIKE 'c') AND asok LIKE '$rubrik' AND alok LIKE '$lokal' AND aort LIKE '$sockenort' AND ahrd LIKE '$haradort' AND alfk LIKE '$lanort' AND alkp LIKE '$landskap' AND aomr LIKE '$landomrade' AND abea LIKE '$belaggartal' AND apub LIKE '$pubdatum' AND atol LIKE '1' LIMIT $fran,$antal;"; $sql2 = "SELECT * FROM nau_ortnamn WHERE SUBSTRING(akat FROM 2) = '$avd' AND (aurv LIKE 'a' OR aurv LIKE 'c') AND asok LIKE '$rubrik' AND alok LIKE '$lokal' AND aort LIKE '$sockenort' AND ahrd LIKE '$haradort' AND alfk LIKE '$lanort' AND alkp LIKE '$landskap' AND aomr LIKE '$landomrade' AND abea LIKE '$belaggartal' AND apub LIKE '$pubdatum' LIMIT $fran,$antal;"; if ( strlen($nixrubrik . $nixlokal) > 0 ) { $sql1 = "SELECT * FROM nau_ortnamn WHERE SUBSTRING(akat FROM 2) = '$avd' AND (aurv LIKE 'a' OR aurv LIKE 'c') AND asok LIKE '$rubrik' AND asok NOT LIKE '$nixrubrik' AND alok LIKE '$lokal' AND alok NOT LIKE '$nixlokal' AND aort LIKE '$sockenort' AND ahrd LIKE '$haradort' AND alfk LIKE '$lanort' AND alkp LIKE '$landskap' AND aomr LIKE '$landomrade' AND abea LIKE '$belaggartal' AND apub LIKE '$pubdatum' AND atol LIKE '1' LIMIT $fran,$antal;"; $sql2 = "SELECT * FROM nau_ortnamn WHERE SUBSTRING(akat FROM 2) = '$avd' AND (aurv LIKE 'a' OR aurv LIKE 'c') AND asok LIKE '$rubrik' AND asok NOT LIKE '$nixrubrik' AND alok LIKE '$lokal' AND alok NOT LIKE '$nixlokal' AND aort LIKE '$sockenort' AND ahrd LIKE '$haradort' AND alfk LIKE '$lanort' AND alkp LIKE '$landskap' AND aomr LIKE '$landomrade' AND abea LIKE '$belaggartal' AND apub LIKE '$pubdatum' LIMIT $fran,$antal;"; } } } 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(); } } ?> $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); ?>
1) { $x = ($j - 1) * $antal; }else{ $x = 0; } if ($j == 1) { $xbw = $fran - TABELL_LEN; if ($xbw < 0) { $xbw = 0; } // echo ""; 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 ''; echo ">>"; } } ?>
"); printf(""); // printf(""); printf(""); printf(""); if (empty($strAort)) { printf(""); }else{ printf(""); } if (empty($strAhrd)) { printf(""); }else{ printf(""); } if (empty($strAlfk)) { printf(""); }else{ printf(""); } /* printf("%s", ""); printf("%s", ""); */ printf("%s", ""); printf("%s", ""); printf("%s", ""); printf("%s\n", ""); $j++; } ?>
Nr Ortnamn Lokal Socken Härad Län Landskap Tolkat Sockenöversikt
%s",$j+1 . " 
%s",$j+1+($franx-1) . "  %s","$strAsok%s","$strArub%s","$strAlok%s"," ---%s","$strAort%s","---%s","$strAhrd%s"," ---%s","$strAlfk%s", $strAbea); printf(" %s", $strApub); printf(" %s", $strAlkp); printf(" %s", $strAtol); printf(" %s", " "); printf("#>
$antal):?>
"; echo ''; echo "<< "; ?> $total svar (nr $franx..$sum) sida $sidan($sidor)\n"; ?> ($sidor - 1) * TABELL_LEN) { $xfw = ($sidor - 1) * TABELL_LEN; } echo " "; echo ''; echo ">>"; ?>
" . $teckenvad[$bokstavindex] . ""; }else{ echo "

" . $teckenvad[$bokstavindex] . ""; } $f=1; }else{ echo ",  " . $teckenvad[$bokstavindex] . ""; } $bokstavindex++; if (($teckensid[$bokstavindex]>$j) || ($teckensid[$bokstavindex]==-1)) { echo "
"; } } //end_while } // if alfasort==true if ($j > 1) { $x = ($j - 1) * $antal; }else{ $x = 0; } if ($sidan == $j) { echo "$j"; }else{ echo "$j"; } if ($j < $sidor) echo ", "; } //for j ?>

Skriv ut

 ^