hem

<table cellpadding="0" cellspacing="0" border="0" class="display" id="example">
                <thead>
                    <tr>
						<th>NAMA DOSEN</th>
                        <th>PEMBIMBING 1</th>
                        <th>PEMBIMBING 2</th>
                    </tr>
                </thead>
                <tbody>

<?php
extract($_POST);
$sql="select nip, nama, jabatan from dosen order by nama asc";
$q=mysql_query($sql)or die(mysql_error());
$aCat= array();
$aData=array(
	array('name'=>'pembimbing 1'),
	array('name'=>'pembimbing 2'),
);

while($r=mysql_fetch_array($q))
{

	$field=array('nip1','nip2' );
	$nip=$r['nip'];
	$num=array();
	foreach($field as $f)
	{
	  	if ($semester<>'')
	       {
		$sql="select count($f) c  from tugas_akhir
		where $f like '$nip' and semester like '%$semester%'
		group by $f";
		$q2=mysql_query($sql)or die(mysql_error());
		$r2=mysql_fetch_array($q2);
		$num[]=$r2['c'];
		}
		     else if ($tahun_ajaran<>'')
		     {
		     $sql="select count($f) c  from tugas_akhir
		     where $f like '$nip' and left( tgl_ajukan_judul, 4 ) like '$tahun_ajaran'
		     group by $f";
		     $q2=mysql_query($sql)or die(mysql_error());
		     $r2=mysql_fetch_array($q2);
		    $num[]=$r2['c'];
		     }
                       else
		          {
		          $sql="select count($f) c  from tugas_akhir
		              where $f like '$nip'
		              group by $f";
		              $q2=mysql_query($sql)or die(mysql_error());
		              $r2=mysql_fetch_array($q2);
		              $num[]=$r2['c'];
		         }
	}
		$aData[0]['data'][]=intval($num[0]);
		$aData[1]['data'][]=intval($num[1]);
		$aCat[]=$r['nama'];
?>

			<TR>
  <TD><?=$r['nama'];?></td>
  <TD class='td1a'><center><?=intval($num[0]);?></center></td>
  <TD class='td1a'><center><?=intval($num[1]);?></center></td>


</tr>
			<?php  }  ?>





			</tbody>
            </table>