| 搜索 |
php 三级分类问题（非递归方式），怎么从数据库中取出？怎么smarty成一下形式？
日志
--我的日志
----我的日志1
--你的日志
----你的日志1
新闻
--国内新闻
----国内新闻1
--国际新闻
----国际新闻1
数据库结构如下:
<?php
$html = '';
$conn = mysql_connect('localhost','***','****');
mysql_select_db('test',$conn);
mysql_query("set charset utf8");
$level1 = "select * from threelevel where fid = '0'";
$rs1 = mysql_query($level1,$conn);
while($r1 = mysql_fetch_array($rs1)) {
$html .= "--".$r1['name']."<br />";
$level2 = "select * from threelevel where fid = ".$r1['id'];
$rs2 = mysql_query($level2,$conn);
if (mysql_num_rows($rs2) > 0) {
while ($r2 = mysql_fetch_array($rs2)) {
$html .= "----".$r2['name']."<br />";
$level3 = "select * from threelevel where fid = ".$r2['id'];
$rs3 = mysql_query($level3,$conn);
if (mysql_num_rows($rs3) > 0) {
while ($r3 = mysql_fetch_array($rs3)) {
$html .= "------".$r3['name']."<br />";
}
}
}
}
}
$smarty->assign('category',$html);
?>
<?php
$conn = mysql_connect('localhost','***','****');
mysql_select_db('test',$conn);
mysql_query("set charset utf8");
$level1 = "select * from threelevel where fid = '0'";
$rs1 = mysql_query($level1,$conn);
while($r1 = mysql_fetch_array($rs1)) {
echo "--".$r1['name']."<br />";
$level2 = "select * from threelevel where fid = ".$r1['id'];
$rs2 = mysql_query($level2,$conn);
if (mysql_num_rows($rs2) > 0) {
while ($r2 = mysql_fetch_array($rs2)) {
echo "----".$r2['name']."<br />";
$level3 = "select * from threelevel where fid = ".$r2['id'];
$rs3 = mysql_query($level3,$conn);
if (mysql_num_rows($rs3) > 0) {
while ($r3 = mysql_fetch_array($rs3)) {
echo "------".$r3['name']."<br />";
}
}
}
}
}
?>