match Search problems help needed!!
Hi list, I have a question that hopefully someone can help me with. We have a mysql database which contains 3000 records, and these records need to be searched. The table has 4 fields which need to be searched, so we created a full text index for the 4 fields. Now 1 of the fields contains dates, which we have formatted so that you would search for example for: 05 september 2001 and it needs to return all the results for this date. The problem is as we see it, is mysql has noisewords and the field with the datesearch has lots of records with the same date, and when we search it does not find the records, we need this to work, as otherwise it ruins the way we are producing this site. Has anyone any suggestions on this? Many thanks barry - 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
Urgent Assistance
Hi group,
I am in need of assistance with a database and php query we are trying to
achieve.
Basically we are have a form where one field searches a field in the mysql
database and the other searches for keywords using the MATCH query.
What we need to do is for the user to be able to enter a date or keyword and
for it to query the database. Is it possible to do alternate queries based
upon what the user is entering. So we would like to be able to do a sql
elseif statement, but I am unsure if this is possible.
Here is out current code:
$sql= SELECT *, MATCH (auction, email, website) AGAINST ('$keywords') AS
score FROM ukcalendars WHERE date = '$date' HAVING score != 0 ORDER BY score
ASC LIMIT $limitvalue1, $limit;
But we need to be able to also do:
$sql= SELECT * FROM ukcalendars WHERE date = '$date' LIMIT $limitvalue1,
$limit;
But I am unsure how I can achieve this, if at all possible.
With thanks
barry Zimmerman
www.bzdpltd.co.uk
-
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
Help needed
Hi there all, A little bit of a silly question here, I am used to using PHP Myadmin. What the problem is I have just been learning the command for creating etc.. using telnet, but I have a 2.5mb sql file that I need to run. The questions are; 1: How do I run this file via telnet 2: If I have to upload it where do I upload it to Your help appreciated as always. Barry - 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
Urgent Help Needed
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
Re: Urgent Help Needed
Hi I escape all the characters as the values are passed to the page.
It is driving me mad, just to get this to work! Not many people I know have
the solution. I would have thought searching FULLTEXT and other fields at
the same time would be easy. Any help again appreciated.
Barry
In a message dated 14/5/01 11:02:42 am, [EMAIL PROTECTED] writes:
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
--- Headers
Return-Path: [EMAIL PROTECTED]
Received: from rly-zd02.mx.aol.com (rly-zd02.mail.aol.com [172.31.33.226])
by air-zd01.mail.aol.com (v77_r1.36) with ESMTP; Mon, 14 May 2001 06:02:42
2000
Received: from smtp-gw.netclub.com (home.paris.trader.com [195.68.19.162])
by rly-zd02.mx.aol.com (v78.43) with ESMTP; Mon, 14 May 2001 06:02:30 -0400
Received: from [127.0.0.1] (helo=trader.com)
by smtp-gw.netclub.com with esmtp (Exim 3.13 #1)
id 14zFBm-Mi-00; Mon, 14 May 2001 12:02:54 +0200
Sender: jbueno
Message-ID: [EMAIL PROTECTED]
Date: Mon, 14 May 2001 12:02:54 +0200
From: Joseph Bueno [EMAIL PROTECTED]
X-Mailer: Mozilla 4.73 [en] (X11; I; Linux 2.2.15-4mdkfb i686)
X-Accept-Language: en
MIME-Version: 1.0
To: [EMAIL PROTECTED]
CC: [EMAIL PROTECTED]
Subject: Re: Urgent Help Needed
References: [EMAIL PROTECTED]
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit
-
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
Re: Urgent Help Needed
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 -
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 -
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
Re: Help with MATCH AGAINST
Hi All,
I am new to this list, and will find it of excellent use to me.
I need help with the following:
What it is I have a cv database and it is working great, I use PHP and MySQL
and have just come across this problem, the client has asked me to search
lots of fields in the database. At present we are using the following search
for searching keywords from 5 fields.
$SQL = SELECT *, MATCH specific_work_profile,wxcdone,
wxcdtwo,wxcdthree,wxcdfour AGAINST ('$keywords') AS score FROM cvtemplate
HAVING score!=0 ORDER BY score DESC;
But the problem is I need the search to do the above as well as searching the
following:
'$employment_type' = employment_type
$related_discipline' = related_discipline
'$location' = location
Here is an example of which I thought might work?
$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??
Thanks
Barry
-
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
