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>