Matching phrases

[gilgalbiblewhee]

I can't figure this out. I spent a lot of time (weeks!) trying to figure it out but no success.

What I want is for common_phrase to have the phrases in common from both mySplitString and mySplitString2separated by ,,.

	var common_phrase = "";//the last result of the string
	k=0;
	var count=0;
	for(var i=0; i < wordCollection.length; i++){ //length of the collection of words in common in the two strings mySplitString and mySplitString2
		for(var j=0; j < mySplitString.length; j++){ //picks a word and runs through 2nd array
			if(wordCollection[i] == mySplitString[j]){ //when match found
				for(k=0; k < mySplitString2.length; k++){
					if(wordCollection[i] == mySplitString2[k]){
						for(m=0; m<wordCollection.length; m++){
							if(mySplitString[j+m] == mySplitString2[k+m]){
								common_phrase += mySplitString[j+m]+" "; //records word
								count++;
							}
						}
					}else{
						if(count > 0){
							common_phrase += ",,";
							count=0;
						}
					}
				}	
			}
		}
	}

[curtiss]

I'm still somewhat at a loss as to how you are generating the phrases you're trying to match. Are your users typing in a phrase that you're trying to match against various sources, or are you simply trying to find common phrases between all of the books you have in the database?

If your users are typing in the phrases, the best way to go about this is to use a fulltext search within your MySQL database. If you're simply trying to compare two or more database results to find common phrases, I honestly can't think of a good way to do so, unfortunately.