Hi,
Does $keywords contain a quote ?
You must escape special characters in strings before using them in SQL
statements. If you are using Perl DBI look use 'quote' function otherwise,
check MySQL API for your programming language.
Hope this helps
--
Joseph Bueno
NetClub/Trader.com
[EMAIL PROTECTED] wrote:
>
> 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
---------------------------------------------------------------------
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
