<?php
$dbhost='localhost';
$dbuser='root';
$dbpass="";
$dbconn=mysql_connect($dbhost,$dbuser,$dbpass) or die ('Error Connecting to MySQL');
$dbname='db_students';
mysql_select_db($dbname);
//table names
echo "<br><table>";
echo "<tr><td width=150>Students Number</td>
<td>Student Name</td>
</tr>";
$query="SELECT * FROM tbl_names";
$studentrow=mysql_query($query);
while($result = mysql_fetch_array($studentrow))
{
echo "<tr><td>".$result[0]."</td><td>".$result[1]."</td></tr>";
}
echo "</table>";

//table subjects
echo "<br><table>";
echo "<tr><td width=150>Subject Code</td>
<td>Student Description</td>
</tr>";
$query="SELECT * FROM tbl_subjects";
$studentrow=mysql_query($query);
while($result = mysql_fetch_array($studentrow))
{
echo "<tr><td>".$result[0]."</td><td>".$result[1]."</td></tr>";
}
echo "</table>";

//relation between the tables
//name
echo "<br><table>";
echo "<tr><td width=150>Student Name</td>
<td>Subject Description</td>
</tr>";
$query="SELECT * FROM `tbl_names_students` WHERE `Student Name` = 'Armando Asuncion'";
$studentrow=mysql_query($query);
while($result = mysql_fetch_array($studentrow))
{
echo "<tr><td>".$result[0]."</td><td>".$result[1]."</td></tr>";
}
//next name
$query="SELECT * FROM `tbl_names_students` WHERE `Student Name` = 'Benjie Cruz'";
$studentrow=mysql_query($query);
while($result = mysql_fetch_array($studentrow))
{
echo "<tr><td>".$result[0]."</td><td>".$result[1]."</td></tr>";
}
//next name
$query="SELECT * FROM `tbl_names_students` WHERE `Student Name` = 'Jehart Bonilla'";
$studentrow=mysql_query($query);
while($result = mysql_fetch_array($studentrow))
{
echo "<tr><td>".$result[0]."</td><td>".$result[1]."</td></tr>";
}
//next name
$query="SELECT * FROM `tbl_names_students` WHERE `Student Name` = 'Jan Paul Lachica'";
$studentrow=mysql_query($query);
while($result = mysql_fetch_array($studentrow))
{
echo "<tr><td>".$result[0]."</td><td>".$result[1]."</td></tr>";
}
echo "</table>";
?>