时间: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("