Answer the question
In order to leave comments, you need to log in
Sphinx. How to search by categories and display them?
Please help. I am at the very beginning of my acquaintance with the sphinx. I ask you to correct your brain in the direction of correct work with the Sphinx.
There is a shop. There are goods.
Like would learned to index the table with the goods.
Each product has a 1 to 1 link to brands and 1 to many to categories.
1. How to search by product and display categories/brands in which the found products are available?
2. How to search by category?
3. How to search by brand?
Please don't write code. and analyze the algorithm of this action.
ps I roughly understand questions 2-3 like this:
In the sphinx sources I specify sql_attr_*= and already from the code through the api I figure with these parameters.
What about question 1?
Answer the question
In order to leave comments, you need to log in
1) Make an additional request for categories and brands, or store one to many in one field.
2) add where category = category
3) add where brand = brand
I found a couple of topics that I need ... I continue to study
sphinxsearch.com/blog/2013/06/21/faceted-search-wi...
sphinxsearch.com/forum/view.html?id=3326
Didn't find what you were looking for?
Ask your questionAsk a Question
731 491 924 answers to any question