如果c_parent = 0 显示的图片为当前图片显示的ID,如果c_parnet <>0 图片显示的为其父的ID ,列如 c_parent=2 它的图片显示为"关于我们"这一栏的图片,大家帮忙给我写一下,非常感谢

<%Set rs = Server.CreateObject("ADODB.Recordset")
if c_parent = 0 then
rs.open "select * from cms_channel where id="&request("id"),conn,1,3
if  not rs.eof then
response.write("<img src="&rs("upload_pic")&">")
end if
rs.close
end if
%>

rs.open "select * from cms_channel where id="&request("id"),conn,1,3 、
不等于0读取的时候这里改为
rs.open "select * from cms_channel where id="&c_parent,conn,1,3
不就读取到了吗？

谢谢了

楼主，帮你做了一些修改，你试一下，看能否满足要求？

<%Set rs = Server.CreateObject("ADODB.Recordset")
if c_parent = 0 then
'rs.open "select * from cms_channel where id="&request("id"),conn,1,3
rs.open "select case when a.c_parent=0 then a.upload_pic else b.upload_pic end as upload_pic from cms_channel a left join cms_channel b on a.c_parent=b.id  and a.id="&request("id"),conn,1,3
if  not rs.eof then
response.write("<img src="&rs("upload_pic")&">")
end if
rs.close
end if
%>