> The one we tried was:
>
> $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";
>
> From this we get the following error:
>
> You have an error in your SQL syntax near ' MATCH specific_work_profile,
> wxcdone, wxcdtwo, wxcdthree, wxcdfour AGAINST ('CE' at line 1
Have you tried:
SELECT * FROM cvtemplate, MATCH (specific_work_profile, wxcdone, wxcdtwo,
wxcdthree, wxcdfour) AGAINST ('$keywords') AS score FROM cvtemplate WHERE
employment_type = '$employment_type' AND location = '$location' AND
related_discipline = '$related_discipline' HAVING score != 0 ORDER BY score
DESC
---------------------------------------------------------------------
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
