我再重写一遍代码,希望有助于高手来分析.

我想要的结果是:有图片的显示其相关图片,没图片的,显示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%>