我再重写一遍代码,希望有助于高手来分析.
我想要的结果是:有图片的显示其相关图片,没图片的,显示012.jpg;
[注:若不加此判断语句,有显示图片正常,我怀疑,是不是与 do while not(rs_new.eof) 语句有关]
<%i=1%>
<% do while not(rs_new.eof) and i<11 %>
<%
Set connpic = Server.CreateObject("ADODB.Connection")
DBPath = Server.MapPath("data/picture.asp")
connpic.Open "driver={Microsoft Access Driver (*.mdb)};dbq=" & DBPath
Set rs_pic = Server.CreateObject("ADODB.Recordset")
sql="select * from pic "
rs_pic.open sql,connpic,1,1
%>
<% if photo>0 then%>
<a href='read.asp?user_id=<%=rs_new("user_id")%>'> <img border="1" src="display2.asp?user_id=<%=rs_new("user_id")%> " width="90" height="120"></a>
<% else if photo=0 then %>
<a href='read.asp?user_id=<%=rs_new("user_id")%>'> <img border="1" src="image/012.jpg" width="90" height="120"></a>
<%end if%>
<%i=i+1%>
<%rs_new.movenext%>
<%loop%>
<%rs_new.close%>