Re: [PHP] FULLTEXT search sorting results
Actually it doesn't matter '&&' or 'and' they are equal but I found a solution - I just took away conditions and put this instead $relev = "$title_search+$descr_search+$act_search"; $result = mysql_query("SELECT skits.*,category.*,match (skits.title,skits.descr,skits.skits) against ('$relev') as relevance from skits,category where (skits.title like '%$title_search%' and skits.descr like '%$descr_search%' and skits.skits like '%$act_search%' and skits.lang like '%$lang_search%' and category.kat_name like '%$category_search%') and (skits.category like category.cat_id) ORDER by relevance desc limit $limit,10"); Works fine, (I actually changed '&&' with 'and' as you see) Youri > On Mon, 3 Sep 2001 19:33:38 +0200, BRACK ([EMAIL PROTECTED]) wrote: > >$result = mysql_query("SELECT skits.*,category.*,match > >(skits.title,skits.descr,skits.skits) against ('$relev') as from > > oops, should be 'against ('$relev') as relevance from' > > >skits,category where (skits.title like '%$title_search%' && > > use 'and' instead of && > > >skits.descr like '%$descr_search%' && skits.skits like > >'%$act_search%' && skits.lang like '%$lang_search%' && > >category.kat_name like '%$category_search%') and > >(skits.category like category.cat_id) ORDER by relevance desc > >limit $limit,10"); > > <>< <>< <>< <>< God is our provider ><> ><> ><> ><> http://www.body-builders.org -- PHP General Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
Re: [PHP] FULLTEXT search sorting results
On Mon, 3 Sep 2001 19:33:38 +0200, BRACK ([EMAIL PROTECTED]) wrote: >$result = mysql_query("SELECT skits.*,category.*,match >(skits.title,skits.descr,skits.skits) against ('$relev') as from oops, should be 'against ('$relev') as relevance from' >skits,category where (skits.title like '%$title_search%' && use 'and' instead of && >skits.descr like '%$descr_search%' && skits.skits like >'%$act_search%' && skits.lang like '%$lang_search%' && >category.kat_name like '%$category_search%') and >(skits.category like category.cat_id) ORDER by relevance desc >limit $limit,10"); -- PHP General Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
Re: [PHP] FULLTEXT search sorting results
Works fine, thank you Youri > On Sat, 1 Sep 2001 14:01:57 +0200, BRACK ([EMAIL PROTECTED]) wrote: >I > have query - > >$res = mysql_query("SELECT > >skits.*,category.cat_id,category.cat_name FROM skits,category WHERE > >MATCH (title,descr,skits) AGAINST ('%$search_idea%') and skits.lang > >like 'English' and skits.category like category.cat_id limit > >$limit,10 "); > >I expect to get results sorted by relevance and it > actually does BUT >(!) >inside of categories =( I mean it sorts result > first by category and >second by relevance. How do I make it to be > sorted by only relevance? > > try it like this: > $res = mysql_query("SELECT > skits.*,category.cat_id,category.cat_name,MATCH (title,descr,skits) > AGAINST ('%$search_idea%') as relevance FROM skits,category WHERE > skits.lang like 'English' and skits.category like category.cat_id > having relevance>0 order by relevance desc limit $limit,10 "); > <>< <>< <>< <>< God is our provider ><> ><> ><> ><> http://www.body-builders.org -- PHP General Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
Re: [PHP] FULLTEXT search sorting results
On Sat, 1 Sep 2001 14:01:57 +0200, BRACK ([EMAIL PROTECTED]) wrote: >I have query - > >$res = mysql_query("SELECT >skits.*,category.cat_id,category.cat_name FROM skits,category WHERE >MATCH (title,descr,skits) AGAINST ('%$search_idea%') and skits.lang >like 'English' and skits.category like category.cat_id limit >$limit,10 "); > >I expect to get results sorted by relevance and it actually does BUT >(!) >inside of categories =( I mean it sorts result first by category and >second by relevance. How do I make it to be sorted by only relevance? try it like this: $res = mysql_query("SELECT skits.*,category.cat_id,category.cat_name,MATCH (title,descr,skits) AGAINST ('%$search_idea%') as relevance FROM skits,category WHERE skits.lang like 'English' and skits.category like category.cat_id having relevance>0 order by relevance desc limit $limit,10 "); -- PHP General Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]