[Help]: Searching in categories & subcategoies!!

[mp3yty]

Hello,

I am looking for a tutorial, or some help with a slight problem that I am
having.

Suppose we have the products is categorized by different level of category

For Example

Category A ---> Category B -> A Dog's Life
-----------------------------------> Dogz
----------------> Category C--> Mad Dog
-----------------------------------> Shrek
-----------------------------------> Category D(empty)
----------------> Country dog
----------------> Terminator 2

we have a product category A, under A we have 2 subcategory B and C and 2 products. Under category B & C, there can also have products and categories. Category D is under category C & category D is empty

Now we want a search product function. when we search with search string 'dog' at category A, the function will search through category A, B, C, D to find out product name with 'dog'. When we search under category C with same search string, the function will search through category C and D.

i had 3 table

Table 1 - Products(products_id, products_name)
Table 2 - Categories(categories_id, categories_name, parent_categories_id)
Table 3 - Product_Categories(products_id, categories_id)

Thanks for your help[