[PHP] Fulltext search engine
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 -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
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
[PHP] Fulltext-Search
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]
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
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
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 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]
[PHP] FULLTEXT search sorting results
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]
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 relevance0 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]
[PHP] FULLTEXT search sorting results
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]
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 relevance0 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]
