Development

One more addition

the code below doesn't work if the same word appears in e.g. the description and the keyword. To get around this you need to change the line about match against to

$sqlft ='MATCH(' .join(',', $search_fields) . ') AGAINST ('.$qwords.' IN BOOLEAN MODE)';

There are more boolean mode options that I've not explored, so you may change the syntax further.... see...

http://www.mysql.com/doc/en/Fulltext_Search.html

for further details

Cheers

Andrew