Page 1 of 1

searching in txt

Posted: Sat Jul 01, 2006 4:04 am
by tsalexey544
how can I make a search engine which will search a excel table (which will have some colums name (like: Nama, age,...)).
After the search is finished it will desplay rows which are the most close to the search.


Please help me...

Posted: Sat Jul 01, 2006 4:12 am
by Benjamin
What language do you want to make it in? Do you want people to be able to upload a file, then search it? Your question is a bit vague.

Posted: Sat Jul 01, 2006 4:33 am
by bokehman
Wouldn't it be easier to use one of the currently available databases like MySQL (free) than waste time and effort trying to create your own?

Posted: Sat Jul 01, 2006 6:46 am
by tsalexey544
I want to create a search enging that will search not only by keywards but also by age, sex, and so on....

Posted: Sat Jul 01, 2006 6:49 am
by Benjamin
You may want to research MySQL http://en.wikipedia.org/wiki/MySQL

Excel isn't capable of doing what you want.

Unless of course, it's for a small amount of records and visitors...

Posted: Sat Jul 01, 2006 7:56 am
by bokehman
MySQL would have no trouble with that. Maybe a query such as the following (not tested).

Code: Select all

SELECT `$column1`, `$column2`, `$column3`,
MATCH(`$column1`, `$column2`, `$column3`) AGAINST ('$keywords') 
AS score 
FROM `$tablename` 
WHERE MATCH(`$column1`, `$column2`, `$column3`) AGAINST ('$keywords') 
AND `sex` = '$sex'
AND `age` >= $min_age
AND `age` <= $max_age 
ORDER BY score DESC

Posted: Sat Jul 01, 2006 8:00 am
by tsalexey544
I am going to try it THANKS !!