0

I'm beginner of Php .. I Develop my first dynamic website -> http://wwww.afrogfx.com
if you look at my sidebar you will see categories list my problem located here if i create sub sub categories like that

    CAT A
    - SUB CAT A-1
    - SUB CAT A-2
      -- SUB CAT A-3 ( problem Here )
    CAT B
    - SUB CAT B-1
    - SUB CAT B-2
    - SUB CAT B-2-a
      -- SUB CAT B-2-b ( problem Here )
       --- SUB CAT B-3 ( problem Here )

categories list code

    <?php 
    mysql_select_db($db_name, $conn); // Change for your database  
    $query_Recordset1 = "SELECT catid,catname,parentid FROM categories ";
    $Recordset1 = mysql_query($query_Recordset1, $conn) or die(mysql_error()); // Change for your database


    while ( $row = mysql_fetch_assoc($Recordset1) )
    {
    $menu_array[$row['catid']] = array('catname' => $row['catname'],'catid' =>         $row['catid'],'parentid' => $row['parentid']);

    }
    //recursive function that prints categories as a nested html unordered list

    function generate_menu($parent)
    {
    $has_childs = false;
    //this prevents printing 'ul' if we don't have subcategories for this category
    global $menu_array;
    //use global array variable instead of a local variable to lower stack memory         requierment
    foreach($menu_array as $key => $value)
    {
    if ($value['parentid'] == $parent) 
    {       
    //if this is the first child print '<ul>'                       
    if ($has_childs === false)
    {
    //don't print '<ul>' multiple times                             
    $has_childs = true;
    //echo '<ul>';
    echo '<ul id="categories">';
    }
    echo '<li><a href="categories?catid=' . $value['catid'] . '&parentid=' .                 $value['parentid'] . '&catname=' . $value['catname'] .'">' .         $value['catname'] . '</a>';
    echo '<input type="hidden" value="' . $value['catname'] . '" />';
    generate_menu($key);

    //call function again to generate nested list for subcategories belonging to this         category

    echo '</li>';
    }
    }

    if ($has_childs === true) echo '</ul>';
    }
    //generate menu starting with parent categories (that have a 0 parent)
    ?>

now i need function to select all topic in main category when i select it and sub category to & sub sub category !! how can i do it ?? !!

2
Contributors
1
Reply
16
Views
4 Years
Discussion Span
Last Post by pritaeas
This topic has been dead for over six months. Start a new discussion instead.
Have something to contribute to this discussion? Please be thoughtful, detailed and courteous, and be sure to adhere to our posting rules.