[PHP-DB] Re: Search engine
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
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