php – 检查句子是否有相同的单词

=====================================    ================================
|id|sentence |sentence_id|content_id|    |id|word|sentence_id|content_id|
=====================================    ================================
| 1|sentence1|    0      |    1     |    | 1|  a |     0     |    1     |
| 2|sentence2|    1      |    1     |    | 2|  b |     0     |    1     |
| 3|sentence5|    0      |    2     |    | 3|  c |     1     |    1     |
| 4|sentence6|    1      |    2     |    | 4|  a |     1     |    1     |
| 5|sentence7|    2      |    2     |    | 5|  e |     1     |    1     |
=====================================    | 6|  f |     0     |    2     |
                                         | 7|  g |     1     |    2     |
                                         | 8|  h |     1     |    2     |
                                         | 9|  i |     1     |    2     |
                                         |10|  f |     2     |    2     |
                                         |11|  h |     2     |    2     |
                                         |12|  f |     2     |    2     |
                                         ================================

我需要检查每个句子是否由每个content_id中的其他句子所拥有的单词组成.

例如 ：

检查content_id = 1他们是sentence1和sentence2.从tb_word,我们可以看到sentence1和sentence2由相同的单词a组成.如果两个句子中的a的数量是> = 2,那么a将是结果.因此,如果我打印结果,它必须是：
00Array([0] => a [1] => b)01Array([3] => a)10Array([3] => a)11Array([0] => c [1] = > a [2] => e)其中00表示sentence_id = 0且sentence_id = 0

首先,我使functionTotal计算每个content_id所拥有的句子数：

$total = array();
$sql = mysql_query('select content_id,count(*) as RowAmount 
       from tb_content Group By contente_id') or die(mysql_error());
while ($row = mysql_fetch_array($sql)) {
    $total[] = $row['RowAmount']; 
}
return $total;

从这个函数我得到$total的值,从中我需要检查一些单词(来自tb_word)在2个句子的所有可能性之间的相似性

foreach ($total as $content_id => $totals){
for ($x=0; $x <= ($totals-1); $x++) {
    for ($y=0; $y <= ($totals-1); $y++) {
      $shared = getShared($x,$y);
    }
}

getShared的功能是：

function getShared ($x,$y){
    $token = array();
    $shared = array();
    $i = 0;
    if ($x == $y) {
        $query = mysql_query("SELECT word FROM `tb_word`
                             WHERE sentence_id ='$x' ");
        while ($row = mysql_fetch_array($query)) {
            $shared[$i] = $row['word'];
            $i++;
        }

    } else {
        $query = mysql_query("SELECT word,count(word) as jml 
                             FROM `tb_word` WHERE sentence_id ='$x' 
                             OR sentence_id ='$y' 
                             GROUP BY word ");
        while ($row = mysql_fetch_array($query)) {
            $jml = $row['jml'];
            $token[$i] = $row['word'];
            if ($jml >= 2) {
                $shared[$i] = $token[$i];
            }
            $i++;
        }

但我得到的结果仍然是错误的.结果仍然在不同的content_id之间混合.结果必须也是由content_id分组.抱歉我的英语不好,我的解释也不好. cmiiw,请帮帮我..谢谢:)