Re: Searching a Table

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 > > > > > > > > > > >