21,893
社区成员




$db=new mysql(DB_HOST,DB_USER,DB_PW,DB_NAME,"conn","gbk");
$SQL="select catid,fid,catName,url from gen_category";
$rs=$db->query($SQL);
$rows=mysql_num_rows($rs);
$i=0;
while($row = $db->fetch_array($rs))
{
$arrAll[]=$row;
if ($row[fid]==0)
{
$arr[]=$row;
}
$SQL="select ctitle,ccontent from gen_info where cid=".$arrAll["$i"][0];
echo $SQL;
$i=$i+1;
$rs1=mysql_query($SQL);
while($row1 = mysql_fetch_array($rs1))
{
echo $row1['ctitle']."<br>";
$arrArticle=$row1;
}
$tpl->assign('indexContent',$arrArticle);
}
$tpl->assign('Variable',$arr);
$tpl->display('index.html');
<div id="main">
<div id="main_left">
</div>
<div id="main_right">
<{section name=lp loop=$Variable }>
<div id="cat">
<div id="catTitle">
<a href="<{$Variable[lp].url}>"><{$Variable[lp].catName}></a>
</div>
<{section name=lp1 loop=$indexContent}>
<{$indexContent[lp1].ctitle}><br>
<{/section}>
</div>
<{/section}>
</div>
</div>
$db=new mysql(DB_HOST,DB_USER,DB_PW,DB_NAME,"conn","gbk");
$db2=new mysql(DB_HOST,DB_USER,DB_PW,DB_NAME,"conn","gbk");
$SQL="select catid,fid,catName,url from gen_category";
$rs=$db->query($SQL);
$i=0;
$myarray = array();
while($row = $db->fetch_array($rs))
{
$myclass = new stdClass;
if ($row[fid]==0){
$myclass->catName = $row["catName"];//类别title
$myclass->url = $row["url"];//类别url
}else{
continue;
}
$SQL="select ctitle,ccontent from gen_info where cid=".$row["catid"];
$rs1=$db2->query($SQL);
while($row1 = mysql_fetch_array($rs1))
{
$myclass->ccontent = $row1["ccontent"];//内容
}
$myarray[$row["catid"]]=$myclass;
}
$tpl->assign('myarray',$myarray);
$tpl->display('index.html');
<div id="main">
<div id="main_left">
</div>
<div id="main_right">
<{foreach from=$myarray item=$myclass}>
<div id="cat">
<div id="catTitle">
<a href="<{$myclass->url}>"><{$myclass->catName}></a>
</div>
<{$myclass->ccontent}><br>
</div>
<{/foreach}>
</div>
</div>
$db=new mysql(DB_HOST,DB_USER,DB_PW,DB_NAME,"conn","gbk");
$db2=new mysql(DB_HOST,DB_USER,DB_PW,DB_NAME,"conn","gbk");
$SQL="select catid,fid,catName,url from gen_category";
$rs=$db->query($SQL);
$i=0;
$myarray = array();
while($row = $db->fetch_array($rs))
{
$myclass = new stdClass;
if ($row[fid]==0){
$myclass->catName = $row["catName"];//类别title
}else{
continue;
}
$SQL="select ctitle,ccontent from gen_info where cid=".$row["catid"];
$rs1=$db2->query($SQL);
while($row1 = mysql_fetch_array($rs1))
{
$myclass->catName = $row1["ccontent"];//内容
}
$myarray[$row["catid"]]=$myclass;
}
$tpl->assign('Variable',$arr);
$tpl->display('index.html');