Need advice on processing dynamic forms

[Anon]

Ok, I'm stumped on how to best do this.
I have several ways that I can do it but seems messy to me so I'm asking for any help on this.

I have a form that is generated with the result of a query, each row returned from the query is
used in the form and a checkbox is added. I want the user to check off multiple records to be
modified and process the form.

I have a line that generates the form like so:

print "<tr><td>$id</td><td>$action</td><td>$request_dt</td><td><input type=checkbox name=request$id></td></tr>\n";

I want to be able to loop through and get the $id and $action and perform my query actions for that
record and move on. I know I have seen this used in many web sites but have never needed to do it myself.
I have toyed with using REs to get the $id from the name and process it but seems to me there must be a better way.

Thanks in advance for any advice!

-Ray

[Anon]

Probably if you name the checkbox the same name for all of them something like action_items[] and make the value the id number. It would create an array $action_items, that wouold all all the ids that were checked, then you could loop through he array and process them any way you like. Is thazt what you are after?

[Anon]

<?php
include("../etc/global.inc");

//Database connection parameters.
$dbh = mysql_connect($host,$user,$pass);
mysql_select_db($dbname);

$sql = "SELECT * FROM queue WHERE processed='no' ORDER BY ou ASC";
$result = mysql_query($sql);

echo "<table width=622 border=1>\n";
echo "<tr><th>Req. Number</th><th>Facility</th><th>User</th><th>Title</th><th>Action</th><th>Date Requested</th><th>Approval</th></tr>\n";
echo "<form method=post action=\"$PHP_SELF\">\n";

while($row = mysql_fetch_array($result)) {
$id = $row["id"];
$ou2 = $row["ou"];
$req_action = $row["action"];
$givenname = $row["givenname"];
$sn = $row["sn"];
$title = $row["title"];
$request_dt = $row["request_dt"];

print "<tr><td>$id</td><td>$ou2</td><td>$sn, $givenname</td><td>$title</td><td>$req_action</td><td>$request_dt</td><td><input type=checkbox name=req_id$id></td></tr>\n";

}
echo "<input type=submit name=submit value=\"Process Checked\">\n";
echo "</form>\n";
echo "</table>\n";

if ($submit == "Process Checked") {
while(list($key,$value)=each($HTTP_POST_VARS)) {
if ($value == "on") {
$req_id = substr($key,6);
print "id=$req_id<br>\n";
}
}
}

?>

Sorry, under a seriously irrational deadline, can't explain it all. Hope it makes sense, seems to work fine. Thanks for the help!

-Ray