Im trying to make a php search script that searches a pretty big database for information, but im wondering what is the best way to do this? Ive tried the BOOLEAN and the Like Phrase method but they both dont show accurate enough results! What else could you suggest?
What do you mean by "BOOLEAN and the Like Phrase"?
When you perform a search, you need to have criteria to search... for accurate results when you know the exact criteria, you need to use something like "... where field = 'something'". if you don't know the exact criteria, you use "... where field like 'something'".
What do you mean by "BOOLEAN and the Like Phrase"?
When you perform a search, you need to have criteria to search... for accurate results when you know the exact criteria, you need to use something like "... where field = 'something'". if you don't know the exact criteria, you use "... where field like 'something'".
yes, thats good/works but when you have a large database full of records its very inaccurate.
yes, thats good/works but when you have a large database full of records its very inaccurate.
hmm... obviously it would be inaccurate if your search criteria is not specific enuf. actually, i'm not sure what you're trying to accomplish... maybe if you could give a description of that, we can suggest a more defined solution...
yes Forge thats how i did/do it, using the % wildcard, but its still inaccurate, ok an example is if your searching for an item in a huge list of items, sometimes the results come up with something totally random. i.e. you search banana and it comes up with orange
True... boss has a point there. Maybe you should have a drop down. Have like Search in: PHP, CSS, ASP and when the mySQL query is executed, have it search that specific term.
pavsta
BeginnerLink Clerk
Comments
The Royal Ram
When you perform a search, you need to have criteria to search... for accurate results when you know the exact criteria, you need to use something like "... where field = 'something'". if you don't know the exact criteria, you use "... where field like 'something'".
yes, thats good/works but when you have a large database full of records its very inaccurate.
hmm... obviously it would be inaccurate if your search criteria is not specific enuf. actually, i'm not sure what you're trying to accomplish... maybe if you could give a description of that, we can suggest a more defined solution...
sorry to say that what you have mentioned is not possible. the database will not be wrong. it would be your query that is not correct.
post a sample query and tell us what you expect it to do...