\n"; ?>
";
set_time_limit(0);
//$db = mysql_connect("loopback", "soresigv", "Dox.rint");
//mysql_select_db("ortnamndb", $db) or die(mysql_errno() . ": " . mysql_error() . "
");
$db = @mysql_connect("loopback", "soresigv", "Dox.rint") or die("Connection impossible at this time.");
@mysql_select_db("ortnamndb") or die("Selection impossible at this time.");
//$sql = "SELECT * FROM ortnareg WHERE asok LIKE '%ik' AND asok NOT LIKE '%vik' AND asok NOT LIKE '%wik' LIMIT 0,30;";
//$sql = "SELECT DISTINCT alan,akod,aurv,akat,adok,aort,ahrd,alfk,asok,arub,alok,atol,abel,apub,alkp FROM ortnareg WHERE asok LIKE '%ik' AND asok NOT LIKE '%vik' AND asok NOT LIKE '%wik' GROUP BY asok,alok ORDER BY asok,alok;";
$result = mysql_query($sql1, $db);
if(!$result){
echo mysql_error();
exit;
}
$num_rows = mysql_num_rows($result);
echo "
{$num_rows} poster
";
echo "Nr. Rubrik | Lokaltyp
";
//$lines = file('http://www.example.com/');
//$lines = file('artal_Karlshamn.txt');
//echo "{$lines[0]}
";
$i = 0;
while ( $row = mysql_fetch_array($result) ) {
$strAlan = mysql_result($result,$i,"alan");
$strAkod = mysql_result($result,$i,"akod");
$strAurv = mysql_result($result,$i,"aurv");
$strAkat = mysql_result($result,$i,"akat");
$strAdok = mysql_result($result,$i,"adok");
$strAort = mysql_result($result,$i,"aort");
$strAhrd = mysql_result($result,$i,"ahrd");
$strAlfk = mysql_result($result,$i,"alfk");
$strAsok = mysql_result($result,$i,"asok");
$strArub = mysql_result($result,$i,"arub");
$strAlok = mysql_result($result,$i,"alok");
$strAtol = mysql_result($result,$i,"atol");
$strAbel = mysql_result($result,$i,"abel");
$strApub = mysql_result($result,$i,"apub");
$strAlkp = mysql_result($result,$i,"alkp");
$bildmapp_htmlsid = $strAkod . $strAurv;
$bildsubmapp_bild = $strAkod . $strAurv . "/" . $strAkat . "/" . $strAdok . ".pdf";
$bild_hela_adress = "../_s2" . $strAlan . "001/" . $bildsubmapp_bild;
$i++;
//echo "{$i}. {$strArub} | {$strAlok} =
";
//echo "{$strArub};{$strAlok}
";
echo "{$strArub};{$strAlok}
";
}
//close the connection
mysql_free_result($result);
mysql_close();
?>
^Sidtopp
Gå till "Välja socken/stad" sidan.
Gå till "Information om arkivkorten" sidan.