时间:2021-07-01 10:21:17 帮助过:17人阅读
{foreach from=$classlist item=newsclass}
{$newsclass.classname}
{/foreach}
$sql = "select * from jh_newsclass where parentid = 0";
$result = $mysqli->query($sql);
while ($row = $result->fetch_row()) {
$classlist[] = array(
'id'=>$row[0],
'classname'=>$row[2],
'parentid'=>$row[1],
'ispro'=>$row[3],
);
}
$result->close();
$mysqli->close();
$smarty->assign('classlist',$classlist);
$smarty->assign('webname',Webname);
$smarty->display('admin/left.htm');
新闻专题
<%
dim strs
Set Rs = server.CreateObject(JH_RS)
sql = "select * from jh_newsclass where parentid = 0"
Rs.Open SQL,Conn,1,1
while not rs.eof
%>
<%
set strs = conn.execute("select * from jh_newsclass where parentid = " & rs("id"))
if strs.eof and strs.bof then
%>
&newsclass=<%=rs("id")%><%if rs("ispro") then response.Write("&ispro=true")%>" target="main"><%=rs("classname")%>
<%
else
%>
<%=rs("classname")%>
<%
end if
%>
<%call showparentclass("+","--",rs("id"))%>
<%
rs.movenext
wend
rs.close
set rs = nothing
%>
<%
sub showparentclass(astr,tree,parentid)
dim showparentclassrs,temprs
set showparentclassrs = conn.execute("select * from Jh_newsclass where parentid = " & parentid)
if showparentclassrs.eof then
exit sub
else
response.Write("