Hi
I am have one categories table cat_id,Cat_name the cat id varchar(18)
the first 3digits in on category. i am Using for 6levels. ie every 3digits is subcategory of preveious one.
0010000000000 Engineering
0010010000000 Civil Engineering
0010010010000 Structural Engineering
0010020000000 Mechanical Engineering
I want to Display Like tree stucture.
I want One select statement that can give
like
Engineering
Civil Engineering
Structural Engineering
Mechanical Engineering
like Sub queries in Oracle how can query and use php script to delimit.
any one can help This I am Thank full to U
Thanks
Regds
Ramarao
