Guest Posted August 12, 2008 Share Posted August 12, 2008 I am performing a fulltext search for businesses in a database but I want them to be able to select a category but the results wouldn't necessarily be in that category. I was thinking group by or somthing like that but just cant seem to wrap my brain around it could someone help please. Link to comment https://forums.phpfreaks.com/topic/119280-mysql-category-prefered-but-not-required/ Share on other sites More sharing options...
fenway Posted August 12, 2008 Share Posted August 12, 2008 Huh? Link to comment https://forums.phpfreaks.com/topic/119280-mysql-category-prefered-but-not-required/#findComment-614896 Share on other sites More sharing options...
Guest Posted August 12, 2008 Share Posted August 12, 2008 lol sorry it sounds more confusing than what it is. Lets say I have a business name field and a category field for the businesses I want to make a sql query that fulltext searches the business name fiels (I got that part) and I want to get a specific category first Example the best I can search for business name mybusiness and category mycategory I run the full text it then brings up mybusiness example1 in category automotive mybusiness example2 in category mycategory mybusiness example2 in category restaurant and I want the one with mycategory to come up first but I still want all the other rows. Does that make any sense? Link to comment https://forums.phpfreaks.com/topic/119280-mysql-category-prefered-but-not-required/#findComment-615026 Share on other sites More sharing options...
fenway Posted August 13, 2008 Share Posted August 13, 2008 Are you talking about ordering the results after the match? Link to comment https://forums.phpfreaks.com/topic/119280-mysql-category-prefered-but-not-required/#findComment-616074 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.