I'm looking for someone to create the mySQL query code wich will get all categories in wich a product exists, I need their full lenght name\path. I posted this in my topic here on the forums http://forum.opencart.com/viewtopic.php?f=20&t=136086
I think this feature is already implemented in the admin when editing a category, in the Links > Categories you get all categories in wich the product resides, but I can't get that query to work on my front-end.Basically, my categories in the shop are actually cars, in form of "make > model > engine" like "Ford > Fiesta 2004 > 1.4i" followed by the parts-section like "Fuel filters". Many parts apply to several cars, so I'm trying to figure out how to get "All categories in wich a product_id applies with full path".
So let's say we have product "Fuel Filter" with product_id 40, wich applies to 40 cars. I can get the categories from DB > product_to_category but I get a list of parents, childrens, sub-childrens, etc, a mess. I know I can use the "category_path", "category" and "category_description" to build the list using levels, parents, but I'm not that advanced in mysql.