Re: FULLTEXT search sorting results
| From: | Mark Maggelet | Date: | Mon, 03 Sep 2001 17:50:52 +0000 |
| Subject: | Re: FULLTEXT search sorting results | ||
| References: | 1 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-65778@lists.php.net to get a copy of this message | ||
On Mon, 3 Sep 2001 19:33:38 +0200, BRACK (brak@nettaxi.com) 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");