selecting a row

[spoilchile]

I have outputted several rows from a MySQL table together with a checkbox on each row. I would like to select rows via the checkboxes and submit the selected rows to another table but when I click the submit button only the value of the last row is inserted. I know I have to introduce a counter but I am not sure how to implement this. Could someone kindly show me how to? See code snippet below:

$sql="SELECT * FROM student WHERE semester='$sem'";
$result=mysql_query($sql)or die(mysql_error());

echo "<table align=\"center\" width=\"40%\" border=\"1\">";
echo "<tr><th colspan=\"3\">SEMESTER ".$sem." STUDENTS</th></tr>";
echo "<tr>";
echo "<th>Add</th>";
echo "<th>StudentID</th>";
echo "<th>Student Name</th>";
echo "</tr>";

while ($row = mysql_fetch_array($result)){
$id=$row['id'];
$sid=$row['studentid'];
$fname=$row['firstname'];
$lname=$row['lastname'];

echo "<tr>";
echo "<td align=\"center\"><input type=\"checkbox\" name=\"add\" /></td>";

echo "<td align=\"center\"><input type=\"text\" name=\"stdid\" value=\"".$sid."\" READONLY /></td>";

echo "<td align=\"center\"><input type=\"text\" name=\"stdname\" value=\"".$fname." ".$lname."\" READONLY /></td>";
echo "</tr>";

}
echo "</table>";

[djjjozsi]

use an array name in the form element name:

echo "<td align=\"center\"><input type=\"checkbox\" name=\"add[]\" /></td>";

and on the processing php program, lets print the elements ilst with foreach
like this:

if (isset($_POST["add"]))
{
   foreach($_POST["add"] AS $values)
   {
      print "selected ID: $values<br>";
   }
}

where are your form anyway?

<form name="form" method="post" action="updater.php">

form elements here.............

<input type="submit" name="Submit" value="Submit">
</form>

spoilchile;10892108 wrote:

I have outputted several rows from a MySQL table together with a checkbox on each row. I would like to select rows via the checkboxes and submit the selected rows to another table but when I click the submit button only the value of the last row is inserted. I know I have to introduce a counter but I am not sure how to implement this. Could someone kindly show me how to? See code snippet below:

$sql="SELECT * FROM student WHERE semester='$sem'";
$result=mysql_query($sql)or die(mysql_error());

echo "<table align=\"center\" width=\"40%\" border=\"1\">";
echo "<tr><th colspan=\"3\">SEMESTER ".$sem." STUDENTS</th></tr>";
echo "<tr>";
echo "<th>Add</th>";
echo "<th>StudentID</th>";
echo "<th>Student Name</th>";
echo "</tr>";

while ($row = mysql_fetch_array($result)){
$id=$row['id'];
$sid=$row['studentid'];
$fname=$row['firstname'];
$lname=$row['lastname'];

echo "<tr>";
echo "<td align=\"center\"><input type=\"checkbox\" name=\"add\" /></td>";

echo "<td align=\"center\"><input type=\"text\" name=\"stdid\" value=\"".$sid."\" READONLY /></td>";

echo "<td align=\"center\"><input type=\"text\" name=\"stdname\" value=\"".$fname." ".$lname."\" READONLY /></td>";
echo "</tr>";

}
echo "</table>";

[spoilchile]

I ommitted the form tags purposely. I will try this and let you know. Thanks for the assistance!

[spoilchile]

It works!!! The only change I made was $POST['add'] and not $POST["add"] and it inserted each row successfully. Thanks again!