heirarchy in table.

[nitinr]

i have table catagory with fields:-<br><br>cat_id int(11)PRI auto_increment ¦<br>cat_name&nbsp;&nbsp;varchar(100)¦&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;¦<br>parent_cat int(11) <br><br>where parent_cat is cat_id of another record.<br>means one record is child of another..<br>how can i display the hierarchy with minimum query..<br>

 

[abhyadon]

Hi Nitin,
I saw your query posted long back, related to mySQL &quot;how can i display the hierarchy with minimum query..&quot; . I am facing the same problem which you had.I just wanted to know that did you get any solution for the same ?
if yes please let me know I need it very badly.

Thanks and regards
Jaydeep
jaydeep.vaze@solversa.com

 

[sleipnir214]

I'm not sure what &quot;minimum query&quot; means, but if it means &quot;do it with one query&quot;, you can't. To fetch the entire hierarchy in one query would require recursive SQL queries, which MySQL does not support.

Typically, you output the hierarchy using a scripting language.

If you have some value that indicates an entry has no parent (generally a parent_id) of zero, then you use a programming languate to fetch each of these files.

For each file in the list, you fetch its children.

For the first child, you fetch its children

When you run out of children, you return to the next level of the hierarchy and start processing the next sibling of the current record at that (the new) level of the hierarchy.

When you run out of siblings, you're done.

Want the best answers? Ask the best questions:

http://www.catb.org/~esr/faqs/smart-questions.html

TANSTAAFL!!