类别和子类别
问题描述:
我有类别和子类别的问题。我不能得到类别相同的category_id子类别的数据。如何我定义的子类别CATEGORY_ID是相同类别CATEGORY_ID和子类别父为2类别和子类别
<?php
//connect to Mysql database
include "storescripts/connect_to_mysql.php";
// This block grabs the whole list for viewing
$dynamic_menu = "";
$sql = mysql_query("SELECT * FROM `category` WHERE `parent` IS NULL ORDER BY `category`.`name` ASC");
$productCount = mysql_num_rows($sql); // count the output amount
if ($productCount > 0)
\t {
\t while($row = mysql_fetch_array($sql)){
\t \t \t $id = $row["id"];
\t \t \t $name = $row["name"];
\t \t \t $parent = $row["parent"];
\t \t \t $category_id = $row["category_id"];
\t \t \t $dynamic_menu .= '<div class="menu-primary">
<li><a>'.$name.'</a></li></div>
\t \t \t \t <div class="menu-under">
<li><a>'.$name.'</a></li>
</div>';
}} else {
\t $dynamic_menu = "You have no products listed in our store yet";
}
?>
<div class="menu">
<?php echo $dynamic_menu; ?>
</div>
<!--
I'd like to html created like below
<div class="menu-primary">
\t <li><a>Kaamerad</a></li>
</div>
<div class="menu-under">
\t <ul>
<li><a>optikad</a></li>
<li><a>mälukaardid</a></li>
</ul>
</div>
-->
答
while循环中,必须包含另一个查询获取子类特定类别(从id字段获得后),即父级是某个类别Id的位置。
想看到您的数据库? – 2015-02-05 12:39:20
数据库链接中断 – Noy 2015-02-05 12:39:57
以下是数据库:http://postimage.org/image/zdcaq7ufn/ – 2015-02-05 12:54:49