match Search problems help needed!!

2001-09-15 Thread Bzdpltd
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

Urgent Assistance

2001-09-12 Thread Bzdpltd
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

Help needed

2001-05-23 Thread Bzdpltd
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

Urgent Help Needed

2001-05-14 Thread Bzdpltd
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

Re: Urgent Help Needed

2001-05-14 Thread Bzdpltd
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

Re: Urgent Help Needed

2001-05-14 Thread Bzdpltd
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 =

Re: Help with MATCH AGAINST

2001-05-11 Thread Bzdpltd
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