\n"; ?>
";
//echo " AND asok NOT LIKE '$keyword'
";
$keyword = trim($keyword);
if ($keyword != "") {
$sql1 = $sql1 . " AND asok NOT LIKE '$keyword'";
}
}
$sql1 = $sql1 . " GROUP BY asok,alok ORDER BY asok,alok;";
//$sql1 = $sql1 . " LIMIT 0,30;";
//$sql1 = stripslashes(sql1);
//$sql1 = mysql_real_escape_string($sql1);
echo "$sql1
";
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
";
//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;
//echo $strAsok;
//echo "
{$strArub} | {$strAlok}
";
//echo "{$strArub} | {$strAlok} ~ {$strAort} | {$strAlfk} län
";
echo "{$strArub} | {$strAlok} : {$strAort} | {$strAlfk} län
";
//printf("%s","$strArub | ");
//printf("%s","$strAlok | ");
$i++;
}
// close the connection
mysql_free_result($result);
mysql_close();
?>
^Sidtopp
Åter till söksidan