% sql="select top 1 * from news where wzgg=1 order by NewsID desc" Set rs= Server.CreateObject("ADODB.Recordset") rs.open sql,conn,1,1 mynewsid=rs("newsid") mytitle=rs("title") %><% sql2="select user,name,ch from corporation where id="&session("id")&"" set rs2=conn.execute(sql2) %>
|