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... .bobo -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
