Untitled

mysql_select_db($database_ska, $ska);
$query_spc = "SELECT karyawan. nama, karyawan.email, kar_kegiatan.kegiatan
FROM karyawan, kar_kegiatan  where karyawan.nama=kar_kegiatan.nama";
$spc = mysql_query($query_spc, $ska) or die(mysql_error());
//$row_spc = mysql_fetch_assoc($spc);
$totalRows_spc = mysql_num_rows($spc);

?>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<title>Untitled Document</title>
</head>

<body>

    <p>&nbsp;</p>
<table border="1">
<tr>
    <td>No</td>
    <td>nama</td>
    <td>email</td>
    <td>kegiatan</td>
 </tr>
      <?php
  $i=1;
  $email='';
while($row_spc = mysql_fetch_assoc($spc)) {
if($email!=$row_spc['email']){
echo "<tr>
      <td>".$i."</td>
      <td>".$row_spc['nama']."</td>
      <td>".$row_spc['email']."</td>
      <td>".$row_spc['kegiatan']."</td>
     </tr>";
     $email=$row_spc['email'];
   $i++;
  }
  else {
      echo "<tr>
      <td></td>
      <td></td>
      <td></td>
      <td>".$row_spc['kegiatan']."</td>
     </tr>";
  }
}
  ?>
    </table>