Jump to content


Photo

mysql nested query


  • Please log in to reply
1 reply to this topic

#1 abhijeet

abhijeet
  • Members
  • Pip
  • Newbie
  • 1 posts

Posted 20 November 2003 - 12:48 AM

i have the \'category\' table in the following format

-------------------------------------------
id categoryname maincatid
-------------------------------------------

1 A 0

2 B 0

3 C 0

4 D 1

5 E 4

6 F 5
-------------------------------------------

As you can see A,B and C are the parent categorie. D is the subcategory of A, E is again subcategory of D and F is subcategory of E.

So the tree structure is like A-->D-->E-->F

Can i write a single query in which i will specify id for F. i.e 6 and it should fetch me all parent categories upto the topmost i.e. A

#2 sirmanson

sirmanson
  • Members
  • PipPip
  • Member
  • 16 posts
  • LocationTucson, AZ USA

Posted 20 November 2003 - 03:16 PM

I don\'t believe this is possible in one query. I scoured the mySQL page and couldn\'t find anything about this. I know it is definately possible using oracle, but not currently in mySQL. You could easily parse this recordset into PHP and get what you need.




0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users