Match News Item with Region

NZ_Kiwis

I have four tables

NewsItems
1. NewsID
2. NewsTitle

NewsRegion
1. RegionID
2. RegionName

NewsKeyWords
1. KeywordID
2. Keyword
3. RegionID

NewsSorted
1. SortedID
2. NewsID
3. RegionID

What I want to do it loop though each NewsItems and then inside the loop check to see if there is a match in NewsTitle with Words in the NewsKeyWords.

I then want to add the NewsID and the RegionID to a new row in table NewsSorted.

How would I do this??

$result = mysql_qury("SELECT * FROM NewsItems");
while($result = mysql_qury_results){

$Title = $row['NewsTitle'];

/// Do something here to check each word in keywords and then do a if statment if there is match i guess?


}

NZ_Kiwis

I think I have something, all i need to do it match, string1 with string2 or at least see if there is a match

for example

String1: "This is string 1, PHP is a great code to use"
String2 :"VB C# HTML Java PHP"

This would produce a true result.

How?

dalecosp

Will the strings match exactly? Simple as "==". Otherwise, you may want to look at the needle and haystack string functions, like [man]strstr/man, [man]stristr/man, [man]strtok/man and friends, or perhaps even something as powerful as [man]preg_match/man.

dalecosp

OK, I may have misread that. Do you want something like this?

<?php


$String1="This is string 1, PHP is a great code to use";
$String2="VB C# HTML Java PHP";

$keywords=explode(" ",$String2);

foreach ($keywords as $kw) {
   if (stristr("$String1",$kw)) {
      echo "Have found a match!";
   }
}

?>

HTH,

NZ_Kiwis

Cheers but i get this error

Warning: stristr() [function.stristr]: Empty delimiter in E:\wamp\www\newssort.php on line 46

NZ_Kiwis

okay i need to put ' at each end, it still does not find a match when there is one there!