This is basically what I want to do :
A user , in this case a teacher, wants by selectin a suitable option to be able to edit all his students absencies reports by input boxes.
Here's what my table for the students looks like (nevermind that the real names are in greek) :
Here's what my browser shows up (yes that's in greek too but you'll get the idea):
$query = "SELECT * FROM absencies WHERE class = '$myclass' " ; //shows all students that are in the same class as the teacher/user is
$result = mysql_query($query);
while ($row= mysql_fetch_array($result)){
echo "<table width=800 border=1 cellpading=1>
<tr>
<td><b>Real name:</b></td>
<td>".$row['realname']."</td>
</tr>
<tr>
<td> Unjustified absecnies of Year 1 , Semester 1 :</td>
<td>".$row['A1a']."</td>
<td>
<form action='absencies.php' method='POST' accept-charset='UTF-8'>
<input type='hidden' name='submitted' value=1>
<input type='text' name='A1a'>
<input type='submit' name='submit' value='Edit'></td>
</tr>
<tr>
<td>Justified absencies of Year 1, Semester 1 :</td>
<td>". $row['A1d']."</td>
<td><input type='text' name='A1d'><input type='submit' name='submit' value='Edit'></td>
</tr>
<tr>
<td>unjustified absencies of Year 1, semester 2:</td>
<td>".$row['A2a']."</td>
<td><input type='text' name='A2a'><input type='submit' name='submit' value='Edit'></td>
</tr>
<tr>
<td>Justified absencies of Year 1 , semester 2:</td>
<td>".$row['A2d']."</td>
<td><input type='text' name='A2d'><input type='submit' name='submit' value='Edit'></td>
</tr>
etc. for all semesters
...
</table>
if ($_POST['submitted']==1) {
// THIS WHERE I SHOULD enterMY queries *update" etc.
}
}
}
