Page 1 of 1

Dynamic data search filters

Posted: Tue Feb 17, 2009 4:32 am
by kreoton
Hi, I have to complete one task of creating dynamic search filters in classified ads site and I need your help.
It is hard to explain what i want so here is example site: http://www.finn.no/finn/car/used/result in side bar you see dynamic search filters

Pris/Price
0 - 99.999 (12.547)
100.000 - 174.999 (12.025)
175.000 - 255.999 (12.093)
256.000 - 3.790.000 (12.077)

Ã…rsmodell/Make date
1900-1999 (10293)
2000-2003 (11493)
2004-2005 (11425)
2006-8000 (15534)

Km.stand/Kilometrage
1-39999 (11306)
40000-79999 (12030)
80000-139999 (12896)
140000-999999 (12350)

How you see in all ranges counts are approximately same. Every time you click on one of filter other filters are recalculated.
Question is how this can be done in PHP/MySQL (we also have Sphinx installed) to complete this task using minimal number of database calls. Or maybe this can be done using sphinx?

Thanks for your help.