Full text search problems!

mattbrad

Im currently trying to get my head around full text searching. Ive found numerous tutorials and examples on code on these boards, but my code still doesnt seem to work, as its always bring a mysql error?!

Ive set up my table which will be searched, with 6 fields which are of TEXT type. Ive made these fulltext with the following..

CREATE FULLTEXT INDEX full_index ON profile(
   profile_career,
   profile_location,
   good_memories,
   bad_memories,
   most_missed,
   profile_message
   );

Then the sql im using is ...

    $sql = "SELECT * FROM profile WHERE MATCH (profile_location, profile_career) AGAINST ('$keywords')";

But i seem to be getting errors, and i have changed the code that many times, i dont know what is wrong with the sql, but im getting an error on the mysql_fetch_array() line which executes the above sql?!

Any ideas on how to narrow it down?!

Roger_Ramjet

Yes, I've got every idea, and you will have too once you read the manual properly
full text search restrictions

Roger_Ramjet

mattbrad wrote:
im getting an error on the mysql_fetch_array() line which executes the above sql?!

Any ideas on how to narrow it down?!

Learn to make life easy for yourself.

Currently, I guess from that comment, you are not coding to output any mysql errors. If you were, you would have seen an error message something like this:

Can't find FULLTEXT index matching the column list

and that tells you the problem.

Development and production code are very different. When you are developing your scripts you must have all error reporting ON and include debugging aids. As you prove each function and routine you can comment the debugging code out; but leave it in untill you have finished testing the whole application in case you need it again. When you are ready to go live you turn off error reporting and remove the commented-out code if you wish.