function reservasAlumno()
{
$user_name = $_SESSION['user_name'];
$query = mysql_query("SELECT reservation_week, reservation_time, reservation_day \nFROM phpmyreservation.phpmyreservation_reservations\nwhere reservation_user_name='" . $user_name . "'\norder by reservation_week") or die('<span class="error_span"><u>MySQL error:</u> ' . htmlspecialchars(mysql_error()) . '</span>');
$resS = '';
if (mysql_num_rows($query) > 0) {
while ($r = mysql_fetch_array($query)) {
$resS = $resS . "<tr><td>Sector: " . $r[0] . "</td><td> Fila: " . $r[1] . "</td><td> Asiento: " . mapeaAsiento($r[0], $r[2], $r[1]) . "</td></tr>";
}
}
return "<table border=1>" . $resS . "</table>";
}
$sec=array(12,14,16,18,20,22,24,26,28,30,32);
break;
}
$asientoN=$sec[$asientoC-1];
return $asientoN;
}
*/
while ($reg = mysql_fetch_array($registros)) {
echo '<tr>';
echo '<td>' . $reg['reservation_id'] . '</td>';
echo '<td>' . $reg['reservation_user_name'] . '</td>';
echo '<td>' . $reg['nombre'] . '</td>';
echo '<td>' . $reg['reservation_year'] . '</td>';
echo '<td>' . $reg['reservation_week'] . '</td>';
echo '<td>' . $reg['reservation_time'] . '</td>';
echo '<td>' . mapeaAsiento($reg['reservation_week'], $reg['reservation_day']) . '</td>';
echo '<td>' . $reg['reservation_user_email'] . '</td>';
echo '<td>' . $reg['reservation_made_time'] . '</td>';
echo '</tr>';
}
echo "</tbody></table>";
mssql_close($conexion);
//}
?>
</section>
<script type="text/javascript" language="javascript">
ajustarPagina();
</script>
