sorry, miss reead your last post. When adding the lines you suggest it complains about a SQL syntax error. Complains about:
'Q', keyqword)) = SOUNDEX(CONCAT('Q','searchterm')) LIMIT 500
This only seems to happen when no results are found
Mysql Version: v12.22 Distrib 4.0.20a, for Win95/Win98 (i32)
|