> $SQL = " SELECT * FROM cvtemplate WHERE employment_type = '$employment_type'
> AND location = '$location' AND related_discipline = '$related_discipline',
> MATCH specific_work_profile, wxcdone, wxcdtwo, wxcdthree, wxcdfour AGAINST
> ('$keywords') AS score FROM cvtemplate HAVING score!=0 ORDER BY score DESC";
>
> But I keep getting a sql syntax error. If anyone can help??
----------
You have 2 "FROM" clauses - remove the 2nd one.
Also, don't forget that prior to using MATCH...AGAINST you should have created
a fulltext index *exactly* the way you list the fields in MATCH(). In your
case it would be
FULLTEXT(specific_work_profile, wxcdone, wxcdtwo, wxcdthree, wxcdfour).
Vadim.
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
