Mine

<?php
include "level2_check.php";
?>
<?php
include("config.php");
$user_id = $_SESSION['userid'];
$username = $_SESSION['username'];
$pass = "";

$sql="SELECT * FROM activity_table WHERE user_id='" . $user_id . "'";
$result=mysql_query($sql);
$count=mysql_num_rows($result);

if(isset($_POST['Delete']))
{ 
	for($i=0;$i<$count;$i++){
		$del_id = $checkbox[$i];
		$sql = "DELETE FROM activity_table WHERE activity_id='$del_id'";
		$result = mysql_query($sql);
}
}
?>

 
<html>
<head>
<title></title>
<meta http-equiv="Content-Style-Type" content="text/css">
<LINK HREF="style.css" TYPE="text/css" REL="stylesheet">

</head>

<body>
<table width="100%" height="100%"  border="0" cellpadding="0" cellspacing="0">
  <tr>
    <td style="border-right:1px solid #D4D4D4 ">&nbsp;</td>
    <td width="617" align="left" valign="top"><table width="617"  border="0" cellspacing="0" cellpadding="0">
      <tr>
        <td align="left" valign="top"><img src="images/header.jpg"></td>
      </tr>
      <tr>
        <td align="center" valign="top" background="images/repus_1.jpg" style="border-left:1px solid #ffffff; border-right:1px solid #ffffff; background-position:top; background-repeat:repeat-x "><table width="197" height="100%"  border="0" cellpadding="0" cellspacing="0">
          <tr>
            <td height="4" align="left" valign="top"><img src="images/spacer.gif" width="1" height="4"></td>
          </tr>
          <tr>
            <td height="100%" align="left" valign="top"><table width="609" height="100%"  border="0" cellpadding="0" cellspacing="0">
                <tr>
                  <td height="25" align="left" valign="top" background="images/priva.jpg"><div style="padding-left:9px; padding-top:2px"><?php 
echo "<span class='style5'>Welcome: ".$_SESSION['username']."</span>";
 ?><span class="style5"> - [ <a href='logout.php' class="style5">Log out</a> ]</span></div></td>
                </tr>
                <tr>
                  <td height="100%" align="left" valign="top" bgcolor="#FFFFFF" style="border-left:1px solid #D0D0D0; border-right:1px solid #D0D0D0; border-bottom:1px solid #D0D0D0">
				  
	<div style="margin-left: 10px; margin-bottom:10px; margin-top:5px; margin-right:10px">
	<form name="form1" method="post" action="viewactivity.php">
	<p align="center" class="style12"><strong>Classes</strong></p>
	<table border="1" cellpadding="10" cellspacing="0">
	<tr class="style13">
		
		<td>Date</td>
		<td>Type</td>
		<td>Teacher</td>
		<td>School</td>
		<td>Period</td>
		<td>Last Editted</td>
		<td>Delete</td>
	</tr>
	
<?php
		//fetch the data from the database
		while ($row = mysql_fetch_array($result)) {
		$teacher = $row['teacher'];
		$query1="SELECT Last_Name,First_Name FROM Teacher WHERE Teacher_ID ='" . $teacher . "'";
		$result1 = mysql_query($query1);
		$nt1 = mysql_fetch_array($result1);
		$school = $row['school'];
		$query2="SELECT School_Name FROM School WHERE School_ID ='" . $school . "'";
		$result2 = mysql_query($query2);
		$nt2 = mysql_fetch_array($result2);
		$activitytype = $row['activitytype'];
		$query3="SELECT Type_Name FROM Type WHERE Type_ID ='" . $activitytype . "'";
		$result3 = mysql_query($query3);
		$nt3 = mysql_fetch_array($result3);
?>
<tr class="style12">
<td bgcolor="#FFFFFF"><? echo $row['date']; ?></td>
<td bgcolor="#FFFFFF"><? echo $nt3[Type_Name]; ?></td>
<td bgcolor="#FFFFFF"><? echo $nt1[First_Name]; ?></td>
<td bgcolor="#FFFFFF"><? echo $nt2[School_Name]; ?></td>
<td bgcolor="#FFFFFF"><? echo $row['period']; ?></td>
<td bgcolor="#FFFFFF"><? echo $row['date_entered']; ?></td>
<td align="center" bgcolor="#FFFFFF">
<input name="delete[]" type="checkbox" value="<? echo $row['activity_id']; ?>"></td>
</tr><tr class="comments"><td colspan="7"><? echo $row['comments']; ?></td></tr>
<?php
}
?>

</table>
<input type="submit" name="Delete" value="Delete">
</form>
				  <div align="right"> <a href="index.php" class="style11">« Back to main page</a></div>
				  </td>
                </tr>
            </table></td>
          </tr>
        </table></td>
      </tr>
      <tr>
        <td height="58" align="left" valign="top" background="images/rep_1.jpg"  style="border-right:1px solid #ffffff; border-left:1px solid #ffffff; background-position:top; background-repeat:repeat-x "><div style="padding-left:11px; padding-top:28px">
			<span class="style10"></span></div></td>
      </tr>
    </table></td>
    <td style="border-left:1px solid #D4D4D4 ">&nbsp;</td>
  </tr>
  <tr>
    <td height="100%" style="border-right:1px solid #D4D4D4 ">&nbsp;</td>
    <td width="617" height="100%" align="left" valign="top">&nbsp;</td>
    <td height="100%" style="border-left:1px solid #D4D4D4 ">&nbsp;</td>
  </tr>
</table>
</body>
</html>