<div class="title_bot"><script>ec(2);</script></div> <br> <?php <br /> $conn = mysql_connect("localhost","root","root") or die("数据库连接失入");<br> mysql_select_db("new",$conn);<br> ?><br> 分类:<select name="fid"><br> <?php <br /> function mainfl()<br> {<br> global $conn;<br> $result=mysql_query("select id,fid,name from a where fid=0 order by id ",$conn);//这里默认的fid=0,表示这是第一级。通过这个可以查出所有fid=0的项,即所有的第一级主类<br> if ($myrow=mysql_fetch_array($result))<br> {<br> do {<br> ?><br> <option value="<?php" echo>><?php echo $myrow["name"];?> </option>//$myrow["id"]输出主类的ID为查询子类做准备,$myrwo["name"]主类名字<br> <?php echo subfl($myrow["id"],"--");?>//调用子类函数subfl,使用--<?php <br /> }<br> while ($myrow=mysql_fetch_array($result));<br> }<br> }<br> //定义子级分类<br> function subfl($fid,$tag)//$fid那是主类ID,$tag为连接符<br> {<br> global $conn;<br> $result1=mysql_query("select id,fid,name from a where fid=$fid order by id",$conn);//查询出fid=$fid的所有面,这里的$fid值为$myrow["id"]<br> if ($myrow1=mysql_fetch_array($result1))<br> {<br> do {<br> ?><br> <option value="<?php" echo>><?php echo $tag.$myrow1["name"];?> </option>//输出子类<br> <?php <br /> subfl($myrow1["id"],"-".$tag);<br> }<br> while ($myrow1=mysql_fetch_array($result1));<br> }<br> }<br> echo mainfl();<br> ?><br> </select>