sql="select * from love_main where username='"&username&"'"
set rs = Server.CreateObject("ADODB.Recordset")
rs.Open sql,conn,1,1
IF (rs.BOF=true and rs.EOF =true) or rs.RecordCount=0 THEN
RESPONSE.Write"<table><tr><td><BR><BR> 暂无照片,[<a href=u_mod.asp?submitok=five>立即上传</a>]"
rs.close
elseIf rs("photo_x_flag")="1" and rs("photo_d_flag")="1" Then'大小都有
response.write "<img src=photo/"&rs("photo_x")&" width=55 height=45 border=0 hspace=4 vspace=4 >"
ElseIf rs("photo_x_flag")="1" and rs("photo_d_flag")="0" Then'有小无大
response.write "<img src=photo/"&rs("photo_x")&" width=55 height=45 border=0 hspace=4 vspace=4 >"
ElseIf rs("photo_d_flag")="1" and rs("photo_x_flag")="0" Then'有大无小
response.write "<img src=photo/"&rs("photo_d")&" width=55 height=45 border=0 hspace=4 vspace=4 >"
Else
if rs("sex")="男" then
response.write "<img src=images/nophoto_man.gif width=55 height=45 hspace=4 vspace=4>"
else
response.write "<img src=images/nophoto_woman.gif width=55 height=45 hspace=4 vspace=4>"
end if
End If
rs.close
搞定了..哈哈..
set rs = Server.CreateObject("ADODB.Recordset")
rs.Open sql,conn,1,1
IF (rs.BOF=true and rs.EOF =true) or rs.RecordCount=0 THEN
RESPONSE.Write"<table><tr><td><BR><BR> 暂无照片,[<a href=u_mod.asp?submitok=five>立即上传</a>]"
rs.close
elseIf rs("photo_x_flag")="1" and rs("photo_d_flag")="1" Then'大小都有
response.write "<img src=photo/"&rs("photo_x")&" width=55 height=45 border=0 hspace=4 vspace=4 >"
ElseIf rs("photo_x_flag")="1" and rs("photo_d_flag")="0" Then'有小无大
response.write "<img src=photo/"&rs("photo_x")&" width=55 height=45 border=0 hspace=4 vspace=4 >"
ElseIf rs("photo_d_flag")="1" and rs("photo_x_flag")="0" Then'有大无小
response.write "<img src=photo/"&rs("photo_d")&" width=55 height=45 border=0 hspace=4 vspace=4 >"
Else
if rs("sex")="男" then
response.write "<img src=images/nophoto_man.gif width=55 height=45 hspace=4 vspace=4>"
else
response.write "<img src=images/nophoto_woman.gif width=55 height=45 hspace=4 vspace=4>"
end if
End If
rs.close
搞定了..哈哈..
面朝大海,春暖花开!