Re: Searching a Table

READ THE MYSQL MANUAL -- IT DOCUMENTS EVERYTHING. Justin on 18/11/02 2:19 AM, Stephen (webmaster@melchior.us) wrote: > Thanks, this is what I was looking for. But does it ommit common words like > 'it' or 'the?' > > > ----- Original Message ----- > From: "Marco Tabini" <marcot@tabini.ca> > To: "Stephen" <webmaster@melchior.us> > Cc: "PHP List" <php-general@lists.php.net> > Sent: Saturday, November 16, 2002 10:47 PM > Subject: Re: [PHP] Searching a Table > > >> Ok, then you can use FULLTEXT queries. >> >> Take a look here: >> >> http://www.mysql.com/doc/en/Fulltext_Search.html >> >> >> Marco >> >> On Sat, 2002-11-16 at 22:49, Stephen wrote: >>> I don't have control of my server, it's hosted. All my content is in a > MySQL >>> database and is outputed through a php page that selects the information >>> from an id variable passed through the URL... >>> >>> >>> ----- Original Message ----- >>> From: "Marco Tabini" <marcot@tabini.ca> >>> To: "Stephen" <webmaster@melchior.us> >>> Cc: "PHP List" <php-general@lists.php.net> >>> Sent: Saturday, November 16, 2002 10:38 PM >>> Subject: Re: [PHP] Searching a Table >>> >>> >>>> Well, if you're using a database, say MySQL, you can look at FREETEXT >>>> indexes and queries. If you want to index your web pages, you should > be >>>> looking at a search engine that works with your web server. For > example, >>>> ht:dig (http://www.htdig.org/) works with Apache. >>>> >>>> >>>> Marco >>>> >>>> -- >>>> ------------ >>>> php|architect - The magazine for PHP Professionals >>>> The first monthly worldwide magazine dedicated to PHP programmers >>>> Check us out on the web at http://www.phparch.com >>>> >>>> >>>> >>>> On Sat, 2002-11-16 at 22:40, Stephen wrote: >>>>> I need to make a search engine for my site. Instead of making a > table >>> with all the words of my content of my reviews, I need to make it > simple. >>> How could you search a table of articles (let's say game_reviews) by >>> comparing keywords the user types in, to the text of the article? All > the >>> tutorials I can find make a table with a list of words of every single >>> keyword... >>>>> >>>>> >>>>> Thanks, >>>>> Stephen Craton >>>>> http://www.melchior.us >>>>> >>>>> "Life is a gift from God. Wasting it is like destroying a gift you > got >>> from the person you love most." -- >>> http://www.melchior.us >>>>> ---- >>>>> >>>> >>>>> -- >>>>> PHP General Mailing List (http://www.php.net/) >>>>> To unsubscribe, visit: http://www.php.net/unsub.php >>>>> >>>> >>>> >>>> >>>> -- >>>> PHP General Mailing List (http://www.php.net/) >>>> To unsubscribe, visit: http://www.php.net/unsub.php >>>> >>>> >>> >> >> >> > Justin French -------------------- http://Indent.com.au Web Developent & Graphic Design --------------------