|  | Posted by Minuk Choi on 06/10/88 11:29 
Assuming that you are also accepting partial matches... (e.g. if you had a sentence with something like, "Mr. LeBlue says hello", and
 that should be a match for "blue")
 
 If $mysqlString contains 1 sentence from the mySQL database(I assume
 you've a loop or something that'll fetch 1 string per iteration)
 
 $resultStr = $mysqlString;
 
 $bFound=false;
 foreach ($myArray as $colorArray)
 {
 $firstTerm = $colorArray[0];
 $secondTerm = $colorArray[1];
 
 if (strpos($resultStr, $firstTerm)!==false)
 {
 $resultStr = $secondTerm;
 $bFound=true;
 }
 
 if ($bFound)
 break;
 }
 
 $mysqlString = $resultStr;
 
 
 Try that.
 
 
 
 
 Brian Dunning wrote:
 
 > I want to create an array like this:
 >
 > $myArray=array(
 >     array('orange','A very bright color'),
 >     array('blue','A nice color like the ocean'),
 >     array('yellow','Very bright like the sun') ...etc...
 > )
 >
 > Sort of like a small database in memory. Then I want to compare each
 > of the rows coming out of a MySQL call, which are sentences, against
 > this array to see if the FIRST TERM in each array element is present
 > in the sentence, and then display the SECOND TERM from the array for
 > each sentence. Make sense? So for these two sentences, and the above
 > array, here's how I want it to output:
 >
 > "He used blue paint" - A nice color like the ocean.
 > "The flower was yellow" - Very bright like the sun.
 >
 > Can someone help me out with the code needed to search the sentence
 > to which FIRST TERM appears in it, and retrieve the SECOND TERM? I've
 > tried too many things and now my brain is tied in a knot.
 >
  Navigation: [Reply to this message] |