<%
sql="select top 4 * from xxhdp where classid="&request.QueryString("class2id")&" and weizhi=1 order by tuku_order_id desc"
set rhd=server.createobject("adodb.recordset")
rhd.open sql,conn,1,1
if not (rhd.eof and rhd.bof) then
do while not rhd.eof
%>
<%
rhd.movenext
loop
end if
rhd.close:set rhd=nothing
%>
<%=rs("gonggao")%>
教育新聞/news_<%=rs("class2id")%>/" target="_blank">more>
-
<%
set rr=conn.execute("select top 14 infoid,title,hongse from info where zhuanye="&request.QueryString("zy")&" and xuexiao="&request.QueryString("class2id")&" order by oederid desc,infoid desc")
if rr.eof and rr.bof then
response.Write("暫無記錄")
else
for i=1 to 14
%>
- .html" title="<%=rr("title")%>" target="_blank"> color="#FF0000"<%end if%>><%=rr("title")%> <% rr.movenext if rr.eof then exit for next end if %>
<%=rn("class2name")%>
咨詢電話：<%=rs("xftel")%>
- 專業(yè)方向 所屬專業(yè) 學(xué)費(fèi) 學(xué)制 詳情 在線報(bào)名 <% 'set rjj=conn.execute("select top 1 proid,zyfx,xuefei,xuezhi,proid,class2id from product where class2id="&rs("class2id")&" and xuexiao="&rn("class2id")&" and xxtj=1 and zyfx<>'' and isnull(rexiao,0)<>1 order by orderid desc") set rjj=conn.execute("select top 50 proid,zyfx,xuefei,xuezhi,proid,class2id from product where class2id="&rs("class2id")&" and xuexiao="&rn("class2id")&" and zyfx<>'' and isnull(rexiao,0)<>1 order by orderid desc") if rjj.eof and rjj.bof then response.Write("") else for i=1 to 50 %>
- .html" target="_blank"><%=rjj("zyfx")%> /" target="_blank"><%=rn("class2name")%> <%If rjj("xuefei")<>"" Then Response.write rjj("xuefei")&"元" Else Response.write "--" End If %> <%=rjj("xuezhi")%>年 .html" target="_blank">簡章查詢 /" target="_blank">在線報(bào)名 <% rjj.movenext if rjj.eof then exit for next end If rjj.close:Set rjj=Nothing %>
學(xué)員問答
-
<%
'sql="select top 15 * from pinglun where replay is not null and proid in(select proid from product where class2id="&request.QueryString("class2id")&") and source is null order by subdate desc"
set rsa=server.CreateObject("adodb.recordset")
sql="select top 15 * from("
sql=sql&"select a.* from pinglun a,product b where a.replay is not null and a.proid =b.proid and b.class2id="&request.QueryString("class2id")&" and a.source is null and a.verify=1"
sql=sql&" union all "
sql=sql&"select a.* from pinglun a,info b where a.replay is not null and a.proid=b.infoid and b.xuexiao="&request.QueryString("class2id")&" and a.source is not null and a.source!='kinfo' and a.verify=1"
'sql=sql&" union all "
'sql=sql&" select top 10 * from pinglun where replay is not null and shenhe=2 "
sql=sql&") c order by subdate desc"
'response.Write(sql)
rsa.open sql,conn,1,1
if rsa.eof and rsa.bof then
response.Write("暫無內(nèi)容")
else
do while not rsa.eof
source_t=rsa("source")
'replay=Replace(Replace(Replace(rsa("replay"),"
- <% elseif isnull(source_t) or source_t="" then source_t="guide" %>
- <% end if rsa.movenext loop end if %>
",""),"
","")," ","") replay=Replace(Replace(Replace(Replace(rsa("replay"),"",""),"
","")," ",""),"http://5370.com.cn/","/") if source_t="kinfo" then %>考試信息/kaoshixinxi_<%=rs("class2id")%>/" target="_blank">more>
-
<%
set rr=conn.execute("select TOP 9 infoid,hongse,title from info where class1id=15 and xuexiao="&request.QueryString("class2id")&" order by infoid desc")
if rr.eof and rr.bof then
response.Write("")
else
for i=1 to 9
%>
- .html" title="<%=rr("title")%>" target="_blank"> color="#FF0000"<%end if%>><%=rr("title")%> <% rr.movenext if rr.eof then exit for next end if %>
招生簡章/jianzhang_<%=rs("class2id")%>/" target="_blank">more>
-
<%
set rr=server.createobject("adodb.recordset")
sql="select top 10 proid,proname from proclass1_proclass2_product where class2id="&request.QueryString("class2id")&" and isnull(rexiao,0)<>1 order by proid desc"
rr.open sql,conn,1,1
if rr.eof and rr.bof then
response.Write("暫無記錄")
Else
for i=1 to 10
%>
- .html" title="<%=rr("proname")%>" target="_blank"><%=rr("proname")%> <% rr.movenext if rr.eof then exit for next end if %>
招生專業(yè)
- <%=cache_school_right_major%>
招生院校
- <%=cache_school_right_school%>