6 svar · 171 visningar · startad av Rodan
hej
jag har två strängar.. som jag kallar de:P
1.Addera = "Select * From friends where ToiD =" &session("id") &" AND Approved = Yes order by relation desc"
2.Addera2 = "Select * From friends where fromiD =" &session("id") &" AND Approved = Yes order by relation desc"
hur kan man göra så att man slipper använda då?
H/Rodan
kan de va ?
Addera = "Select * From friends where ToiD,fromiD =" &session("id") &" AND Approved = Yes order by relation desc"
Addera = "Select * From friends where " & session("id") &" in (toid,fromid) AND Approved = Yes order by relation desc"
tack,tack och tusen tack, åter kommer med andra liknande frågor :P
en annan fråga då...
jag vill ordna mina vänner typ så här
Vänner:
Olle
Hatobjekt:
Per
osv
nu undrar jag, hur kan jag göra de på de enklaste sättet ? jag har en väldig krånglig kod... ni får se den här...
<%
Set Connect = Server.CreateObject("ADODB.Connection")
Connect.Open "driver={Microsoft Access Driver (*.mdb)};dbq=" & Server.MapPath("databas/friends.mdb")&";"
Set rs = Server.CreateObject("ADODB.Recordset")
Addera = "Select * From friends where " & session("id") &" in (toid,fromid) AND Approved = Yes order by relation desc"
rs.Open Addera, Connect, 3, 3
if not rs.eof then
%><b><font face="Verdana">
<html>
<head>
<LINK REL=stylesheet HREF="SwedenWorld.css" TYPE="text/css">
<body class="bg">
</font></b>
<table width="553" class="ram" cellspacing="0" bordercolor="#000000" bgcolor="#FFFFFF" border="0" style="border-collapse: collapse" cellpadding="0">
<tr><td colspan="5" width="549" height="29"><font class="text"><%=rs("Toname")%><font face="Verdana"><b>
</b></font><font face="Verdana">'s <b>VÄNNER:</b></font><hr color="navy" size="1"></td></tr>
<% do until rs.eof%><b><font face="Verdana"> </font></b>
<tr><td width="123" height="12"><font class="text">
<% if rs("toid") = session("id") then %><font face="Verdana"><b>
<%else%> </b>
</font>
<%=rs("relation")%></td><td width="122" height="12">
<a href="whois.asp?checkid=<%=rs("toid")%>" target="inne">
<%=rs("Toname")%></a></td><td width="97" height="12">
<%=rs("age")%><font face="Verdana"><b> </b></font>
<b>
<a href="do_delete_friend.asp?delid=<%=rs("id")%>" target="inne"><font face="Verdana" color="#000000">Ta bort</font></a><font face="Verdana">
</font>
</b>
</td></tr>
<tr><td width="123" height="10">
<%end if%><font face="Verdana"><b>
<% if rs("fromid") = session("id") then %>
<%else%> </b>
</font>
<%=rs("relation")%></td><td width="122" height="10">
<a href="whois.asp?checkid=<%=rs("fromid")%>" target="inne">
<%=rs("namn")%></a></td><td width="97" height="10">
<%=rs("fromage")%><font face="Verdana"><b> </b></font>
<b>
<a href="do_delete_friend.asp?delid=<%=rs("id")%>" target="inne"><font face="Verdana" color="#000000">
Ta bort</font></a><font face="Verdana">
</font>
</b>
</td></tr>
<%end if%><b>
<%
rs.movenext
loop
rs.close
connect.close
%>
kan väl säga att den är väldigt stökig:P
ingen ?