ganti sesuai permintaan

<?php
/*
ganti query dengan mysql_query()
fetch dengan mysql_fetch_array()

*/
extract($_POST);
//$semester='ganjil';
$semester=trim(strtolower($semester));
if($semester!='genap'&&$semester!='ganjil')
{
    die('salah penginputan nilai semester ='.$semester);
}
?>
<h1><?=$semester;?></h1>
<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


$sql="select nip, nama, jabatan from dosen order by nama asc";
$q=query($sql);
$aCat= array();
$aData=array(
    array('name'=>'pembimbing 1'),
    array('name'=>'pembimbing 2'),
);

while($r=fetch($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=query($sql);
        $r2=fetch($q2);
        $num[]=$r2['c'];
        }
        elseif($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=query($sql);
             $r2=fetch($q2);
            $num[]=$r2['c'];
        }
        else
        {
                  $sql="select count($f) c  from tugas_akhir
                      where $f like '$nip'
                      group by $f";
                      $q2=query($sql);
             $r2=fetch($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>