Hej!
Jag har gjort en sökfunktion som nu ska lista fram resultaten. Det funkar ju så va, men till tabellerna för att få det snyggt oså så strular det lite... Tabellerna som skriver ut te x användarnamnet på en en person, eller vilken klass hon/han går i funkar bra med måtten, men inte den som ska förklara ovanför utskrivningen vad varje grej är.... Kolla koden, ser helt likadana ut enligt mig, annars är jag blind!!!!
[red]
<span class="rubrik">Sökresultat:</span><br><br>
<%
strResults = strResults &_
"<tr><td width=""20%"" bgcolor=""#FFFFFF""><b>Användarnamn</b></td>"&_
"<td width=""10%"" bgcolor=""#FFFFFF""><b>Kön</b></td>"&_
"<td width=""10%"" bgcolor=""#FFFFFF""><b>Ålder</b></td>"&_
"<td width=""20%"" bgcolor=""#FFFFFF""><b>Bor</b></td>"&_
"<td width=""20%"" bgcolor=""#FFFFFF""><b>Status</b></td>"&_
"<td width=""10%"" bgcolor=""#FFFFFF""><b>Klass</b></td></tr>"
Set objResults = Server.Createobject("Adodb.Recordset")
strSQLResults = strSQLResults & " ORDER BY userFirstName ASC"
intPageId = request.querystring( "pageid" )
if intPageId = "" then intPageId = 1
with objResults
.cursorlocation = 3
.open strSQLResults, objConn
.pagesize = 20
.absolutepage = intPageId
end with
intPages = cint( objResults.pagecount )
intCurrentPost = 0
do while not objResults.eof and intCurrentPost < objResults.pagesize
if bgcolor3 = "EFEFEF" then
bgcolor3 = "FFFFFF"
else
bgcolor3 = "EFEFEF"
end if
strContents = strContents &_
"<tr><td bgcolor=""#"&bgcolor3&""" width=""20%""><span class=""brod"">" & objResults( "userName" ) & "</span></td>" &_
"<td bgcolor=""#"&bgcolor3&""" width=""10%""><span class=""brod"">" & objResults( "userSex" ) & "</span></td>"&_
"<td bgcolor=""#"&bgcolor3&""" width=""10%""><span class=""brod"">"& DateDiff("yyyy", objResults("userAge"), Date())&" år</span></td>"&_
"<td bgcolor=""#"&bgcolor3&""" width=""20%""><span class=""brod"">"&objResults("userCity") &"</span></td>"&_
"<td bgcolor=""#"&bgcolor3&""" width=""20%""><span class=""brod"">"&objResults("userStatus")&"</span></td>"&_
"<td bgcolor=""#"&bgcolor3&""" width=""10%""><span class=""brod"">"&objResults("userYear")&"</span></td></tr>"
intCurrentPost = intCurrentPost + 1
objResults.movenext
loop
for i = 1 to objResults.pagecount
strNavigation = strNavigation & " <span class=""brod""><a href='?pageid=" & i & "&page=results'>" & i & "</a></span>"
next
response.write "<table class=""brod"">" & strResults & "</table>"
response.write "<table>" & strContents & "</table>"
response.write "<table><tr><td><span class=""brod"">Sidor:</span> " & strNavigation & "</td></tr></table>"
%>