Re: [PHP] Fulltext search engine
Roman Duriancik wrote: I need in my own web server with mysql database and php script some free fulltext engine. But i need search in slovak language (all data in database in slovak). Can yopu help me where i can find some free fulltext engine ? roman http://dev.mysql.com/doc/mysql/en/fulltext-search.html -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP] Fulltext-Search
Lauri, Very impressive. Merry Christmas - Miles Thompson At 03:03 AM 12/25/2001 +0200, Lauri Vain wrote: >Hello Martin, > >At 10:13 PM 12/23/2001 +0100, Martin wrote: > >Hello! Does anybody know a good script to search the own web-server?! > >Would be nice if the script could display the whole sentence where the > >word was found... > >If you want to have more hands on fun then check out the following >class/how-to: >http://www.evolt.org/article/Boolean_Fulltext_Searching_with_PHP_and_MySQL/18/15 >665/index.html > >Yours, >Lauri >-- >Tharapita Creations >[dynamic web applications] >[EMAIL PROTECTED] >Mobile: +372 53 410 610 > > > >-- >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] -- 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]
Re: [PHP] Fulltext-Search
Hello Martin, At 10:13 PM 12/23/2001 +0100, Martin wrote: >Hello! Does anybody know a good script to search the own web-server?! >Would be nice if the script could display the whole sentence where the >word was found... If you want to have more hands on fun then check out the following class/how-to: http://www.evolt.org/article/Boolean_Fulltext_Searching_with_PHP_and_MySQL/18/15 665/index.html Yours, Lauri -- Tharapita Creations [dynamic web applications] [EMAIL PROTECTED] Mobile: +372 53 410 610 -- 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]
Re: [PHP] Fulltext-Search
htdig or mnogo At 10:13 PM 12/23/2001 +0100, Martin wrote: >Hello! Does anybody know a good script to search the own web-server?! >Would be nice if the script could display the whole sentence where the >word was found... > >Martin > > >-- >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] -- 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]
Re: [PHP] Fulltext-Search
http://www.htdig.org/ Martin wrote: > Hello! Does anybody know a good script to search the own web-server?! > Would be nice if the script could display the whole sentence where the > word was found... > > Martin > > -- > 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] -- 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]
Re: [PHP] FULLTEXT search sorting results
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') as relevance
from skits,category where (skits.title like '%$title_search%' and
skits.descr like '%$descr_search%' and skits.skits like
'%$act_search%' and skits.lang like '%$lang_search%' and
category.kat_name like '%$category_search%') and
(skits.category like category.cat_id) ORDER by relevance desc
limit $limit,10");
Works fine, (I actually changed '&&' with 'and' as you see)
Youri
> 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_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");
>
>
<>< <>< <>< <>< 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]
Re: [PHP] FULLTEXT search sorting results
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_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");
--
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]
Re: [PHP] FULLTEXT search sorting results
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 '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?
>
> try it like this:
> $res = mysql_query("SELECT
> skits.*,category.cat_id,category.cat_name,MATCH (title,descr,skits)
> AGAINST ('%$search_idea%') as relevance FROM skits,category WHERE
> skits.lang like 'English' and skits.category like category.cat_id
> having relevance>0 order by relevance desc limit $limit,10 ");
>
<>< <>< <>< <>< 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]
Re: [PHP] FULLTEXT search sorting results
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 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?
try it like this:
$res = mysql_query("SELECT
skits.*,category.cat_id,category.cat_name,MATCH (title,descr,skits)
AGAINST ('%$search_idea%') as relevance FROM skits,category WHERE
skits.lang like 'English' and skits.category like category.cat_id
having relevance>0 order by relevance desc limit $limit,10 ");
--
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]
