سلام به این کد ها ی نگاه بنداز شاید به دردت بخوره
CREATE TABLE categories (
category_id INT UNSIGNED NOT NULL AUTO_INCREMENT,
parent_id INT UNSIGNED NOT NULL DEFAULT 0,
name TEXT NOT NULL,
user INT NOT NULL,
PRIMARY KEY (category_id),
INDEX parent (parent_id)
);
category_id parent_id name user
1 0 Main category 1 2
2 1 Subcategory 1 2
3 1 Subcategory 2 2
4 3 SubSubcategory 1 2
$user_result = mysql_query("SELECT * FROM users, categories WHERE id = '$id'");
$categories = array();
while($row = mysql_fetch_array($user_result)) {
$categories[$row['parent_id']][] = $row['name'];
}
echo "<ol><li><a href''>$categories[0][0]</a><ol>";
$counterj = count($categories)-1;
for($i=1,$j=$counterj;$i<$j;$i++){
if(count($categories[$i])==1){
echo "<li><a href="">$catgeories[$i][0]</a></li>";
} else {
echo "<li><a href="">$categories[$i][0]</a><ol>";
}
$counterl = count($categories[$i])-1;
for($k=1,$l=$counterl;$k<$l;$k++){
echo "<li><a href="">$categories[$i][$k]</a></li>";
}
if ($l>1) echo "</ol></li>";
}
echo "</ol></li></ol>";
} else {
echo "You are not admin";
}
موفق باشی