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...
searching in txt
Moderator: General Moderators
-
tsalexey544
- Forum Commoner
- Posts: 41
- Joined: Thu Jun 22, 2006 11:19 am
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...
Excel isn't capable of doing what you want.
Unless of course, it's for a small amount of records and visitors...
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-
tsalexey544
- Forum Commoner
- Posts: 41
- Joined: Thu Jun 22, 2006 11:19 am