<% id=checkstr(request.querystring("id")) if id="" then response.end rs.open "update photos set hits=hits+1 where id="&request("id"),conn,3,3 sql="select id,bid,mid,fnam,nam,cont,hits from photos where id="&id rs.open sql,conn,1,1 if rs.eof then response.end bid=trim(rs(1)) mid1=trim(rs(2)) fnam=trim(rs(3)) name1=trim(rs(4)) cont=trim(rs(5)) hits=trim(rs(6)) rs.close sql="select nam from photo_class where id="&bid rs.open sql,conn,1,1 if rs.eof then response.end nam=trim(rs(0)) rs.close %> <% if mid1<>"0" then sql="select nam from photo_mid_class where id="&mid1 rs.open sql,conn,1,1 if rs.eof then response.end nam1=trim(rs(0)) rs.close end if %>