Hi,
Tried that and also got an error, I just hope someone has had to do this type
of search!! Would have thought so!
Just need to search a MATCH and others at the same time. Thanks all.
Barry
In a message dated 14/5/01 10:54:16 am, [EMAIL PROTECTED] writes:
<< > 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
----------------------- Headers --------------------------------
Return-Path: <[EMAIL PROTECTED]>
Received: from rly-yc04.mx.aol.com (rly-yc04.mail.aol.com [172.18.149.36])
by air-yc05.mail.aol.com (v77_r1.36) with ESMTP; Mon, 14 May 2001 05:54:16
2000
Received: from web.mysql.com (web.mysql.com [192.58.197.162]) by
rly-yc04.mx.aol.com (v77_r1.36) with ESMTP; Mon, 14 May 2001 05:54:11 -0400
Received: (qmail 8607 invoked by uid 7797); 14 May 2001 09:49:46 -0000
Mailing-List: contact [EMAIL PROTECTED]; run by ezmlm
(http://www.ezmlm.org)
List-ID: <mysql.mysql.com>
Precedence: bulk
List-Help: <mailto:[EMAIL PROTECTED]>
List-Unsubscribe: <mailto:[EMAIL PROTECTED]>
List-Post: <mailto:[EMAIL PROTECTED]>
List-Subscribe: <mailto:[EMAIL PROTECTED]>
Delivered-To: mailing list [EMAIL PROTECTED]
Received: (qmail 8567 invoked from network); 14 May 2001 09:49:45 -0000
From: "Chris Bolt" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Subject: RE: Urgent Help Needed
Date: Mon, 14 May 2001 03:52:32 -0600
Message-ID: <[EMAIL PROTECTED]>
MIME-Version: 1.0
Content-Type: text/plain;
charset="us-ascii"
Content-Transfer-Encoding: 7bit
X-Priority: 3 (Normal)
X-MSMail-Priority: Normal
X-Mailer: Microsoft Outlook IMO, Build 9.0.2416 (9.0.2910.0)
X-MimeOLE: Produced By Microsoft MimeOLE V5.50.4522.1200
In-Reply-To: <[EMAIL PROTECTED]>
Importance: Normal
>>
---------------------------------------------------------------------
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
