Indexslyia

Reworking a MySQL database search script in PHP to take advantage of MySQL 4.0+ boolean full text searching. Problems running into:

• Creating the index. If you create a full text index on some of the fields in your table via PhpMyAdmin, say, and a subsequent test search yields an error message like: "Can't find FULLTEXT index matching the column list," try this command:
• create fulltext index myindex_name on table (fieldname1,fieldname2,fieldname3,fieldname4);