请高手给我一点指示吧~~!
<%dim keyword
keyword=trim(request.Form("td"))
set ors=server.CreateObject("adodb.recordset")
conn.execute("select * from jcl_cla where MidCls='"&keyword&"'")
set rs=server.CreateObject("adodb.recordset")
sql="select * from jcl_photo where P_type="&ors ("id")
rs.open sql,conn,1,3
%>
明明2个表里的相同字段就是jcl_cla里的id和jcl_photo里的P_type了!
<%dim keyword
keyword=trim(request.Form("td"))
set ors=server.CreateObject("adodb.recordset")
conn.execute("select * from jcl_cla where MidCls='"&keyword&"'")
set rs=server.CreateObject("adodb.recordset")
sql="select * from jcl_photo where P_type="&ors ("id")
rs.open sql,conn,1,3
%>
明明2个表里的相同字段就是jcl_cla里的id和jcl_photo里的P_type了!
