\n"; ?>
Error performing query: " . mysql_error() . "
"); exit(); } } if ($urval == "harad") { $sql1 = "SELECT COUNT(*) AS anum FROM socken2 WHERE socken2.ahrd LIKE '%$rubrik%';"; $result = mysql_query($sql1); if (!$result) { echo("Error performing query: " . mysql_error() . "
"); exit(); } } if ($urval == "lan") { $sql1 = "SELECT COUNT(*) AS anum FROM socken2 WHERE socken2.aln1 LIKE '%$rubrik%';"; $result = mysql_query($sql1); if (!$result) { echo("Error performing query: " . mysql_error() . "
"); exit(); } } if ($urval == "kod") { $sql1 = "SELECT COUNT(*) AS anum FROM socken2 WHERE LEFT(socken2.anum,LENGTH(socken2.anum)) LIKE LEFT('$rubrik',LENGTH('$rubrik'));"; $result = mysql_query($sql1); if (!$result) { echo("Error performing query: " . mysql_error() . "
"); exit(); } } $total = @mysql_result($result,0); } // ************************************************************************************************************ if ($urval == "bokstav") { $sql1 = "SELECT * FROM socken2 WHERE socken2.aort LIKE '$rubrik%' LIMIT $fran,$antal;"; $result = mysql_query($sql1); if (!$result) { echo("Error performing query: " . mysql_error() . "
"); exit(); } } if ($urval == "socken") { $sql1 = "SELECT * FROM socken2 WHERE LEFT(socken2.aort,LENGTH(socken2.aort)) LIKE LEFT('$rubrik',LENGTH('$rubrik')) LIMIT $fran,$antal;"; $result = mysql_query($sql1); if (!$result) { echo("Error performing query: " . mysql_error() . "
"); exit(); } } if ($urval == "harad") { $sql1 = "SELECT * FROM socken2 WHERE socken2.ahrd LIKE '%$rubrik%' LIMIT $fran,$antal;"; $result = mysql_query($sql1); if (!$result) { echo("Error performing query: " . mysql_error() . "
"); exit(); } } if ($urval == "lan") { $sql1 = "SELECT * FROM socken2 WHERE socken2.aln1 LIKE '%$rubrik%' LIMIT $fran,$antal;"; $result = mysql_query($sql1); if (!$result) { echo("Error performing query: " . mysql_error() . "
"); exit(); } } if ($urval == "kod") { $sql1 = "SELECT * FROM socken2 WHERE LEFT(socken2.anum,LENGTH(socken2.anum)) LIKE LEFT('$rubrik',LENGTH('$rubrik')) LIMIT $fran,$antal;"; $result = mysql_query($sql1); 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 "<<";
}
}
// ############################################################################################################
?>
$total poster (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 ">>";
}
}
// ############################################################################################################
?>
|
||||||
Nr | Socken "); ?>Härad | Län | Org | Kod | Tabell | %s",$j+1 . " | "); if ($strAfg1 == "1") { $php1_sida_pekare = $strAlfk . "1.php" . "?socken=" . $strAord . "&harad=&rubrik=%25&lokal=%25&avdnr=0&sprak=alla&formular=+++S%F6k+++"; printf("%s"," $strAord | "); }else{ printf("%s"," $strAord | "); } if ($strAfg1 == "1") { $php1_sida_pekare = $strAlfk . "1.php" . "?socken=&harad=" . $strAhrd . "&rubrik=%25&lokal=%25&avdnr=0&sprak=alla&formular=+++S%F6k+++"; printf("%s"," $strAhrd | "); }else{ printf("%s"," $strAhrd | "); } if ($strAfg1 == "1") { $php1_sida_pekare = $strAlfk . "1.php"; printf("%s"," $strAln1 | "); }else{ printf("%s"," $strAln1 | "); } printf("%s"," $strAorg | "); printf("%s"," $strAreg | "); if ($strAfg2 == "1") { printf("%s","#> | "); }else{ printf("%s","- | "); } printf(""); $j++; } // ############################################################################################################ ?>
$total poster (nr $franx..$sum) sida $sidan($sidor) \n";
// ############################################################################################################
?>
|