<?php 
include("../conexion.php");

//Seleccionamos los registros de la tabla

$query = mysql_query("SELECT * FROM alumnos WHERE grado = '2B'", $cn);
$contador = 0;
$grado = array(
			"1A"=>"1A",
			"1B"=>"1B",
			"1C"=>"1C",
			"2A"=>"2A",
			"2B"=>"2B",
			"2C"=>"2C",
			"3A"=>"3A",
			"3B"=>"3B",
			"3C"=>"3C",
			"4A"=>"4A",
			"4B"=>"4B",
			"4C"=>"4C",
			"5A"=>"5A",
			"5B"=>"5B",
			"5C"=>"5C",
			"6A"=>"6A",
			"6B"=>"6B",
			"6C"=>"6C"
		 );

?>

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<link rel="stylesheet" type="text/css" href="../style.css"/>

<script type="text/javascript" src="../jquery.js"></script>
<script type="text/javascript" src="../jquery.jeditable.js"></script>
<script type="text/javascript" src="../js.js"></script>

</head>
<body>
	<fieldset id="content">
    	<legend>Comentarios de 2B</legend>
     	<div class="datagrid"> <table id="table">
            <thead>
            	<tr class="head">
            		    <th>Nro</th>
                    <th>Grado</th>
                    <th>Alumno/a</th>
                    <th>Inglés</th>
                    
                                   </tr>
                
            </thead>
            <tbody>
            		 	<?php
				while($row = mysql_fetch_array($query))
				{
					$id = $row['id_usuario'];
					$contador++;
					?>
			        			<tr>
							          <td><?php echo $contador ?></div></td>            
                        <td><div class="texxt" id="grado-<?php echo $id ?>"><?php echo $row['grado']?></div></td>
                        <td><div class="texxt" id="nombre-<?php echo $id ?>"><?php echo $row['nombre']?></div></td>
                        <td><div class="textarea"  id="ingles-<?php echo $id ?>"><?php echo $row['ingles']?></div></td>
                       
                    </tr>
					<?php
				}
				 ?>
            </tbody>
        </table>
         </div>
    </fieldset>
	
</body>
</html>
