[Resolved] Fulltext searches

furious5

I am currently trying to create a keyword search on a site I am working on.

I have created an index and have ran the following SQL to test it out:

$sql = "SELECT *, MATCH (title, description, location) AGAINST ('web designer') FROM job";

The query returns results, unfortunately it is returning all the records from the table I am querying.

I know there are only 4 records with 'web designer' anywhere in the record contained within the job table.

Does anyone have any ideas why it is returning all the records within the table??

stolzyboy

how 'bout checking your old fricking post

http://www.phpbuilder.com/board/showthread.php?s=&threadid=10256715

furious5

I've checked it, and now I'm now further on than my initial problem.

I was just about to reply to this and mark it as resolved, as I have now overcome the initial problem with returning.

To be honest I hadn't checked where is sat on the database page and automatically assumed it would have gone off the first page by now.

stolzyboy

Originally posted by furious5
I've checked it, and now I'm now further on than my initial problem.

I was just about to reply to this and mark it as resolved, as I have now overcome the initial problem with returning.

To be honest I hadn't checked where is sat on the database page and automatically assumed it would have gone off the first page by now.

don't assume, check... you can search on your username just like i did and see who has responded to your posts, i see goldbug responded and you never responded back...

always respond back and if it is still mainly the same problem...stick with that one thread...

furious5

I was just about to reply to this and mark it as resolved, as I have now overcome the initial problem with returning.

Point taken, please see my comments above.

As a rule of thumb, I always attempt to reply to people who have posted threads I have originally posted.

I'll consider that a right royal telling off, and just to please you. I will even mark this thread as resolved. :eek:

stolzyboy

Originally posted by furious5
Point taken, please see my comments above.

As a rule of thumb, I always attempt to reply to people who have posted threads I have originally posted.

I'll consider that a right royal telling off, and just to please you. I will even mark this thread as resolved. :eek:

Thanks... 🙂