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

-- 
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]

Reply via email to