Ron Piggott wrote: > I am getting the following error when running the query through php my > admin: > > MySQL said: Documentation > > #1191 - Can't find FULLTEXT index matching the column list Grr - stupid manual didn't have a link on how to create the index. http://dev.mysql.com/doc/refman/5.0/en/create-index.html create fulltext index on table(field1, field2); -- Postgresql & php tutorials http://www.designmagick.com/ -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php