86Stang Posted January 11, 2008 Share Posted January 11, 2008 Is there any good articles or posts on how to build a search function where it not only lists the results (easy) but also shows "filtered" results with links to said filtered results. An example would be doing a search for 'car' and you get something like: Results = 843 Chevy (34) Ford (67) Dodge (21) 2 door (132) 4 door (437) etc... Thanks in advance! Quote Link to comment https://forums.phpfreaks.com/topic/85461-search-filtering/ Share on other sites More sharing options...
teng84 Posted January 11, 2008 Share Posted January 11, 2008 that is not hard and i guess that is sql . yopu only need group by clause eg.. select carscategory, count(carscategory), sum(carscategory) from cars group by carscategory hope that helps Quote Link to comment https://forums.phpfreaks.com/topic/85461-search-filtering/#findComment-436101 Share on other sites More sharing options...
86Stang Posted January 11, 2008 Author Share Posted January 11, 2008 Yes, sorry, this is MySQL. How do you go about linking that into a new page that shows said results? Quote Link to comment https://forums.phpfreaks.com/topic/85461-search-filtering/#findComment-436112 Share on other sites More sharing options...
teng84 Posted January 11, 2008 Share Posted January 11, 2008 oh this is gonna be a long story sorry mate i cant explain it all try to look for <a href="http://www.w3schools.com/php/php_get.asp">get or post</a> variables <a href="http://www.w3schools.com/php/php_mysql_where.asp">select</a> Quote Link to comment https://forums.phpfreaks.com/topic/85461-search-filtering/#findComment-436117 Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.