I mean category mapping from the two tables categories.
i/p tables: ======= table Categories id cat_name master_id 1 Apparel > Shirt 0 2 Apparel > Skirt 0 table: master_categories (Tree Structure) id parent_id cat_name 1 0 Apparels 2 1 Women 3 1 Men 4 3 Shirt 5 2 Skirt Desired Output: =========== table Categories id cat_name master_id 1 Apparel > Shirt 4 (Shirt belongs to Men) 2 Apparel > Skirt 5 (Skirts belongs to Women) Brandnew to MVC and thrilled! --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "Cake PHP" group. To post to this group, send email to [email protected] To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/cake-php -~----------~----~----~----~------~----~------~--~---
