title: Faceted Search (solr) vs Good old filtering via PHP?
body: <p>I am planning on setting up a filter system (refine your search) in my ecommerce stores. You can see an example here: <a href="http://www.bettymills.com/shop/product/find/Air+and+HVAC+Filters">http://www.bettymills.com/shop/product/find/Air+and+HVAC+Filters</a></p>
  
  <p>Platforms such as PrestaShop, OpenCart and Magento have what's called a Layered Navigation.</p>
  
  <p>My question is what is the difference between the Layered Navigation in platforms such as Magento or PrestaShop in comparison to using something like Solr or Lucene for faceted navigation. </p>
  
  <p>Can a similar result be accomplished via just php and mysql? </p>
  
  <p>A detailed explanation is much appreciated.</p>