Hi Group,
I posted this question before, and need help urgently. The problem is using a
specific search! What we are trying to do is intially search 3 fields and
then once the results are found it needs to be able to narrow down the
results by searching the intial 3 criteria and also a keywords search on a
full text index. I have tried but got no success as I keep getting SYNTAX
error. Can anyone please help, this is most urgent.
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
Is there a specific way we need to do this query! Basically we are trying to
do a MATCH and additional query on the same. Your help is truly appreciated.
Thanks
Barry Zimmerman
---------------------------------------------------------------------
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
