Re: [PHP] Creating a Search field

2003-10-09 Thread John Taylor-Johnston
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

2003-10-09 Thread Larry E . Ullman
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

[PHP] Creating a Search field

2003-10-09 Thread richard cook
Sorry all I know this isnt really a 100% PHP matter but someone may be in the know here. Ive been trying for ages without success to create a search field for my mysql database using php. I need to create a feature that allows users to enter certain words that can be searched ie search = 'red li