catagory listing as links and sublinks ??

[Richi]

hi all ..

how can i do this !?
i have 1 table :

Field     | Type          
cid         | int(7)              
sort        |  int(3)           
sub        |  int(7)             
active   |  char(3)       
listed     | char(3)         
name     |   varchar(30)  
link         |  blob

if $sub is 0 then this main catagory else it`s sub, and then sub will have the same $cid for main catagory.


what i don`t know how to figure it , it`s to list it with this way , that at start will list just the main catagories , and when the user click on one of this will list under it the sub catagories for this main cat. some thing like this

Main1
. sub 1
. sub 1
. sub 1
Main2
main 3
.
.
etc.


so how, am trying to do this all the day with no resulet



THX ALOT FOR U HELP ..

[freddydoesphp]

Start Here

http://sitepointforums.com/showthrea...light=category

[ArjunaK]

I'm not quite sure of what you want to do

Take a look at this page. if what happens on the left frame is what you want to do then I will upload source code

http://www.disciplers.com/chinese.html

[Richi]

ArjunaK ... THX alot this what i need

[Richi]

freddydoesphp .. i had found this code too short for u code :

<?
    $result = mysql_query("select * from catagory  order by sort");

    while($row = mysql_fetch_array($result)) {
        extract($row); //loads the array $row into variables for each column(id becomes $id)
                //same as $id=$row["ID"]; for each column

        if($sub == 0) { //If the parent id is 0 then this is a main cat
            $tcats[$cid][] = array("cid" => $cid,
                                        "name" => $name,
                                        "sub" => $sub);
            } 
        else { //Or else this is a subcat
            $tcats[$sub][] = array("cid" => $cid,
                                            "name" => $name,
                                          "sub" => $sub);
            }
}



    foreach($tcats as $key => $val) {
        if(is_array($tcats[$key])) {
            foreach($tcats[$key] as $jey => $jal) {
               
                if($tcats[$key][$jey]['sub'] == 0) {     
                    $this_link="?menu=sub&cid=".$tcats[$key][$jey]['cid']."&sub=".$tcats[$key][$jey]['sub']."" ;
                      ?>
                      
                    .   <a href ="<?=$this_link?>"><?=$tcats[$key][$jey]['name']?></a><br>
                      <?}
                      if($menu=="sub"){
                      if($tcats[$key][$jey]['sub'] != 0) { 
                          $this_sub_link="?cid=".$tcats[$key][$jey]['cid']."&sub=".$tcats[$key][$jey]['sub']."" ;
                          ?>
                          
                          &nbsp;&nbsp; - <a href ="<?=$this_sub_link?>"><?=$tcats[$key][$jey]['name']?></a><br>
                          
                          <?}
                          
    }
}
}
}

?>

am trying to modify it to make as i need links & sub links, when user click on link will list the sub links, and when he click on another link the old listed sub links will close and list the new one !

something link what ArjunaK had done .

[freddydoesphp]

No it doesn't close the sublink when not active, but the great thing about it is, its a class and it get be extended without too much effort to do what you need.

[ArjunaK]

Ok I've got the code in a Zip but I cant figure out how to upload it

Arjuna

[Richi]

ArjunaK

would u please ur PM ...

[Richi]

i got ur email .. thx alot again, i`ll check it now !