I can't figure out while the table rows and columns are not display as intended. I have tried everything I could but no solution yet. I'm new to PHP/Mysql.
What I actually wanted to see as the output is something like this:
[B]$days_of_week_rows['week_day'][/B]
$period_rows['period'] $class_rows['class'] $time_rows['time']
$period_rows['period'] $class_rows['class'] $time_rows['time']
$period_rows['period'] $class_rows['class'] $time_rows['time']
$period_rows['period'] $class_rows['class'] $time_rows['time']
But instead I see something like this:
[B]$days_of_week_rows['week_day'[/B]
$period_rows['period']
$period_rows['period']
$period_rows['period']
$period_rows['period']
$class_rows['class']
$class_rows['class']
$class_rows['class']
$class_rows['class']
$time_rows['time']
$time_rows['time']
$time_rows['time']
$time_rows['time']
Here is the PHP Code
?>
<table width="100%" height="100%" cellspacing="0" cellpadding="0" border="1px">
<?php
$days_of_week_count = 1;
while($days_of_week_count < 6)
{
$select_days_of_week = "SELECT week_dayID, week_day FROM week_day
WHERE week_dayID = '".$days_of_week_count."'";
$result_days_of_week = mysql_query($select_days_of_week) or die('Couldn\'t select from the week_day table' . mysql_error());
while($days_of_week_rows = mysql_fetch_array($result_days_of_week))
{
$week_dayID = $days_of_week_rows['week_dayID'];
echo "<tr><td colspan='3'>" . $days_of_week_rows['week_day'] . "</td></tr>";
//Select information from period
$period_select = "SELECT period FROM table_period
INNER JOIN table_relate
ON table_period.periodID = table_relate.periodID
WHERE teacherID = '".$teacherID."' AND week_dayID = '".$week_dayID."'";
$period_result = mysql_query($period_select) or die('Couldn\'t select from table_period ' . mysql_error());
while($period_rows = mysql_fetch_array($period_result))
{
echo "<tr><td>" .$period_rows['period']. "</td></tr>";
}
//Select information from class
$class_select = "SELECT class FROM table_class
INNER JOIN table_relate
ON table_class.classID = table_relate.classID
WHERE teacherID = '".$teacherID."' AND week_dayID = '".$week_dayID."'";
$class_result = mysql_query($class_select) or die('Couldn\'t select from table_class ' . mysql_error());
while($class_rows = mysql_fetch_array($class_result))
{
echo "<tr><td>" .$class_rows['class']. "</td></tr>";
}
//Select information from time
$time_select = "SELECT time FROM table_time
INNER JOIN table_relate
ON table_time.timeID = table_relate.timeID
WHERE teacherID = '".$teacherID."' AND week_dayID = '".$week_dayID."'";
$time_result = mysql_query($time_select) or die('Couldn\'t select from table_time ' . mysql_error());
while($time_rows = mysql_fetch_array($time_result))
{
echo "<tr><td>" .$time_rows['time']. "</td></tr>";
}
}
$days_of_week_count = $days_of_week_count + 1;
}
echo "</table>";
and the html output code when I view source from the browser
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Strict//EN"
"http://www.w3.org/TR/xhtml1/DTD/xhtml1-strict.dtd">
<html xmlns="http://www.w3.org/1999/xhtml" xml:lang="en" lang="en">
<head>
<meta http-equiv="content-type" content="text/html; charset=utf-8" />
<title>Welcome to UPSS | Add a Teacher's Time Table</title>
<link rel="stylesheet" href="../../css/add_teacher_complete.css" type="text/css" />
<body>
<div id="header">
<div id="left_header_content">
<p class="school_name">University Preparatory Secondary School (UPSS)</p>
<p class="school_slogan">Knowledge & Virtue.</p>
</div>
</div>
<div id="wrapper">
<p class="heading">Preview Newly Added Teacher</p>
<div id="main_content">
<table width="100%" height="100%" cellspacing="0" cellpadding="0" border="2px">
<tr><td colspan='3'>Monday</td></tr><tr><td>1</td></tr><tr><td>3</td></tr><tr><td>5</td></tr><tr><td>8</td></tr><tr><td>JS 1 Diamond</td></tr><tr><td>JS 1 Silver</td></tr><tr><td>JS 1 Silicon</td></tr><tr><td>JS 2 Mercury</td></tr><tr><td>8:10am - 8:55am</td></tr><tr><td>9:40am - 10:25am</td></tr><tr><td>11:10am - 11:55am</td></tr><tr><td>1:50pm - 2:30pm</td></tr><tr><td colspan='3>
</table>
</div>
</div>
</div>
</body>
</html>
Please help me point out where I'm doing it wrong