[eluser]nandish[/eluser]
This is the view page
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML>
<HEAD>
<!--Created By Nandish @Unosoft Technologies-->
<TITLE>PDFDOCUMENT</TITLE>
<META NAME="Generator" CONTENT="EditPlus">
<META NAME="Author" CONTENT="">
<META NAME="Keywords" CONTENT="">
<META NAME="Description" CONTENT="">
<style type="text/css">
body {
background-color:white;
font-family:arial;
color:black;
}
td{
padding-left:2px;
padding-right:1px;
}
</style>
</head>
<body>
<table border='1' cellspacing='0' cellpadding='0' width='100%' align='center'>
<tr><td colspan='8' align='center'><h2>Game Schedule Details</h2></td></tr>
<tr><td colspan='8' align="right">
<!--<font color="black">Year:</font> <?php echo $year;?> <font color="black">School Name:</font> <?php echo $schoolName;?>-->
</td>
</tr>
<?php
if (count($res)>0){
?>
<tr id="heading">
<td align ='center'>Home School Name</td>
<td align = 'center'>Guest School Name </td>
<td align = 'center'>Game Date</td>
<td align = 'center'>Day</td>
<td align = 'center'>Time</td>
</tr>
<?php
foreach ($res as $items){
echo "<tr>";
echo "<td>".$items['s_hs_name']."</td>";
echo "<td>".$items['s_gs_name']."</td>";
$matchdate = $items['dt_match_date'];
$date1 = date('m/d/Y', strtotime($matchdate));
$dateandtime = date('Y-M-d-D H:i', strtotime($matchdate));
$dateortime = split(" ", $dateandtime);
$dateandday = split("-",$dateortime[0]);
echo "<td>".$date1."</td>";
echo "<td>".$dateandday[3]."</td>";
echo "<td>".$dateortime[1]."</td>";
echo "</tr>";}
}
else{
echo "<div align='center'><h2>NO GAMESCHEDULE FOR THIS YEAR</h2></div>";
}
?>
</table>
</body>
</html>