t.php

<?php session_start();
$data = $_SESSION['data'];
$allo = $_SESSION['allo'];
include 'settings.php';
include 'auth_check_header.php';

include"master_inc.php";
$username_from_cookie = $_COOKIE[$cookiename]; //retrieve contents of cookie 

$con = mysql_connect("$host","$user","$pass");
if (!$con)
  {
  die('Could not connect: ' . mysql_error());
  }

mysql_select_db("$daba2", $con);

$result = mysql_query("SELECT * FROM users WHERE username='$username_from_cookie'");

while($row = mysql_fetch_array($result))
  {
  $fn = $row['firstname'];
  }


mysql_close($con);
 ?>
<!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>Supervision Allotter For examination <?php echo $data[0][3] ?></title>
</head>
<body>


<table border="1" cellpadding="5" cellspacing="0" >
<tr>
<td colspan="100%">
<h1><center><h3>Supervision duties for <?php echo $fn; ?></h3></center></h1>
</td>
</tr>
<tr>
<td><b><center>Dates</center></b></td><td width="50"><b><center>Session</center></b></td><td width='50'><b><center>Duty</center></b></td></tr>
<?php
$j = '1';
while($j <= $data[0][2]):
$j_one = $j - 1;
if($data[2][$j_one][0] == $fn){
	$m = '1';
	while($m <= $data[0][0]):
	$m_one = $m - 1;
	$ttoghsdgshdfsghdfsgh = $data[1][$m_one][0]+$data[1][$m_one][1]+$data[1][$m_one][2]+$data[1][$m_one][3];
	if($ttoghsdgshdfsghdfsgh != '0'){
	echo '<tr>';

	echo '<td rowspan="2"><center><b>'.$data[3][$m_one].'</b></center><td><center><b>M</b></center></td><td><center>'.$allo[$m_one]['m'][$j_one].'</center></td></tr><tr><td><center><b>E</b></center></td><td><center>'.$allo[$m_one]['e'][$j_one].'</center></td>';}

	echo '</tr>';
	$m++;
	endwhile;


}
$j++;
endwhile;
?>
</table>
<a href="index.php">Home</a>
</body>
</html>