#1

<table width='100%' border='0'>
  <tr bgcolor='#008080'>
    <td><b> -- Nilai Mata Palajaran Produktif RPL --</b></td>
  </tr>
  <tr><td><hr></td></tr>
  <tr><td><a href="javascript:popUp('input/inputnilai.php?kat=<?php echo $_GET['menu'];?>')">Tambah Siswa</a></td></tr>
</table>
<table border='1' width='100%'>
  <tr bgcolor='#008080'>
    <th>No</th>
    <th>NIS</th>
    <th>Nama</th>
    <th>Kelas,<br>Jurusan</th>
    <th>Jumlah<br>Absen</th>
    <th>Nilai Harian</th>
    <th>UTS</th>
    <th>UAS</th>
    <th>Nilai Raport</th>
    <th>Rangking</th>
    <th>aksi</th>
  </tr>
<?php
include "connect.php";
$sql="
SELECT
  a.siswa_nis,
  a.siswa_nama,
  b.kelas_nama,
  c.jurusan_nama,
  d.nilai_harian,
  d.nilai_uts,
  d.nilai_uas,
  (0.75*(d.nilai_uts)+(1.25*(d.nilai_uas))/3) as nilai_raport
FROM
  siswa a
  JOIN kelas b ON a.siswa_kode_kelas=b.kelas_kode
  JOIN jurusan c ON a.siswa_kode_jurusan=c.jurusan_kode
  JOIN nilai d ON a.siswa_nis=d.kode_siswa
ORDER BY
  a.siswa_nis ASC";
$result=mysql_query($sql);
$no=1;
while($record=mysql_fetch_object($result))
{
  echo
      "<tr>
        <td>".$no++."</td>
        <td>"$record->siswa_nis."</td>
        <td>".$record->siswa_nama."</td>
        <td>".$record->kelas_nama.",".$record->jurusan_nama."</td>
        <td>&nbsp;</td>
        <td>".$record->nilai_harian."</td>
        <td>".$record->nilai_uts."</td>
        <td>".$record->nilai_uas."</td>
        <td>".$record->nilai_raport."</td>
        <td>&nbsp;</td>
        <td align='center'>
          <a href=\"javascript:popUp('input/editnilai.php?kat=".$_GET['kat']."&kode=".$record->siswa_nis."')\">
            <img src='gambar/edit.png' title='input nilai'>
          </a>
        </td>
      </tr>";
}
?>
</table>