MySql query to find category path (breadcrumb) for osCommerce

MySql query to find category path (breadcrumb) for osCommerce

In our recent project we implemented Sphinx Search for an osCommerce based site. We included the full path (breadcrumb) of category into search. I thought the breadcrumb query might be helpful for many developers. Note we had the nested categories up to 9 levels, you can easily adjust query for any level. You may or may not need the id or name so you can remove to make query simple

By | 2017-02-12T18:32:25+00:00 December 26th, 2015|0 Comments

About the Author:

Waseem is our consultant for Sphinx Search, Elastic and Solr. He is lamp stack backend developer and has 14 years of experience of development. His areas of interest (other than search) are NoSQL and BigData tools.

Leave A Comment