Resultado Menu Código PHP:
<?php
session_start();
include('cxn.php');
$sql = mysql_query("SELECT m.nombre_materia, u.id_usuario FROM tbl_materias AS m, tbl_usuarios AS u, tbl_relacion AS r WHERE m.id_materia=r.id_materia AND u.id_usuario = r.id_usuario AND u.id_usuario ='".$_SESSION['id_usuario']."'");
<form action="Cslt_Notas_Unicas.php" method="post">
<p>
<select name="materias">
<option value="">Seleccione </option>
<?php
while ($row = mysql_fetch_assoc($sql))
{
print "<option value= ".$row['id_usuario'].">".$row['nombre_materia']."</option>";
}
?>
</select>
<input align="middle" type="submit" value="Ver"/>
</form>
</body>
</html> Código PHP:
<?php
session_start();
include('cxn.php');
?>
<!DOCTYPE html PUBLIC "-//WAPFORUM//DTD XHTML Mobile 1.0//EN" "http://www.wapforum.org/DTD/xhtml-mobile10.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<title>Notas Estudiante</title>
</head>
<body>
<?php
$find = $_POST['materias'];
$cslt = mysql_query("SELECT m.nombre_materia, r.1erCorte, r.2doCorte, r.3erCorte FROM tbl_materias AS m, tbl_usuarios AS u, tbl_relacion AS r WHERE m.id_materia=r.id_materia AND u.id_usuario = r.id_usuario AND u.id_usuario ='".$_SESSION['id_usuario']."'") or die (mysql_error());
?>
</h2>
<table border="1" align="center">
<tr align="center" bgcolor="#CC00CC" bordercolor="#000000">
<td bgcolor="#3366FF" class="word"><em>Materia</em></td>
<td bgcolor="#33CCFF" class="word">1 Corte</td>
<td bgcolor="#33CCFF" class="word">2 Corte</td>
<td bgcolor="#33CCFF" class="word">3 Corte</td>
</tr>
<?php
while ($row = mysql_fetch_array($cslt))
{
?>
<td><?php print $row['nombre_materia']; ?> </td>
<td><?php print $row['1erCorte']; ?> </td>
<td><?php print $row['2doCorte']; ?> </td>
<td><?php print $row['3erCorte']; ?> </td>
</tr>
<?php } ?>
</table>
</body>
</html> 
