Re: [PHP] category and sub category traversal

> I need some help in figuring out this logic. > > I have two tables one for category and other for category_hierarchy. > category_hirerarchy has a column to determine the parent. > > So the query I have to retrieve tree of one specific category is: > > SELECT t.tid, t.*, parent FROM term_data t IN

RE: [PHP] category and sub category traversal

hey vamvan... you might pop this to the mysql email list as well, if you haven't already! [EMAIL PROTECTED] -Original Message- From: VamVan [mailto:[EMAIL PROTECTED] Sent: Monday, December 01, 2008 5:13 PM To: php List Subject: [PHP] category and sub category traversal Hello,

Re: [PHP] category and sub category traversal

VamVan wrote: Hello, I need some help in figuring out this logic. I have two tables one for category and other for category_hierarchy. category_hirerarchy has a column to determine the parent. So the query I have to retrieve tree of one specific category is: SELECT t.tid, t.*, parent FROM ter