Actually it doesn't matter '&&' or 'and' they are equal but I found a
solution - I just took away conditions and put this instead
$relev = "$title_search+$descr_search+$act_search";
$result = mysql_query("SELECT skits.*,category.*,match
(skits.title,skits.descr,skits.skits) against ('$relev')
On Mon, 3 Sep 2001 19:33:38 +0200, BRACK ([EMAIL PROTECTED]) 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_
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 '%$tit
Works fine, thank you
Youri
> On Sat, 1 Sep 2001 14:01:57 +0200, BRACK ([EMAIL PROTECTED]) 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 '
On Sat, 1 Sep 2001 14:01:57 +0200, BRACK ([EMAIL PROTECTED]) 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 catego
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 relev
6 matches
Mail list logo
