kode inner join

 <form>

         <table width="100%" border="1" cellspacing="0" cellpadding="0">
  <tr>
    <td width="4%" bgcolor="#FFFF00"><div align="center"><strong>No</strong></div></td>
    <td width="15%" bgcolor="#FFFF00"><div align="center"><strong>Penyakit</strong></div></td>
    <td width="45%" bgcolor="#FFFF00"><div align="center"><strong>Gejala</strong></div></td>
    <td width="10%" bgcolor="#FFFF00"><div align="center"><strong>MB</strong></div></td>
    <td width="15%" bgcolor="#FFFF00"><div align="center"><strong>Aksi</strong></div></td>
  </tr>

<?php


//ini kodenya digabungkan dengan kode paginasi

$sqlCount = "select count(*) from nilaicf";
$rsCount = mysql_fetch_array(mysql_query($sqlCount));
$banyakData = $rsCount[0];
$page = isset($_GET['page']) ? $_GET['page'] : 1;
$limit = 7;
$mulai_dari = $limit * ($page - 1);
$sql_limit = "select penyakit.namapenyakit, gejala.namagejala, nilaicf.id_nilaicf
FROM(penyakit INNER JOIN nilaicf on namapenyakit.penyakit=nilaicf.namapenyakit) INNER JOIN gejala on nilaicf.namagejala=gejala.namagejala order by id_nilaicf limit $mulai_dari, $limit";
$hasil = mysql_query($sql_limit);


            $no = 1;


            while ($data = mysql_fetch_array($hasil)) {



            ?>
  <tr>
    <td><?php echo $no; ?></td>
    <td>


    <?php echo '<option value="'.$data['id_penyakit'].'">'.$data['namapenyakit'].'</option>';
    ?>

    </td>
    <td><?php echo '<option value="'.$data['id_gejala'].'">'.$data['namagejala'].'</option>';
    ?>  </td>
    <td><?php echo $data['MB']?></td>
    <td> <div align="center"> <a href="../nilaicf/edit.php?id=<?php echo $data['id_nilaicf']; ?>">Edit</a> ||
        <a href="../nilaicf/delete.php?id=<?php echo $data['id_nilaicf']; ?>">Hapus</a></div></td>
  </tr>

  <?php
                        $no++;
            }

            ?>

</table>
<?php
echo "<br />";
$banyakHalaman = ceil($banyakData / $limit);
echo 'Halaman: ';
for($i = 1; $i <= $banyakHalaman; $i++){
 if($page != $i){
 echo '[<a href="index-nilaicf.php?page='.$i.'">'.$i.'</a>] ';
 }else{
 echo "[$i] ";
 }
}

?>
      </table>