Re: FULLTEXT search sorting results
| From: | BRACK | Date: | Sun, 02 Sep 2001 21:58:11 +0000 |
| Subject: | Re: FULLTEXT search sorting results | ||
| References: | 1 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-65677@lists.php.net to get a copy of this message | ||
Works fine, thank you
Youri
> On Sat, 1 Sep 2001 14:01:57 +0200, BRACK (brak@nettaxi.com) 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