Help! Not sure how to do something..

[Luke]

I'm absolutely stumped by this so I'll try and explain it the best I can.

I'd like to make an attendance system for a web app I'm making (nothing public, just a closed personal system). I want to grab all the data from the 'users' table and display the 'forename' and 'surname' on a table. Then each 'name' will have a radio button group. Like this:


<?php
include "functions.php";
$query = "SELECT * FROM users ORDER by surname ASC";
$result = mysql_query($query) or die(mysql_error());
$row = mysql_fetch_assoc($result);
?>
<table>
<tr>
<td>Name</td>
<td colspan="5"></td>
</tr>
<form id="form" name="form" method="post" action="process.php">
<?php do { ?>
<tr>
<td><?php echo $row['forename']. ' ' .$row['surname']; ?></td>
<td><input type="radio" name="<?php echo $row['id']; ?>" id="<?php echo $row['id']; ?>_PU" value="PU" >PU</td>
<td><input type="radio" name="<?php echo $row['id']; ?>" id="<?php echo $row['id']; ?>_PC" value="PC">PC</td>
<td><input type="radio" name="<?php echo $row['id']; ?>" id="<?php echo $row['id']; ?>_AA" value="AA">AA</td>
<td><input type="radio" name="<?php echo $row['id']; ?>" id="<?php echo $row['id']; ?>_S" value="S">S</td>
<td><input type="radio" name="<?php echo $row['id']; ?>" id="<?php echo $row['id']; ?>_AWOL" value="AWOL">AWOL</td>
</tr>
<?php } while ($row = mysql_fetch_assoc($result)); ?>
</form>
</table>

Now, what would I have to do, so that when I press the submit button, it will get all this data, and add the data to a table called attendance? I want the table to look something like this



id
user_id
record
date


*AI*
1 (or row['id'])
PU (or one of the radio buttons)
CURRENT_TIMESTAMP



with the id and date being automatic.

Can anyone shed any light? I'm pretty new to this and just tinkering around

Many thanks in advance

[Luke]

I figured it out. For anyone interested:



<?php
include "functions.php";
$query = "SELECT * FROM users ORDER by surname ASC";
$result = mysql_query($query) or die(mysql_error());
$row = mysql_fetch_assoc($result);
?>
<table>
<tr>
<td>Name</td>
<td colspan="5"></td>
</tr>

<tbody>
<form id="form" name="form" method="post" >
<?php
$idx = 0;
do {
?>
<tr>
<td><?php echo $row['forename']. ' ' .$row['surname']; ?></td>
<td><input type="radio" name="radioName[<?php echo $idx; ?>]" value="PU" >PU</td>
<td><input type="radio" name="radioName[<?php echo $idx; ?>]" value="PC">PC</td>
<td><input type="radio" name="radioName[<?php echo $idx; ?>]" value="AA">AA</td>
<td><input type="radio" name="radioName[<?php echo $idx; ?>]" value="S">S</td>
<td><input type="radio" name="radioName[<?php echo $idx; ?>]" value="AWOL">AWOL</td>
</tr>
<input type = "hidden" value = "<?php echo $row['id']; ?>" name="userId[<?php echo $idx; ?>]">

<?php $idx ++; ?>
<?php } while ($row = mysql_fetch_assoc($result)); ?>
</tbody>
<input type = "submit" value = "Register" >
</form>

</table>


</br>
<?php

if (isset($_POST['radioName'][0])) {

foreach ($_POST['radioName'] as $index => $value) {


if (empty($value)) {
echo "You must select the radio button.";
break;
}
$record = $_POST['radioName'][$index];
$userId = $_POST['userId'][$index];

$query = "INSERT INTO attendance(user_id, record, date)
VALUE ('$userId','$record', NOW())";
$result = mysql_query($query) or die('Query failed: ' . mysql_error());
}
echo "Data stored successly!";
}

?>