CodeIgniter Forums

Full Version: Correlated search filtering
You're currently viewing a stripped down version of our content. View the full version with proper formatting.
Hi,

I have items that user can do filter them by several filters;
I want to show number of items by the name of filter;
For example there is a city filter that filters items by city. I want to show number of items next to city name:
All cities (101)
istanbul (50)
ankara (20)
.
.
.

If user does another filtering The numbers above need to be updated accordingly;

In DB each filtering information is in different tables. I don't use tagging/labeling (should I use?). 
Currently I tried to do with joins. as the number of filters increase the more complicated getting those db queries.

Is there better way to achieve this result?

Thanks in advance
This article has some good information on it.

MySQL SQL Syntax and Use

SEE: Retrieving from Multiple Tables with UNION
(05-14-2018, 04:37 AM)InsiteFX Wrote: [ -> ]This article has some good information on it.

MySQL SQL Syntax and Use

SEE: Retrieving from Multiple Tables with UNION

Thanks, I will check it out
good job, thx!