Hi,
I asked recently to help with the selection for FULLTEXT search
and now with your help I found how to do that but I still have
problem with advansed search.
This is what I have right now:
$result = mysql_query("SELECT skits.*,category.* from
skits,category where (skits.title like '%$title_search%' &&
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 skits.category
limit $limit,10");
It sorts results by category, I want them to be sorted by relevance
and there are three columns in my table are in FULLTEXT index -
skits.title, skits.descr,skits.skits so I do this -
if ($title_search != "" && $descr_search= "" && $act_search = ""):
$relev = $title_search;
elseif ():// this is for every condition, just do not want to type it all.
$...
endifl
$result = mysql_query("SELECT skits.*,category.*,match
(skits.title,skits.descr,skits.skits) against ('$relev') as from
skits,category where (skits.title like '%$title_search%' &&
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");
But the proble is that this either don't find any results or select all
records. What to do to make advenced search sorted by relevance?
Thank you,
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]
