Jag skickar med hela koden istället så kanske någon kan fixa en paging till dom 2 sidorna det gäller...
Kanske om jag har tur så vill någon ta tag i det och fixa det...
Jag fick skriva 2 poster för det var en begränsning på hur många ord man fick skriva per post så därför är det 2 st poster kolla under för att se nästa asp sida...
---------------------------------------------------------
denna kod gäller för sokresultat.asp
<!-- #include file="adovbs.inc" -->
<html>
<head>
<title>Jattestenens Searchengine</title>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
<%
sok = Request.Form("sokord")
IF sok = "" then
sokord = "N/A"
ELSE
sokord = sok
END IF
Set Connect = Server.CreateObject("ADODB.Connection")
Connect.Open "driver={Microsoft Access Driver (*.mdb)};dbq=" & Server.MapPath("sok.mdb")
SQL2 = "SELECT COUNT(*) From sokmotor Where sokord Like '%%" & sokord & "%%'"
Set RecSet2 = Connect.Execute(SQL2)
traffar =RecSet2.Fields(0)
RecSet2.Close
Set RecSet2 = nothing
Set RecSet = Server.CreateObject("ADODB.Recordset")
SQL = "Select * From sokmotor Where sokord Like '%%" & sokord & "%%'"
SQL = SQL & " Order By namn DESC"
RecSet.Open SQL, Connect, adOpenStatic, adLockOptimistic
%>
<link href="style.css" rel="stylesheet" type="text/css">
</head>
<body bgcolor="#FFFFFF" text="#000000" leftmargin="2">
<div align="center">
<p><font face="Verdana" size="6">Welcome To Jattestenens Searchengine<br>
<font size="2">here can you find what you are looking for... And best of all
it's that you can put in your own <br>
homepage now on this searchengine it's simpel and I will continue to make this
search Engine simpel</font></font></p>
<table width="580" border="0" style="border-collapse: collapse" bordercolor="#330099" cellpadding="0" cellspacing="0">
<tr>
<td style="border-left-style: solid; border-left-width: 1; border-right-style: solid; border-right-width: 1; border-top-style: solid; border-top-width: 1" width="578">
<div align="center"><font face="Verdana" size="2">Your search on:<b>
<%=sokord%> </b>gives fallow results:<b> <%=traffar%> </b><%
IF traffar = "1" then
Response.Write "Match"
ELSE
Response.Write "Matches"
END IF
%></font></div>
</td>
</tr>
<tr>
<td style="border-left-style: solid; border-left-width: 1; border-right-style: solid; border-right-width: 1" width="578">
<hr size="1" color="330099" noshade>
</td>
</tr>
<% IF RecSet.EOF then %>
<tr>
<td style="border-left-style: solid; border-left-width: 1; border-right-style: solid; border-right-width: 1" width="580">
<div align="center"><font face="Verdana" size="1"> I am sorry but i
couldn't find any word that match your search:...</font></div>
</td>
</tr>
<%
ELSE
DO UNTIL RecSet.EOF
%>
<tr>
<td style="border-left-style: solid; border-left-width: 1; border-right-style: solid; border-right-width: 1" width="578"> <a href="<%=RecSet("adress")%>" target="_blank"><b><font face="Verdana" size="1"><%=RecSet("namn")%>
</font></b></a> <br>
<font size="1" face="Verdana"> <%=RecSet("beskrivning")%> <br>
</font></td>
</tr>
<%
Recset.MoveNext
Loop
Recset.Close
Connect.Close
Set Recset = Nothing
Set Connect = Nothing
END IF
%>
<tr>
<td style="border-left-style: solid; border-left-width: 1; border-right-style: solid; border-right-width: 1" width="578">
<hr size="1" color="330099" noshade>
</td>
</tr>
<tr>
<td style="border-left-style: solid; border-left-width: 1; border-right-style: solid; border-right-width: 1; border-bottom-style: solid; border-bottom-width: 1" align="left" width="578">
<div align="center"><b>(((( Här vill jag ha in sid blädringen 15 Träffar
per sida om det går bra ))))</b><br>
<br>
<font face="Verdana" size="1"><b>
<a href="sokadd.asp">INSET YOUR HOMEPAGE HERE</a> | <a href="admin.asp">ADMINISTRATION</a> |
<a href="soksida.asp">NEW SEARCH</a></b></font>
</div>
</td>
</tr>
</table>
<center><font face="Verdana" size="1">Created by Acke = Ingemar Axelsson<br></div>
</body>
</html>
---------------------------------------------------
Den som hjälper mig kan ju få hela sökmotorn som tack för hjälpen utav mig MVH Megaman...