I have 1 table with checkboxes in it.. What I want to happen is to set the value of the checkbox to be the student_id
Here's my code:
<?php
require_once('xcon.php');
$q = mysql_query("SELECT * FROM Students");
?>
<table><br><br>
<thead>
<tr>
<th>Choice</th>
<th>Student ID</th>
<th>Student First Name</th>
<th>Student Last Name</th>
<th>Level</th>
</tr>
</thead>
<?php
while($row = mysql_fetch_assoc($q)){
echo "<tbody>";
echo "<tr>";
echo "<td><input type = 'checkbox' name = 'checkbox[]' ></td>";
echo "<td>".$row['student_id']."</td>";
echo "<td>".$row['fname']."</td>";
echo "<td>".$row['lname']."</td>";
echo "<td>".$row['yearlevel']."</td>";
echo "</tr>";
echo "</tbody>";
}
?>
</table>
I seem to be having the trouble of getting the logic in this and i got confused.
Thank you in advance for your help.