พี่ๆช่วยดูทีครับ ผทดึงข้อมูลแล้วข้อมูลขึ้นมาไม่ครบ

<?php
					$next = "SELECT * FROM next INNER Join league on nlid=lid  inner join team on lid=tid where n_delete=0 order by nlid ASC";
					$objQuerynext = mysql_query($next) or die ("Error Query [".$strSQL."]");
					$Num_Rows_next = mysql_num_rows($objQuerynext);
if($Num_Rows_next>0)
  {
 $i=1;
while($objResult_next = mysql_fetch_assoc($objQuerynext))
{
?>
<tr>
		<?php 
		
		if($objResult_next['nlid']==$i){ ?>
	<th align="left" colspan="6"><?php echo $objResult_next['lnamethai'] ?></th>
</tr>
		<?
		$next2 = "SELECT * FROM next  where (nlid=$i && n_delete=0) order by nlid ASC";
		$rs_next = mysql_query($next2);
		while($objResult_next1 = mysql_fetch_array($rs_next))
		{	
			?>
		<tr>	
        <td align="center"><?php echo $objResult_next1['ntime']; ?></td>
      	<td align="center"><?php echo $objResult_next1['nname1']; ?></td>
       	<td align="center"><?php echo $objResult_next1['nname2']; ?></td>
      	<td align="center"><?php echo $objResult_next1['ratio']; ?></td>
      	<td align="center"><?php echo $objResult_next1['detail']; ?></td>
      	</tr>
			<?php	
		
		}
			 $i++;
		}else{
			 $i++;
		}
		
    }
    }
    else
    {
  ?>  <tr id="tr" >
    <td colspan="10" align="center">NoData</td>
    </tr>
  <?
    }
  ?>
          </table>