Untitled

<?php
include 'mobile.php';
session_start();
if(!session_is_registered(myusername)){
header("location:main_login.php");
}
ini_set( "display_errors", 0);
$host="localhost"; // Host name
$username="sericx_fyp"; // Mysql username
$password="123"; // Mysql password
$db_name="sericx_members"; // Database name
$tbl_name="timetable"; // Table name

$sname = ($_SESSION['myusername']);

// Connect to server and select databse.
mysql_connect("$host", "$username", "$password")or die("cannot connect");
mysql_select_db("$db_name")or die("cannot select DB");
?>
<html>
<body>
<?php

$query="SELECT day, unit, start, end, type, room FROM timetable where username = '$sname' ORDER BY FIND_IN_SET(day,'Mon,Tue,Wed,Thu,Fri'), start asc";
$result=mysql_query($query);
$tquery="SELECT DATE_FORMAT(MAX(timestamp), '%M %D, %Y') FROM timetable AS UserTimestamp where username = '$sname'";
$tresult=mysql_fetch_array($tquery);
$tstamp=$tresult['UserTimestamp'];

$num=mysql_numrows($result);

mysql_close();
?>
<table width="395" border="1" cellspacing="2" cellpadding="2">
<tr>
<th><font face="Arial, Helvetica, sans-serif">Day</font></th>
<th><font face="Arial, Helvetica, sans-serif">Unit</font></th>
<th><font face="Arial, Helvetica, sans-serif">Start</font></th>
<th><font face="Arial, Helvetica, sans-serif">End</font></th>
<th><font face="Arial, Helvetica, sans-serif">Type</font></th>
<th><font face="Arial, Helvetica, sans-serif">Room</font></th>
</tr>

<?php
$i=0;
while ($i < $num) {


$f1=mysql_result($result,$i,"day");
$f2=mysql_result($result,$i,"unit");
$f3=mysql_result($result,$i,"start");
$f4=mysql_result($result,$i,"end");
$f5=mysql_result($result,$i,"type");
$f6=mysql_result($result,$i,"room");
?>

<tr>
<td><font face="Arial, Helvetica, sans-serif"><?php echo $f1; ?></font></td>
<td><font face="Arial, Helvetica, sans-serif"><?php echo $f2; ?></font></td>
<td><font face="Arial, Helvetica, sans-serif"><?php echo $f3.":00"; ?></font></td>
<td><font face="Arial, Helvetica, sans-serif"><?php echo $f4.":00"; ?></font></td>
<td><font face="Arial, Helvetica, sans-serif"><?php echo $f5; ?></font></td>
<td><font face="Arial, Helvetica, sans-serif"><?php echo $f6; ?></font></td>
</tr>

<?php
$i++;
}
?>
</body>
</html>