/* //print_r($rs); //生成类别下的文章 $sql="select * from ff_article where auditing=1 and (classID=".$rs->fields["id"]." or classID in (select id from ff_artClass where topClass=".$rs->fields["id"].")) and pic<>'' order by onTop desc,sort,id desc"; $rs2=$DB->SelectLimit($sql,3); $t->assign("piclist",$rs2->GetRows(3)); $sql="select * from ff_article where auditing=1 and (classID=".$rs->fields["id"]." or classID in (select id from ff_artClass where topClass=".$rs->fields["id"].")) and pic='' order by onTop desc,sort,id desc"; $rs2=$DB->SelectLimit($sql,12); $t->assign("datalist",$rs2->GetRows(12)); */ $rs->MoveNext(); } $rs->MoveFirst(); $t->assign("classlist",$rs->GetRows(50));类别读出来是没有问题,但是下面的文章总是读不出来。对smarty了解不深,所以这个的也很烦恼我啊。纠结
<!-- BEGIN piclist --> <table width="100%" border="0" cellspacing="0" cellpadding="0"> <tr> <td><img src="{pic}" width="96" height="96" alt="" /></td> </tr> <tr> <td>{title}</td> </tr> </table> <!-- END piclist --> </div> <div class="right"> <ul> <!-- BEGIN datalist --> <li><a href="#">{title}</a></li> <!-- END datalist --> </ul> </div> </div> </div> {/section} $sql="select * from ff_artClass where classLevel=1 order by onTop desc,sort,id desc"; $rs=$DB->SelectLimit($sql,50); $rows=$rs->RecordCount(); for($i=0;$i<$rows;$i++){ //print_r($rs); //生成类别下的文章 $sql="select pic,title from ff_article where auditing=1 and (classID=".$rs->fields["id"]." or classID in (select id from ff_artClass where topClass=".$rs->fields["id"].")) and pic<>'' order by onTop desc,sort,id desc"; $rs2=$DB->SelectLimit($sql,3); $t->assign("piclist",$rs2); $sql="select title from ff_article where auditing=1 and (classID=".$rs->fields["id"]." or classID in (select id from ff_artClass where topClass=".$rs->fields["id"].")) and pic='' order by onTop desc,sort,id desc"; $rs2=$DB->SelectLimit($sql,12); $t->assign("datalist",$rs2); $rs->MoveNext(); } $rs->MoveFirst(); $t->assign("classlist",$rs->GetRows(50));
{
{pic}
{title}
}while() // 读 4-10条 ..
{
{title}
}
{if ($smarty.section.classlist.index + 1)%2==0}
<div class="datatable2">
{else}
<div class="datatable1">
{/if}
<div class="title"><h2>{$classlist[classlist].className}</h2><span class="more">更多>></span></div>
<div class="box">
<div class="left">
{section name="piclist" loop=$piclist}
<table width="100%" border="0" cellspacing="0" cellpadding="0">
<tr>
<td><img src="{$piclist[piclist].pic}" width="96" height="96" alt="" /></td>
</tr>
<tr>
<td>{$piclist}</td>
</tr>
</table>
{/section}
</div>
<div class="right">
<ul>
{section name="datalist" loop=$datalist}
<li><a href="#"></a></li>
{/section} </ul>
</div>
</div>
</div>
{/section}PHP的: $sql="select * from ff_artClass where classLevel=1 order by onTop desc,sort,id desc";
$rs=$DB->SelectLimit($sql,50);
$rows=$rs->RecordCount();
for($i=0;$i<$rows;$i++){
/* //print_r($rs);
//生成类别下的文章
$sql="select * from ff_article where auditing=1 and (classID=".$rs->fields["id"]." or classID in (select id from ff_artClass where topClass=".$rs->fields["id"].")) and pic<>'' order by onTop desc,sort,id desc";
$rs2=$DB->SelectLimit($sql,3);
$t->assign("piclist",$rs2->GetRows(3));
$sql="select * from ff_article where auditing=1 and (classID=".$rs->fields["id"]." or classID in (select id from ff_artClass where topClass=".$rs->fields["id"].")) and pic='' order by onTop desc,sort,id desc";
$rs2=$DB->SelectLimit($sql,12);
$t->assign("datalist",$rs2->GetRows(12));
*/
$rs->MoveNext();
}
$rs->MoveFirst();
$t->assign("classlist",$rs->GetRows(50));类别读出来是没有问题,但是下面的文章总是读不出来。对smarty了解不深,所以这个的也很烦恼我啊。纠结
$t->assign("classlist",$rs->GetRows(50));
搞了上面一小块而已
{section name="classlist" loop=$classlist}
{if ($smarty.section.classlist.index + 1)%2==0}
<div class="datatable2">
{else}
<div class="datatable1">
{/if}
<div class="title"><h2>{$classlist[classlist].className}</h2><span class="more">更多>></span></div>
<div class="box">
<div class="left">
<!-- BEGIN piclist -->
<table width="100%" border="0" cellspacing="0" cellpadding="0">
<tr>
<td><img src="{pic}" width="96" height="96" alt="" /></td>
</tr>
<tr>
<td>{title}</td>
</tr>
</table>
<!-- END piclist -->
</div>
<div class="right">
<ul>
<!-- BEGIN datalist -->
<li><a href="#">{title}</a></li>
<!-- END datalist --> </ul>
</div>
</div>
</div>
{/section}
$sql="select * from ff_artClass where classLevel=1 order by onTop desc,sort,id desc";
$rs=$DB->SelectLimit($sql,50);
$rows=$rs->RecordCount();
for($i=0;$i<$rows;$i++){
//print_r($rs);
//生成类别下的文章
$sql="select pic,title from ff_article where auditing=1 and (classID=".$rs->fields["id"]." or classID in (select id from ff_artClass where topClass=".$rs->fields["id"].")) and pic<>'' order by onTop desc,sort,id desc";
$rs2=$DB->SelectLimit($sql,3);
$t->assign("piclist",$rs2);
$sql="select title from ff_article where auditing=1 and (classID=".$rs->fields["id"]." or classID in (select id from ff_artClass where topClass=".$rs->fields["id"].")) and pic='' order by onTop desc,sort,id desc";
$rs2=$DB->SelectLimit($sql,12);
$t->assign("datalist",$rs2);
$rs->MoveNext();
}
$rs->MoveFirst();
$t->assign("classlist",$rs->GetRows(50));