请问php大师-phpnewnew

$sql="select title from a"
........
while($tpl2result=mysql_fetch_array($result_sql))
          {
              if(sizeof($array1)<5)
              {
               if($this->guolv($tpl2result['title']))
                 array_push($array1,$tpl2result);           
             }
             if(sizeof($array2)<5)
             {
             if(!$this->guolv($tpl2result['title']))
                 array_push($array2,$tpl2result);
             }
             if(sizeof($newtalk)==5&&sizeof($newvote)==5)
             {
                 break;    
                 exit;
             }
          }

$array1 = array();
$SQL = "SELECT a.title As atitle FROM a WHERE a.title in(SELECT b.title FROM b)";
$mysql->query($SQL);

$total = 0;
while ($result = $mysql->fetch_assoc()) {
    $array[] = $result['atitle'];
    if ($total > 5) {
        break;
    }
    $total++;

}
$array2 = array();
$SQL = "SELECT a.title As atitle FROM a WHERE a.title not in(SELECT b.title FROM b)";
$total = 0;
while ($result = $mysql->fetch_assoc()) {
    $array2[] = $result['atitle'];
    if ($total > 5) {
        break;
    }
    $total++;
}

------解决方案--------------------

探讨


人家又没问你们，干嘛多嘴呀？
何况还答错了


------解决方案--------------------
你就b LEFT JOIN a 就好了。以b为主。

探讨


引用:

select title from a left join b on a.title=b.title limit 0,10
貌似这样是限制在10条内了


如果前面995条都不在b里面，，从996---1000在b里面，，似乎不行了吧，，

碰到这种需求貌似没有妥善的解决方法，，只能按1楼的搞了，效率比我那个高