Re: [PHP] Creating a Search field

Don't forget the "in boolean mode" part. It will work a lot better: SELECT * FROM $table WHERE MATCH (field1,field2,field3,field4) AGAINST ('red lion' IN BOOLEAN MODE); http://www.mysql.com/doc/en/Fulltext_Search.html Need more code? let me know. I've fallen in love with what in boolean mode ha

Re: [PHP] Creating a Search field

I need to create a feature that allows users to enter certain words that can be searched ie search = 'red lion' this would return all data found with the words red and lion. If you're using MySQL 4.0, you can take advantage of its FULL TEXT searching (it's actually available in earlier versions b