Radio Button Blues

SFDonovan

I have a form that has radio buttons to designate whether a person is present, absent or excused. The problem is all the radio buttons are "hooked" together and are not independent to each person. I could click on "present" for the first guy on the list and click on "absent" for the second guy and the radio button "focus" changes as well. (If you know what I mean)

This will give you a better idea.

http://www.3rd-infantry-division.net/modules.php?name=MILPACS&file=drillreport

Click the radio buttons and see how they change. I need them to be dependent for each member on this list.

echo "<html>";
echo "<head>"; 
echo "</head>";
echo "<body>";
echo "<form action=\"$_SERVER ['PHP_SELF']\" method=\"POST\">";
echo "<div align=\"center\">";
echo "<label><H2>3rd ID Drill Report</H2></label>";	
echo "<HR>";
echo "</div>";
echo "<br>";
echo "<p>";
echo "<strong>Select the Drill Date: </strong>";
echo"<INPUT TYPE=\"text\" NAME=\"drill_dt\" size=\"20\"><a href=\"javascript\">Click to Choose</a>"; 
echo "<br>";
echo "<br>"; 
echo "<label><strong>Post the Drill Report:</strong></label>";
echo "<br>";
echo "<textarea name=\"postdrill\" cols=\"120\" rows=\"10\"></textarea>";
echo "<br><p><strong>Take Attendance:</strong>";  

echo "<table border=0 width='100%' cellpadding='5'><tr>";
echo "<table border=0 width='100%' cellpadding='3'><tr><th width='15%'>Drill Status</th><th width='5%'>Rank</th><th width='15%'><b>Name</b></th><th width='8%'>Position</th><th width='5%'>Status</th>";
echo "</tr>";
echo "</table>";
	$sql = "SELECT mr.rank_abbr, mm.name, mm.position, mm.status FROM milpacs_members mm JOIN milpacs_ranks mr WHERE mm.status = 'Active' AND mm.unit_id != '' AND mm.rank_id = mr.rank_id ORDER BY mr.rank_id";
	$result = $db->sql_query($sql);
	while ( $row = $db->sql_fetchrow($result) ) {
	$rank = $row["rank_abbr"];
	$name = $row["name"];
	$position = $row["position"];
	$status = $row["status"];
echo "<table border=0 width='100%' cellpadding='5'><tr>";
echo "	<tr>";
echo"   <td align=\"center\" width=\"15%\">";
echo "	<INPUT TYPE=\"RADIO\" NAME=\"Attendance\" VALUE=\"Present\" CHECKED > Present</INPUT>";
echo "	<INPUT TYPE=\"RADIO\" NAME=\"Attendance\" VALUE=\"Absent\"> Absent</INPUT>";
echo "  <INPUT TYPE=\"RADIO\" NAME=\"Attendance\" VALUE=\"Excused\"> Excused</INPUT>";
echo "		<td align=\"center\" width=\"5%\">";
echo "			<b><font color=\"#000000\">$rank</font></b>";
echo "		</td>";
echo "		<td align=\"center\" width=\"15%\">";
echo "			<b><font color=\"#000000\">$name</font></b>";
echo "		</td>";
echo "		<td align=\"center\" width=\"8%\">";
echo "			<b><font color=\"#000000\">$position</font></b>";
echo "		</td>";
echo "		<td align=\"center\" width=\"5%\">";
echo "			<b><font color=\"#000000\">$status</font></b>";
echo "		</td>";
	}
echo "	</tr>";
echo "</table>";
echo "</form>";
echo "</body>";
echo "</html>";

Thanks in advance

-Donovan

FirEwAteR

you need to make each section have a different name. so make a counter and add it to the end like so:

$count = "1";
while ( $row = $db->sql_fetchrow($result) ) {
    $rank = $row["rank_abbr"];
    $name = $row["name"];
    $position = $row["position"];
    $status = $row["status"];
echo "<table border=0 width='100%' cellpadding='5'><tr>";
echo "    <tr>";
echo"   <td align=\"center\" width=\"15%\">";
echo "    <INPUT TYPE=\"RADIO\" NAME=\"Attendance". $count ."\" VALUE=\"Present\" CHECKED > Present</INPUT>";
echo "    <INPUT TYPE=\"RADIO\" NAME=\"Attendance". $count ."\" VALUE=\"Absent\"> Absent</INPUT>";
echo "  <INPUT TYPE=\"RADIO\" NAME=\"Attendance". $count ."\" VALUE=\"Excused\"> Excused</INPUT>"; 
$count++;

That should solve you're problem.

SFDonovan

Thanks a bunch. That did the trick.

SFDonovan

My next question is how would I add this to my database table drill_report.

The drill_dt and postdrill field are easy enough, but how would I actually be able to take an attendance from the radio buttons. I need to hook up the id of each member to the value selected. Then add that to my table with an INSERT command. I also want to assign a numeric value to the radio button to increment a point system for promotions. Say if a trooper attended so many drills they accumulate so many points...5 points per drill. If they are absent then I subtract points.

Finally a tally of drills attended per trooper divided by 32 drills (2 drill per week for 4 months) for an attendance record %.

I know this is asking alot.

So far in my table I have

drill_id (int) autoincrement
drill_dt (date)
drill_total (int)
drill_post (text)

If anybody can assist I would be so grateful.