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 !!