mysql search.

[becu]

Hi,

 

I'm trying to write a search function for my site. Let say a user input "my lovely dog", then

if my site has an article let say: "my cute lovely but not very friendly doggy" -> then there's a match.

but if my site has an article: "my friendly doggy lovely" -> then my search can't find this article.

 

My question is how do you swap input text, so that it doesn't matter what order the users input, it can always find matched article.

 

my above sample would be: my lovely dog, dog my lovely, lovely dog my...will be matched with an article entitled "my cute lovely but not very friendly doggy".

 

Thanks.

 

 

[fenway]

Intelligent full-text searches are very poorly supported by native mysql -- look at sphinx or lucene.

[becu]

fenway,

I don't own the server. I just need an okay search method for now. I guess this is more of a PHP question.

 

let say I have an array of 3, 4 elements. Can you propose an algorithm to swap elements and get all possible arrays from this one array?

 

$arr = array("a", "b", "c");

==> I want (a, b, c) (a, c, b) (c, a, b) (c, b, a) (b, a, c) (b, c, a)

 

thanks.

[fenway]

You mean like this?

[becu]

fenway,

I can't access the page you gave. can you double-check the url?

 

thanks for your help!

[becu]

any ideas guys?

 

thanks.

[fenway]

fenway,

I can't access the page you gave. can you double-check the url?

 

thanks for your help!

Sorry -- I found that here.

[becu]

Thanks fenway,

 

I will dig into it.