\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;
echo "
{$num_rows} poster
";
//echo "Namn | Lokaltyp : Socken | Län
";
echo "Namn | Beläggsår
";
//while( $row = mysql_fetch_array( $result, MYSQL_ASSOC ) ) {
//$html = array(); //create an array of html formated values.
//$html['sok1'] = nl2br( stripslashes( htmlentities( $row['asok'], ENT_QUOTES, 'UTF-8' ) ) );
//echo "x:
{$html['sok1']}
";
// echo "
{$row}
";
//}
$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}
";
echo "{$i}. {$strArub}
";
//printf("%s","$strArub | ");
//printf("%s","$strAlok | ");
}
// close the connection
mysql_free_result($result);
mysql_close();
?>
^Sidtopp
&Garing; till "välja socken sidan"