[PHP-DB] Re: Search engine

2006-09-28 Thread Ron Piggott
Part of why I want to do this is for the programming experience.  This
is why I didn't implement the google solution already.  Ron

On Wed, 2006-09-27 at 22:44 -0400, Ron Piggott (PHP) wrote:

 Has anyone wrote a search engine for the web site?  I am wondering if
 someone has the time to help me walk through doing this.  Ron

-- 
[EMAIL PROTECTED]
www.actsministrieschristianevangelism.org

Acts Ministries Christian Evangelism
Where People Matter
12 Burton Street
Belleville, Ontario, Canada K8P 1E6

In Belleville Phone: (613) 967-0032
In North America Toll Free: (866) ACTS-MIN


[PHP-DB] Re: search engine query

2004-05-19 Thread Torsten Roehr
Bobo Wieland [EMAIL PROTECTED] wrote in message
news:[EMAIL PROTECTED]
 Hi! I'm new to this list. I usually try to get my answers at the php-win
 mailing list...

 But since this is a mysql question I thought it would be better to ask i t
 here;

 How do I get the best result from a simple search (just one input box and
a
 search button) from a mysql db with two tables containing
 the following fields;

 _table1_
 id (int) (primary)
 title (varchar 40)
 keywords (varchar 255 with a list of keywords separated with comma)
 description (varchar 255 with fulltext index)
 -

 _table2_
 f_key (int), page (int) (f_key is the same as id from table1 and f_key and
 page combined is the primary)
 text (text with fulltext index)
 -


 I guess you can see what the table represents... One article split in 1 to
*
 pages with one entry in table1 for all the common stuff...

 I need to find the articles that fits the search the best
(obviously... )...
 I'm really not sure how to do this... There must be some general way that
 people goes about this since it seems to me to be a quite common thing to
 do...

Take alook here:
http://dev.mysql.com/doc/mysql/en/Fulltext_Search.html

Hope this helps.

Regards, Torsten

-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php