< space XXX space LÄN > $sockenort = "%"; $haradort = "%"; $landskap = "%"; } if ($sockenort != "%") { // $haradort = "%"; // $lanort = "%"; // $landskap = "%"; } if ($haradort != "%") { // $lanort = "%"; // $landskap = "%"; } if (empty($belaggsar_a)) $belaggsar_a = "%"; if (empty($belaggsar_b)) $belaggsar_b = "%"; if (empty($kommentar)) $kommentar = "%"; 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); //################################################################################################# //################################################################################################# ?> window.defaultStatus=' Ortnamnsregistret på webben bestå nu av 3,7 miljoner poster.'; onUnload="window.defaultStatus='';" >

Ortnamnsregistret  © Institutet för språk och folkminnen

Sök i alla län

 
 
Sök på 
Ortnamn (uteslut i Ortnamn )
Lokal (uteslut i Lokal       )
Socken  
Härad  
Län  
Landskap  
Beläggsår_A
Beläggsår_B
Kommentar
Datum

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 procent(%) avses X antal tecken utelämnade och med ett understreck(_) enbart 1 tecken utelämnat. Använd uteslut-textrutorna om uteslutn av en/flera teckenkomb.
Ortnamn_A: 
Ortnamn_B: 
Lokal: 
Socken: 
Härad: 
Län: 
Landskap: 
Beläggsår_A: 
Beläggsår_B: 
Kommentar: 
Datum: 
Tolkning/Se: Ja  Nej      Nr:    "; ?>
"; $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 ortnareg 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 abea LIKE '$belaggsar_a' AND abeb LIKE '$belaggsar_b' AND atxt LIKE '$kommentar' AND apub LIKE '$pubdatum' AND atol LIKE '1' AND LEFT(asok,1) LIKE '$bokst';"; $sql2 = "SELECT * FROM ortnareg 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 abea LIKE '$belaggsar_a' AND abeb LIKE '$belaggsar_b' AND atxt LIKE '$kommentar' AND apub LIKE '$pubdatum' AND LEFT(asok,1) LIKE '$bokst';"; if ($nixrubrik != "") { $sql1 = "SELECT * FROM ortnareg 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 abea LIKE '$belaggsar_a' AND abeb LIKE '$belaggsar_b' AND atxt LIKE '$kommentar' AND apub LIKE '$pubdatum' AND atol LIKE '1' AND LEFT(asok,1) LIKE '$bokst';"; $sql2 = "SELECT * FROM ortnareg 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 abea LIKE '$belaggsar_a' AND abeb LIKE '$belaggsar_b' AND atxt LIKE '$kommentar' AND apub LIKE '$pubdatum' AND LEFT(asok,1) LIKE '$bokst';"; } } if ($sprak == "sve") { $sql1 = "SELECT * FROM ortnareg 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 abea LIKE '$belaggsar_a' AND abeb LIKE '$belaggsar_b' AND atxt LIKE '$kommentar' AND apub LIKE '$pubdatum' AND atol LIKE '1' AND LEFT(asok,1) LIKE '$bokst';"; $sql2 = "SELECT * FROM ortnareg 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 abea LIKE '$belaggsar_a' AND abeb LIKE '$belaggsar_b' AND atxt LIKE '$kommentar' AND apub LIKE '$pubdatum' AND LEFT(asok,1) LIKE '$bokst';"; } if ($sprak == "fin") { $sql1 = "SELECT * FROM ortnareg 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 abea LIKE '$belaggsar_a' AND abeb LIKE '$belaggsar_b' AND atxt LIKE '$kommentar' AND apub LIKE '$pubdatum' AND atol LIKE '1' AND LEFT(asok,1) LIKE '$bokst';"; $sql2 = "SELECT * FROM ortnareg 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 abea LIKE '$belaggsar_a' AND abeb LIKE '$belaggsar_b' AND atxt LIKE '$kommentar' AND apub LIKE '$pubdatum' AND LEFT(asok,1) LIKE '$bokst';"; } if ($sprak == "sam") { $sql1 = "SELECT * FROM ortnareg 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 abea LIKE '$belaggsar_a' AND abeb LIKE '$belaggsar_b' AND atxt LIKE '$kommentar' AND apub LIKE '$pubdatum' AND atol LIKE '1' AND LEFT(asok,1) LIKE '$bokst';"; $sql2 = "SELECT * FROM ortnareg 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 abea LIKE '$belaggsar_a' AND abeb LIKE '$belaggsar_b' AND atxt LIKE '$kommentar' AND apub LIKE '$pubdatum' AND LEFT(asok,1) LIKE '$bokst';"; } }else{ if ($sprak == "alla") { $sql1 = "SELECT * FROM ortnareg 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 abea LIKE '$belaggsar_a' AND abeb LIKE '$belaggsar_b' AND atxt LIKE '$kommentar' AND apub LIKE '$pubdatum' AND atol LIKE '1' AND LEFT(asok,1) LIKE '$bokst';"; $sql2 = "SELECT * FROM ortnareg 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 abea LIKE '$belaggsar_a' AND abeb LIKE '$belaggsar_b' AND atxt LIKE '$kommentar' AND apub LIKE '$pubdatum' AND LEFT(asok,1) LIKE '$bokst';"; } if ($sprak == "sve") { $sql1 = "SELECT * FROM ortnareg 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 abea LIKE '$belaggsar_a' AND abeb LIKE '$belaggsar_b' AND atxt LIKE '$kommentar' AND apub LIKE '$pubdatum' AND atol LIKE '1' AND LEFT(asok,1) LIKE '$bokst';"; $sql2 = "SELECT * FROM ortnareg 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 abea LIKE '$belaggsar_a' AND abeb LIKE '$belaggsar_b' AND atxt LIKE '$kommentar' AND apub LIKE '$pubdatum' AND LEFT(asok,1) LIKE '$bokst';"; } if ($sprak == "fin") { $sql1 = "SELECT * FROM ortnareg 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 abea LIKE '$belaggsar_a' AND abeb LIKE '$belaggsar_b' AND atxt LIKE '$kommentar' AND apub LIKE '$pubdatum' AND atol LIKE '1' AND LEFT(asok,1) LIKE '$bokst';"; $sql2 = "SELECT * FROM ortnareg 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 abea LIKE '$belaggsar_a' AND abeb LIKE '$belaggsar_b' AND atxt LIKE '$kommentar' AND apub LIKE '$pubdatum' AND LEFT(asok,1) LIKE '$bokst';"; } if ($sprak == "sam") { $sql1 = "SELECT * FROM ortnareg 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 abea LIKE '$belaggsar_a' AND abeb LIKE '$belaggsar_b' AND atxt LIKE '$kommentar' AND apub LIKE '$pubdatum' AND atol LIKE '1' AND LEFT(asok,1) LIKE '$bokst';"; $sql2 = "SELECT * FROM ortnareg 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 abea LIKE '$belaggsar_a' AND abeb LIKE '$belaggsar_b' AND atxt LIKE '$kommentar' 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 ortnareg 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 abea LIKE '$belaggsar_a' AND abeb LIKE '$belaggsar_b' AND atxt LIKE '$kommentar' AND apub LIKE '$pubdatum' AND atol LIKE '1';"; $sql2 = "SELECT COUNT(*) AS alan FROM ortnareg 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 abea LIKE '$belaggsar_a' AND abeb LIKE '$belaggsar_b' AND atxt LIKE '$kommentar' AND apub LIKE '$pubdatum';"; if ( strlen($nixrubrik . $nixlokal) > 0 ) { $sql1 = "SELECT COUNT(*) AS alan FROM ortnareg 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 abea LIKE '$belaggsar_a' AND abeb LIKE '$belaggsar_b' AND atxt LIKE '$kommentar' AND apub LIKE '$pubdatum' AND atol LIKE '1';"; $sql2 = "SELECT COUNT(*) AS alan FROM ortnareg 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 abea LIKE '$belaggsar_a' AND abeb LIKE '$belaggsar_b' AND atxt LIKE '$kommentar' AND apub LIKE '$pubdatum';"; } //$sql2 = "SELECT COUNT(*) FROM ortnareg WHERE asok LIKE '%ik' AND asok NOT LIKE '%vik';"; } if ($sprak == "sve") { $sql1 = "SELECT COUNT(*) AS alan FROM ortnareg 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 abea LIKE '$belaggsar_a' AND abeb LIKE '$belaggsar_b' AND atxt LIKE '$kommentar' AND apub LIKE '$pubdatum' AND atol LIKE '1';"; $sql2 = "SELECT COUNT(*) AS alan FROM ortnareg 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 abea LIKE '$belaggsar_a' AND abeb LIKE '$belaggsar_b' AND atxt LIKE '$kommentar' AND apub LIKE '$pubdatum';"; if ( strlen($nixrubrik . $nixlokal) > 0 ) { $sql1 = "SELECT COUNT(*) AS alan FROM ortnareg 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 abea LIKE '$belaggsar_a' AND abeb LIKE '$belaggsar_b' AND atxt LIKE '$kommentar' AND apub LIKE '$pubdatum' AND atol LIKE '1';"; $sql2 = "SELECT COUNT(*) AS alan FROM ortnareg 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 abea LIKE '$belaggsar_a' AND abeb LIKE '$belaggsar_b' AND atxt LIKE '$kommentar' AND apub LIKE '$pubdatum';"; } } if ($sprak == "fin") { $sql1 = "SELECT COUNT(*) AS alan FROM ortnareg 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 abea LIKE '$belaggsar_a' AND abeb LIKE '$belaggsar_b' AND atxt LIKE '$kommentar' AND apub LIKE '$pubdatum' AND atol LIKE '1';"; $sql2 = "SELECT COUNT(*) AS alan FROM ortnareg 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 abea LIKE '$belaggsar_a' AND abeb LIKE '$belaggsar_b' AND atxt LIKE '$kommentar' AND apub LIKE '$pubdatum';"; if ( strlen($nixrubrik . $nixlokal) > 0 ) { $sql1 = "SELECT COUNT(*) AS alan FROM ortnareg 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 abea LIKE '$belaggsar_a' AND abeb LIKE '$belaggsar_b' AND atxt LIKE '$kommentar' AND apub LIKE '$pubdatum' AND atol LIKE '1';"; $sql2 = "SELECT COUNT(*) AS alan FROM ortnareg 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 abea LIKE '$belaggsar_a' AND abeb LIKE '$belaggsar_b' AND atxt LIKE '$kommentar' AND apub LIKE '$pubdatum';"; } } if ($sprak == "sam") { $sql1 = "SELECT COUNT(*) AS alan FROM ortnareg 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 abea LIKE '$belaggsar_a' AND abeb LIKE '$belaggsar_b' AND atxt LIKE '$kommentar' AND apub LIKE '$pubdatum' AND atol LIKE '1';"; $sql2 = "SELECT COUNT(*) AS alan FROM ortnareg 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 abea LIKE '$belaggsar_a' AND abeb LIKE '$belaggsar_b' AND atxt LIKE '$kommentar' AND apub LIKE '$pubdatum';"; if ( strlen($nixrubrik . $nixlokal) > 0 ) { $sql1 = "SELECT COUNT(*) AS alan FROM ortnareg 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 abea LIKE '$belaggsar_a' AND abeb LIKE '$belaggsar_b' AND atxt LIKE '$kommentar' AND apub LIKE '$pubdatum' AND atol LIKE '1';"; $sql2 = "SELECT COUNT(*) AS alan FROM ortnareg 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 abea LIKE '$belaggsar_a' AND abeb LIKE '$belaggsar_b' AND atxt LIKE '$kommentar' AND apub LIKE '$pubdatum';"; } } }else{ if ($sprak == "alla") { $sql1 = "SELECT COUNT(*) AS alan FROM ortnareg 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 abea LIKE '$belaggsar_a' AND abeb LIKE '$belaggsar_b' AND atxt LIKE '$kommentar' AND apub LIKE '$pubdatum' AND atol LIKE '1';"; $sql2 = "SELECT COUNT(*) AS alan FROM ortnareg 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 abea LIKE '$belaggsar_a' AND abeb LIKE '$belaggsar_b' AND atxt LIKE '$kommentar' AND apub LIKE '$pubdatum';"; if ( strlen($nixrubrik . $nixlokal) > 0 ) { $sql1 = "SELECT COUNT(*) AS alan FROM ortnareg 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 abea LIKE '$belaggsar_a' AND abeb LIKE '$belaggsar_b' AND atxt LIKE '$kommentar' AND apub LIKE '$pubdatum' AND atol LIKE '1';"; $sql2 = "SELECT COUNT(*) AS alan FROM ortnareg 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 abea LIKE '$belaggsar_a' AND abeb LIKE '$belaggsar_b' AND atxt LIKE '$kommentar' AND apub LIKE '$pubdatum';"; } } if ($sprak == "sve") { $sql1 = "SELECT COUNT(*) AS alan FROM ortnareg 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 abea LIKE '$belaggsar_a' AND abeb LIKE '$belaggsar_b' AND atxt LIKE '$kommentar' AND apub LIKE '$pubdatum' AND atol LIKE '1';"; $sql2 = "SELECT COUNT(*) AS alan FROM ortnareg 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 abea LIKE '$belaggsar_a' AND abeb LIKE '$belaggsar_b' AND atxt LIKE '$kommentar' AND apub LIKE '$pubdatum';"; if ( strlen($nixrubrik . $nixlokal) > 0 ) { $sql1 = "SELECT COUNT(*) AS alan FROM ortnareg 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 abea LIKE '$belaggsar_a' AND abeb LIKE '$belaggsar_b' AND atxt LIKE '$kommentar' AND apub LIKE '$pubdatum' AND atol LIKE '1';"; $sql2 = "SELECT COUNT(*) AS alan FROM ortnareg 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 abea LIKE '$belaggsar_a' AND abeb LIKE '$belaggsar_b' AND atxt LIKE '$kommentar' AND apub LIKE '$pubdatum';"; } } if ($sprak == "fin") { $sql1 = "SELECT COUNT(*) AS alan FROM ortnareg 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 abea LIKE '$belaggsar_a' AND abeb LIKE '$belaggsar_b' AND atxt LIKE '$kommentar' AND apub LIKE '$pubdatum' AND atol LIKE '1';"; $sql2 = "SELECT COUNT(*) AS alan FROM ortnareg 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 abea LIKE '$belaggsar_a' AND abeb LIKE '$belaggsar_b' AND atxt LIKE '$kommentar' AND apub LIKE '$pubdatum';"; if ( strlen($nixrubrik . $nixlokal) > 0 ) { $sql1 = "SELECT COUNT(*) AS alan FROM ortnareg 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 abea LIKE '$belaggsar_a' AND abeb LIKE '$belaggsar_b' AND atxt LIKE '$kommentar' AND apub LIKE '$pubdatum' AND atol LIKE '1';"; $sql2 = "SELECT COUNT(*) AS alan FROM ortnareg 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 abea LIKE '$belaggsar_a' AND abeb LIKE '$belaggsar_b' AND atxt LIKE '$kommentar' AND apub LIKE '$pubdatum';"; } } if ($sprak == "sam") { $sql1 = "SELECT COUNT(*) AS alan FROM ortnareg 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 abea LIKE '$belaggsar_a' AND abeb LIKE '$belaggsar_b' AND atxt LIKE '$kommentar' AND apub LIKE '$pubdatum' AND atol LIKE '1';"; $sql2 = "SELECT COUNT(*) AS alan FROM ortnareg 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 abea LIKE '$belaggsar_a' AND abeb LIKE '$belaggsar_b' AND atxt LIKE '$kommentar' AND apub LIKE '$pubdatum';"; if ( strlen($nixrubrik . $nixlokal) > 0 ) { $sql1 = "SELECT COUNT(*) AS alan FROM ortnareg 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 abea LIKE '$belaggsar_a' AND abeb LIKE '$belaggsar_b' AND atxt LIKE '$kommentar' AND apub LIKE '$pubdatum' AND atol LIKE '1';"; $sql2 = "SELECT COUNT(*) AS alan FROM ortnareg 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 abea LIKE '$belaggsar_a' AND abeb LIKE '$belaggsar_b' AND atxt LIKE '$kommentar' 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 ortnareg 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 abea LIKE '$belaggsar_a' AND abeb LIKE '$belaggsar_b' AND atxt LIKE '$kommentar' AND apub LIKE '$pubdatum' AND atol LIKE '1' LIMIT $fran,$antal;"; $sql2 = "SELECT * FROM ortnareg 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 abea LIKE '$belaggsar_a' AND abeb LIKE '$belaggsar_b' AND atxt LIKE '$kommentar' AND apub LIKE '$pubdatum' LIMIT $fran,$antal;"; if ( strlen($nixrubrik . $nixlokal) > 0 ) { $sql1 = "SELECT * FROM ortnareg 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 abea LIKE '$belaggsar_a' AND abeb LIKE '$belaggsar_b' AND atxt LIKE '$kommentar' AND apub LIKE '$pubdatum' AND atol LIKE '1' LIMIT $fran,$antal;"; $sql2 = "SELECT * FROM ortnareg 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 abea LIKE '$belaggsar_a' AND abeb LIKE '$belaggsar_b' AND atxt LIKE '$kommentar' AND apub LIKE '$pubdatum' LIMIT $fran,$antal;"; } //$sql2 = "SELECT * FROM ortnareg WHERE asok LIKE '%ik' AND asok NOT LIKE '%vik';"; } if ($sprak == "sve") { $sql1 = "SELECT * FROM ortnareg 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 abea LIKE '$belaggsar_a' AND abeb LIKE '$belaggsar_b' AND atxt LIKE '$kommentar' AND apub LIKE '$pubdatum' AND atol LIKE '1' LIMIT $fran,$antal;"; $sql2 = "SELECT * FROM ortnareg 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 abea LIKE '$belaggsar_a' AND abeb LIKE '$belaggsar_b' AND atxt LIKE '$kommentar' AND apub LIKE '$pubdatum' LIMIT $fran,$antal;"; if ( strlen($nixrubrik . $nixlokal) > 0 ) { $sql1 = "SELECT * FROM ortnareg 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 abea LIKE '$belaggsar_a' AND abeb LIKE '$belaggsar_b' AND atxt LIKE '$kommentar' AND apub LIKE '$pubdatum' AND atol LIKE '1' LIMIT $fran,$antal;"; // $sql2 = "SELECT * FROM ortnareg 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 abea LIKE '$belaggsar_a' AND abeb LIKE '$belaggsar_b' AND atxt LIKE '$kommentar' AND apub LIKE '$pubdatum' LIMIT $fran,$antal;"; $sql2 = "SELECT * FROM ortnareg 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 abea LIKE '$belaggsar_a' AND abeb LIKE '$belaggsar_b' AND atxt LIKE '$kommentar' AND apub LIKE '$pubdatum' LIMIT $fran,$antal;"; } } if ($sprak == "fin") { $sql1 = "SELECT * FROM ortnareg 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 abea LIKE '$belaggsar_a' AND abeb LIKE '$belaggsar_b' AND atxt LIKE '$kommentar' AND apub LIKE '$pubdatum' AND atol LIKE '1' LIMIT $fran,$antal;"; $sql2 = "SELECT * FROM ortnareg 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 abea LIKE '$belaggsar_a' AND abeb LIKE '$belaggsar_b' AND atxt LIKE '$kommentar' AND apub LIKE '$pubdatum' LIMIT $fran,$antal;"; if ( strlen($nixrubrik . $nixlokal) > 0 ) { $sql1 = "SELECT * FROM ortnareg 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 abea LIKE '$belaggsar_a' AND abeb LIKE '$belaggsar_b' AND atxt LIKE '$kommentar' AND apub LIKE '$pubdatum' AND atol LIKE '1' LIMIT $fran,$antal;"; $sql2 = "SELECT * FROM ortnareg 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 abea LIKE '$belaggsar_a' AND abeb LIKE '$belaggsar_b' AND atxt LIKE '$kommentar' AND apub LIKE '$pubdatum' LIMIT $fran,$antal;"; } } if ($sprak == "sam") { $sql1 = "SELECT * FROM ortnareg 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 abea LIKE '$belaggsar_a' AND abeb LIKE '$belaggsar_b' AND atxt LIKE '$kommentar' AND apub LIKE '$pubdatum' AND atol LIKE '1' LIMIT $fran,$antal;"; $sql2 = "SELECT * FROM ortnareg 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 abea LIKE '$belaggsar_a' AND abeb LIKE '$belaggsar_b' AND atxt LIKE '$kommentar' AND apub LIKE '$pubdatum' LIMIT $fran,$antal;"; if ( strlen($nixrubrik . $nixlokal) > 0 ) { $sql1 = "SELECT * FROM ortnareg 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 abea LIKE '$belaggsar_a' AND abeb LIKE '$belaggsar_b' AND atxt LIKE '$kommentar' AND apub LIKE '$pubdatum' AND atol LIKE '1' LIMIT $fran,$antal;"; $sql2 = "SELECT * FROM ortnareg 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 abea LIKE '$belaggsar_a' AND abeb LIKE '$belaggsar_b' AND atxt LIKE '$kommentar' AND apub LIKE '$pubdatum' LIMIT $fran,$antal;"; } } }else{ if ($sprak == "alla") { $sql1 = "SELECT * FROM ortnareg 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 abea LIKE '$belaggsar_a' AND abeb LIKE '$belaggsar_b' AND atxt LIKE '$kommentar' AND apub LIKE '$pubdatum' AND atol LIKE '1' LIMIT $fran,$antal;"; $sql2 = "SELECT * FROM ortnareg 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 abea LIKE '$belaggsar_a' AND abeb LIKE '$belaggsar_b' AND atxt LIKE '$kommentar' AND apub LIKE '$pubdatum' LIMIT $fran,$antal;"; if ( strlen($nixrubrik . $nixlokal) > 0 ) { $sql1 = "SELECT * FROM ortnareg 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 abea LIKE '$belaggsar_a' AND abeb LIKE '$belaggsar_b' AND atxt LIKE '$kommentar' AND apub LIKE '$pubdatum' AND atol LIKE '1' LIMIT $fran,$antal;"; $sql2 = "SELECT * FROM ortnareg 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 abea LIKE '$belaggsar_a' AND abeb LIKE '$belaggsar_b' AND atxt LIKE '$kommentar' AND apub LIKE '$pubdatum' LIMIT $fran,$antal;"; } } if ($sprak == "sve") { $sql1 = "SELECT * FROM ortnareg 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 abea LIKE '$belaggsar_a' AND abeb LIKE '$belaggsar_b' AND atxt LIKE '$kommentar' AND apub LIKE '$pubdatum' AND atol LIKE '1' LIMIT $fran,$antal;"; $sql2 = "SELECT * FROM ortnareg 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 abea LIKE '$belaggsar_a' AND abeb LIKE '$belaggsar_b' AND atxt LIKE '$kommentar' AND apub LIKE '$pubdatum' LIMIT $fran,$antal;"; if ( strlen($nixrubrik . $nixlokal) > 0 ) { echo ("Hej2"); $sql1 = "SELECT * FROM ortnareg 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 abea LIKE '$belaggsar_a' AND abeb LIKE '$belaggsar_b' AND atxt LIKE '$kommentar' AND apub LIKE '$pubdatum' AND atol LIKE '1' LIMIT $fran,$antal;"; $sql2 = "SELECT * FROM ortnareg 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 abea LIKE '$belaggsar_a' AND abeb LIKE '$belaggsar_b' AND atxt LIKE '$kommentar' AND apub LIKE '$pubdatum' LIMIT $fran,$antal;"; } } if ($sprak == "fin") { $sql1 = "SELECT * FROM ortnareg 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 abea LIKE '$belaggsar_a' AND abeb LIKE '$belaggsar_b' AND atxt LIKE '$kommentar' AND apub LIKE '$pubdatum' AND atol LIKE '1' LIMIT $fran,$antal;"; $sql2 = "SELECT * FROM ortnareg 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 abea LIKE '$belaggsar_a' AND abeb LIKE '$belaggsar_b' AND atxt LIKE '$kommentar' AND apub LIKE '$pubdatum' LIMIT $fran,$antal;"; if ( strlen($nixrubrik . $nixlokal) > 0 ) { $sql1 = "SELECT * FROM ortnareg 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 abea LIKE '$belaggsar_a' AND abeb LIKE '$belaggsar_b' AND atxt LIKE '$kommentar' AND apub LIKE '$pubdatum' AND atol LIKE '1' LIMIT $fran,$antal;"; $sql2 = "SELECT * FROM ortnareg 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 abea LIKE '$belaggsar_a' AND abeb LIKE '$belaggsar_b' AND atxt LIKE '$kommentar' AND apub LIKE '$pubdatum' LIMIT $fran,$antal;"; } } if ($sprak == "sam") { $sql1 = "SELECT * FROM ortnareg 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 abea LIKE '$belaggsar_a' AND abeb LIKE '$belaggsar_b' AND atxt LIKE '$kommentar' AND apub LIKE '$pubdatum' AND atol LIKE '1' LIMIT $fran,$antal;"; $sql2 = "SELECT * FROM ortnareg 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 abea LIKE '$belaggsar_a' AND abeb LIKE '$belaggsar_b' AND atxt LIKE '$kommentar' AND apub LIKE '$pubdatum' LIMIT $fran,$antal;"; if ( strlen($nixrubrik . $nixlokal) > 0 ) { $sql1 = "SELECT * FROM ortnareg 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 abea LIKE '$belaggsar_a' AND abeb LIKE '$belaggsar_b' AND atxt LIKE '$kommentar' AND apub LIKE '$pubdatum' AND atol LIKE '1' LIMIT $fran,$antal;"; $sql2 = "SELECT * FROM ortnareg 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 abea LIKE '$belaggsar_a' AND abeb LIKE '$belaggsar_b' AND atxt LIKE '$kommentar' 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); ?> "; echo "a[{$i}] = new Array(18);\n"; echo "a[{$i}][0] = \"{$strAlan}\";\n"; echo "a[{$i}][1] = \"{$strAkod}\";\n"; echo "a[{$i}][2] = \"{$strAurv}\";\n"; echo "a[{$i}][3] = \"{$strAkat}\";\n"; echo "a[{$i}][4] = \"{$strAdok}\";\n"; echo "a[{$i}][5] = \"{$strAlfk}\";\n"; echo "a[{$i}][6] = \"{$strAort}\";\n"; echo "a[{$i}][7] = \"{$strAsok}\";\n"; echo "a[{$i}][8] = \"{$strArub}\";\n"; echo "a[{$i}][9] = \"{$strAlok}\";\n"; echo "a[{$i}][10] = \"{$strAhrd}\";\n"; echo "a[{$i}][11] = \"{$strAlkp}\";\n"; echo "a[{$i}][12] = \"{$strAtol}\";\n"; echo "a[{$i}][13] = \"{$strAbea}\";\n"; echo "a[{$i}][14] = \"{$strAbeb}\";\n"; echo "a[{$i}][15] = \"{$strAtxt}\";\n"; echo "a[{$i}][16] = \"{$strApub}\";\n"; echo "a[{$i}][17] = \"{$strAnum}\";\n"; echo "a[{$i}][18] = \"{$strArad}\";\n"; echo ""; //$sqlfind[$i] = "SELECT * FROM ortnareg WHERE alan=\'".$strAlan."\' AND akod=\'".$strAkod."\' AND aurv=\'".$strAurv."\' AND akat=\'".$strAkat."\' AND adok=\'".$strAdok."\';"; $sqlfind[$i] = "SELECT * FROM ortnareg WHERE alan=\'".$strAlan."\' AND akod=\'".$strAkod."\' AND aurv=\'".$strAurv."\' AND akat=\'".$strAkat."\' AND adok=\'".$strAdok."\';"; //########################################################## $s1Alan[$i] = $strAlan; //pn1 $s1Akod[$i] = $strAkod; //pn2 $s1Aurv[$i] = $strAurv; //pn3 $s1Akat[$i] = $strAkat; //pn4 $s1Adok[$i] = $strAdok; //pn5 $s1Anum[$i] = $strAnum; //alfabetsordningsnummer $s1Arad[$i] = $strArad; //insorteringsrad på sockensida //########################################################## $bildmapp_htmlsid = $strAkod . $strAurv; $bildsubmapp_bild = $strAkod . $strAurv . "/" . $strAkat . "/" . $strAdok . ".pdf"; $bild_hela_adress = "../_s2" . $strAlan . "001/" . $bildsubmapp_bild; $bild_hela_adress2 = "_s2" . $strAlan . "001/" . $bildsubmapp_bild; $urlbild = $host . $bild_hela_adress2; $html_hela_adress = "../_s1" . $strAlan . "001/" . $bildmapp_htmlsid . ".htm"; $html_sida_ankare = $html_hela_adress . "#"; $sockenkod = substr($strAkod,0,7); if ($strAtol == "1") { $html_sida_ankare = $html_sida_ankare . "S"; }else{ $html_sida_ankare = $html_sida_ankare . "A"; } //**************************************************************** $strArub = str_replace("'","\"",$strArub); $strArub = str_replace("\"","»",$strArub); $strAlok = str_replace("'","\"",$strAlok); $strAlok = str_replace("\"","»",$strAlok); $html_sida_pekare = $html_sida_ankare . "_" . $strArub . " | " . $strAlok; if ($strAtol == "1") { $strAtol = "Ja"; }else{ $strAtol = ""; } //############################################################################################################# $bildLank = $bild_hela_adress; $pos = strpos($bildLank,"."); //if ($pos == true) { $txtstr = substr($bildLank,0,$pos); //.pdf bort $textLank = str_replace("s","u",$txtstr); $textLank = str_replace("/","_",$textLank); //} $pos = strpos($textLank,"_"); $vanster = substr($textLank,0,$pos); $hoger = substr($textLank,$pos+1); $textLank = $vanster . "/" . $hoger; $textLank = $textLank . ".htm"; //############################################################################################################# reset($kolumn); $kolumn[$i][0] = $strAsok; $kolumn[$i][1] = $strArub; $kolumn[$i][2] = $strAort; $kolumn[$i][3] = $strAhrd; $kolumn[$i][4] = $strAlfk; $kolumn[$i][5] = $strAlok; $kolumn[$i][6] = $strAtol; $kolumn[$i][7] = $strAbea; $kolumn[$i][8] = $strAbeb; $kolumn[$i][9] = $strAtxt; $kolumn[$i][10] = $strApub; $kolumn[$i][11] = $strAlkp; $kolumn[$i][12] = $bild_hela_adress; $kolumn[$i][13] = $html_sida_pekare; $kolumn[$i][14] = $urlbild; $c = ""; $a = $kolumn[$i][3]; for ($k=0;$k
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 ">>"; } } ?>
"; //echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; // ex med textarea echo ""; echo ""; //echo ""; echo ""; echo ""; $j++; } ?>
Nr Ortnamn Lokal Socken Härad Län Landskap Se Bel~sår_A Beläggsår_B Kommentar Datum Arkiv
$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

 ^