FULLTEXT search sorting results
| From: | BRACK | Date: | Sat, 01 Sep 2001 12:01:57 +0000 |
| Subject: | FULLTEXT search sorting results | ||
| Groups: | php.general | ||
| Request: | Send a blank email to php-general+get-65599@lists.php.net to get a copy of this message | ||
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?
Thank you in advance,
Youri
<>< <>< <>< <>< God is our provider ><> ><>
><> ><>
http://www.body-builders.org