% Set Connect = Server.CreateObject("Adodb.Connection") Connect.Open strCon SQL = "SELECT COUNT(id) AS Antal, user, kon, alder, loggain, id, intFoto FROM anv WHERE intFoto = 1 GROUP BY user, kon, alder, loggain, id, intFoto DESC" Set RS = Connect.Execute(SQL) %>
|
<%
x = 0
do until x = 7 OR RS.EOF = TRUE
x = x +1
%>
- <%
strBirth = CDate(RS("alder"))
strAge = Int(DateDiff("m", strBirth, Date)/12)
If RS("kon") = "Pojke" Then
Response.Write "Pojke" & strAge
Else
Response.Write "Flicka" & strAge
End If
%>" href="minsida.asp?id=<%=RS("id")%>">
<%
SQL = "SELECT bild, id FROM anv WHERE id= " & RS("id") & ""
Set RS2 = Connect.Execute(SQL)
%>
|