Advertisement
Guest User

Untitled

a guest
Jul 17th, 2013
112
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
PHP 0.61 KB | None | 0 0
  1. $categories = array();
  2. $mainCategories = mysql_query("SELECT id, name FROM categories WHERE parent=0", $conn);
  3. while($ds = mysql_fetch_assoc($mainCategories))
  4. {
  5.     $categories[] = array(
  6.        "Name" => $ds["name"],
  7.        "Children" => GetChildren($ds["id"])
  8.      );
  9. }
  10.  
  11. function GetChildren($parent)
  12. {
  13.    $children = array();
  14.    $childCats = mysql_query("SELECT id, name FROM categories WHERE parent='".$parent."'");
  15.    while ($cat = mysql_fetch_array($childCats)) {
  16.      $children[] = array(
  17.        "Name" => $cat["name"],
  18.        "Children" => GetChildren($cat["id"])
  19.      );
  20.    }
  21.    return $children;
  22. }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement