multiple unique row updates in one step?

[lamerNooB]

I have a <table> that gets drawn dynamically according to how many rows are in my database.

Here's my question..
Is it possible to turn my table into a <form> with checkboxes to select which rows are to be updated and multiple text inputs to enter unique information for each field in each row?
In one step?

My database contains sports players, and information about them like points, games played, games missed, goals, assists, etc..

Thanks for your help

Jesse

[Elena_Mitovska]

When you dynamically form the table with results , add checkbox in the beginning of every row:
<form>
$ROWS - number of rows fetched by query
for ($i=0; $i<=$ROWS-1; $i++) {
echo "<input type='checkbox' name='che[]' value='".$result['id']."'>.....the rest of data.....<input type='text' name='update_input[]' value='' ";
}
</form>

So you add checkbox and input in every row.

In file where you submit the form:

if (count($POST['che'])>0) {
for ($j=0; $j<count($POST['che']); $j++) {
if (!empty($POST['update_input'][$j])

$SQL=" Update my table SET my_field=$POST['update_input'][$j] where id=$_POST['che'][$j]";
}
}

 }
 return;

[lamerNooB]

Thanks a billion Elena :-)
I'll update my script accordingly and let you know how it worked for me

[lamerNooB]

still having problems....
maybe i just buggered something up but it keeps barfing on the
$SQL line

unexpected T_VARIABLE