Getting a search function running perplexed me, too, until I looked at the MySQL docs. With the Full-Text Search function I got a search function working in minutes.
http://www.mysql.com/doc/F/u/Fulltext_Search.html Watch out for the weird bug that ignores duplicate rows, though. It can make for zero returns in small databases for no logical reason. That drove me nuts until I figured out why it was happening. (It's mentioned at the bottom of the docs.) > Hi all, > > Would someone kindly point me to a tutorial on designing a search > script for mysql db. I have tried to build one but can't get > anywhere with it. > > Thanks > Jennifer > > -- > The sleeper has awaken > > --- > Outgoing mail is certified Virus Free. > Checked by AVG anti-virus system (http://www.grisoft.com). > Version: 6.0.351 / Virus Database: 197 - Release Date: 4/19/2002 > > -- > PHP Database Mailing List (http://www.php.net/) > To unsubscribe, visit: http://www.php.net/unsub.php -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
