<option value="1">--Web fink--</option>
<option value="2">
<% '从news表中读取友情连接
Set Rs1 = Server.CreateObject("ADODB.RecordSet")
Sql1="Select * From news where nfrom='英文' and typeid=66"
Rs1.Open Sql1,conn,1,1
Do While not Rs1.EOF
Response.Write "<option ><a href="& trim(rs1("link")) &">"& rs1("Title") &"</a></option>"
Rs1.MoveNext
Loop
Rs1.Close
Set Rs1=nothing
%>
</option>
</select>
</div>
</form></td>
</tr>
</table>
在做友情连接的时候,怎么连接不上数据库里数据作者: lianeh 时间: 2010-1-7 23:49
<% Do While not Rs1.EOF %>
<option ><a href="<%=rs1("link")%>">rs1("Title")</a></option>
<%Rs1.MoveNext
Loop
Rs1.Close
Set Rs1=nothing
%>作者: 青苹果 时间: 2010-1-7 23:49
<% Do While not Rs1.EOF %>
<option ><a href="<%=rs1("link")%>"><%=rs1("Title")%></a></option>
<%Rs1.MoveNext
Loop
Rs1.Close
Set Rs1=nothing
%>