M
M
maxyc webber2014-04-23 14:43:11
Sphinx
maxyc webber, 2014-04-23 14:43:11

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

2 answer(s)
P
Puma Thailand, 2014-04-23
@opium

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

M
maxyc webber, 2014-04-23
@MyNameIsSylor

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 question

Ask a Question

731 491 924 answers to any question