test2.htm <html> <head> <title>巢状循环测试</title> </head> <body> <{section name=sec1 loop=$row_array}> <table width="322" border="1" align="center" cellpadding="3" cellspacing="0"> <tr> <td colspan="2"><{$row_array[sec1].cat_id}></td> </tr> <{section name=sec2 loop=$row_array[sec1].post}> <tr> <td width="160">post_title:<{$row_array[sec1].post[sec2].post_title}> </td> <td width="160">post_date:<{$row_array[sec1].post[sec2].post_date}></td> </tr> <{/section}> </table> <{/section}> </body> </html> test2.php <?php require_once('./include/db_fns.php'); include_once("./Smarty/libs/Smarty.class.php"); //包含Smarty类文件 $smarty = new Smarty(); //建立Smarty实例对象$Smarty $smarty->template_dir = "./templates/dedecms";//设置模板目录 $smarty->compile_dir = "templates/templates_c"; //设置编译目录 $smarty->assign("template_url", "./"); $smarty->assign("$site_url", "http://www.gotop.net.ru"); $smarty->assign("$site_name", "文章管理系统"); $smarty->left_delimiter = "<{"; //设置左边界符 $smarty->right_delimiter = "}>"; //设置右边界符 $db_conn = db_connect(); $query = "SELECT cat_id,cat_name FROM categories ORDER BY cat_ID DESC"; $result = mysql_query($query); while($row = mysql_fetch_array($result)) { $query2="SELECT post_id, post_title, post_date FROM post WHERE post.post_category =$row[cat_id] AND post_status <> 'unpublish' ORDER BY post_date DESC LIMIT 5"; //这里加一个 LIMIT 5 不要用什么$i来控制 $result2=mysql_query($query2); while($row2 = mysql_fetch_array($result2)) { $post[]=array('post_id'=>$row2['post_id'], 'post_title'=>$row2['post_title'], 'post_date'=>date('m-d',strtotime($row2[post_date])) ); } $row_array[] = array('cat_id'=>$row['cat_id'], 'cat_name'=>$row['cat_name'], 'post'=>$post ); unset($post); //$post[]在使用完后要注销,因为使用赋值语句对$post进行赋值时不会 //将它清空,而是将新数组作为它的一个元素增加,为了不产生副作用,这里使用unset()是必需的. //如果不注销，第二次循环的结果会包含第一循环的数据，如分类2的文章跑到分类1中来。 } echo"</br>row_array数组:</br>"; print_r($row_array);//打出来看看有没有数据 $smarty->assign("row_array", $row_array); $smarty->display("test2.htm"); ?> <select> <option value="0">选择地区</option> {section name=sec loop=$quyu} <option value="{$quyu[sec].id}">{$quyu[sec].name}</option> {foreach name=fenqu item=item from=$quyu[sec].fenqu} <option value="{$item.id}">{$item.name}</option> {/foreach} {/section} </select> 弄了很久才自己弄出来了,这个东西以后还是要经常使用的-_-|| [quyu] => Array ( [0] => Array ( [0] => 1 [id] => 1 [1] => 西湖区 [name] => 西湖区 [fenqu] => Array ( [0] => Array ( [0] => 1 [id] => 1 [1] => 西湖城区沿线 [name] => 西湖城区沿线 ) [1] => Array ( [0] => 2 [id] => 2 [1] => 西湖景区 [name] => 西湖景区 ) ) ) [1] => Array ( [0] => 2 [id] => 2 [1] => 上城区 [name] => 上城区 [fenqu] => Array ( [0] => Array ( [0] => 7 [id] => 7 [1] => 吴山广场/河坊街 [name] => 吴山广场/河坊街 ) [1] => Array ( [0] => 8 [id] => 8 [1] => 解放路沿线 [name] => 解放路沿线 ) [2] => Array ( [0] => 9 [id] => 9 [1] => 清泰街沿线 [name] => 清泰街沿线 ) [3] => Array ( [0] => 10 [id] => 10 [1] => 湖滨路/平海路 [name] => 湖滨路/平海路 ) [4] => Array ( [0] => 11 [id] => 11 [1] => 江城路沿线 [name] => 江城路沿线 ) ) ) [2] => Array ( [0] => 3 [id] => 3 [1] => 下城区 [name] => 下城区 [fenqu] => Array ( [0] => Array ( [0] => 12 [id] => 12 [1] => 武林广场/杭百 [name] => 武林广场/杭百 ) [1] => Array ( [0] => 13 [id] => 13 [1] => 凤起路沿线 [name] => 凤起路沿线 ) [2] => Array ( [0] => 14 [id] => 14 [1] => 朝晖地区 [name] => 朝晖地区 ) [3] => Array ( [0] => 15 [id] => 15 [1] => 庆春路沿线 [name] => 庆春路沿线 ) ) ) [3] => Array ( [0] => 4 [id] => 4 [1] => 拱墅区 [name] => 拱墅区 [fenqu] => Array ( [0] => Array ( [0] => 16 [id] => 16 [1] => 信义坊 [name] => 信义坊 ) ) ) [4] => Array ( [0] => 5 [id] => 5 [1] => 江干区 [name] => 江干区 [fenqu] => Array ( [0] => Array ( [0] => 17 [id] => 17 [1] => 城东 [name] => 城东 ) ) ) [5] => Array ( [0] => 6 [id] => 6 [1] => 滨江区 [name] => 滨江区 [fenqu] => Array ( ) ) [6] => Array ( [0] => 7 [id] => 7 [1] => 近郊 [name] => 近郊 [fenqu] => Array ( [0] => Array ( [0] => 18 [id] => 18 [1] => 萧山 [name] => 萧山 ) ) ) ) )