Complex multi-part table selection

Given
--------------
TABLE NAMES
Name:
mary
bob
steve

TABLE SENTENCES
ID: Sentence:
1 mary is hot
2 bob hit steve
3 steve likes steve
--------------

Please help me generate a query using PHP/MYSQL that is fast and works with large tables to do the following:

Determine the number of Names in each Sentence.

The result should look like this:

RESULT
SENTENCES.ID: COUNT(NAMES):
1 1
2 2
3 2

Please send any help to php-editors.com@nospam.phor.net

Thanks <_<

[Xnuiem]

I thought there may have been a way to do this with MySQL but I cant find it.

1. Create an array of all the names

$nameArray = array();
$result = mysql_query("select distinct(lower(name)) from names");
while(list($name) = mysql_fetch_row($result)){
  $nameArray[] = $name;
}

2. Run through getting counts. I dont know what you want to do with the data, so I will put it into a simple array so you can do what you want.

$final = array();
$result = mysql_query("select id, lower(sentence) from sentences");
while(list($id, $sent) = mysql_fetch_row($result)){
  $count=0;
  foreach($nameArray as $n){
    $count += substr_count($sent, $n);
   }
   $final[$id] = $count;
}

thanks :P