zp.asp
<%
Response.Buffer =true
Response.ContentType="gif/image"
dim sql_picture
dim picture_rs
sql_picture="select zp from zp_tab where id = '"+request("id")+"'"
set picture_rs=conn.execute(sql_picture)
Response.BinaryWrite picture_rs.fields("zp").value
%>
zplist.asp
<title>照片</title>
<body leftmargin="0" topmargin="0" marginwidth="0" marginheight="0" scroll=no>
<%
set rs=server.createobject("adodb.recordset")
sql="select * from zp_tab order by id"
rs.Open sql, conn, 3, 3
if not rs.eof then
rs.move currec
do while not rs.eof
Response.Write "<img border=0 width=90 height=120 align=center src=zp.asp?id="&id&"&type=1> "
rs.movenext
loop
end if
%>