Mutliple Check Boxes and Specific Forms

[Anon]

Hello-

I have done some searching around for this and have not been able to find a definite solution...

I am working on a system that will allow a person at work to make multiple entries on to multiple forms on a single page. This is going to part of an existing work order maintenance system where I work. The problem is this...

When a user comes to the search page and enters in a work order in the search field, it will then display a list of the parts used for that work order (This is all tied to a MySQL database). What I want the system to be able to do is allow the user to click on checkboxes next to parts that they wish to edit the information for. Once the check the boxes they will then be brought to a page displaying the edit forms for each part that they checkmarked (it should ONLY display forms for the boxes which they checkmarked).

Once the are done editing the information for each part, they should be able to hit a single submit button to update the information for each part in the database.

In otherwords:

PAGE - 1

Search = 333

PAGE - 2

Parts for Work Order 333

[] Part 1
[] Part 2
[] Part 3
[] Part 4
<User checkmarks Part 2 & Part 4>
-SUBMIT-

PAGE - 3

Information Forms for Select Parts

Part 2

| Part 2 Form |

Part 4

| Part 4 Form |

<User fills in info in forms>
-SUBMIT-
<MySQL records for Part 2 and Part 4 updated>

If anyone knows the methods necessary to complete such a process using multiple checkboxes to display mutliple forms on a single page, the information would be greatly appreciated!!!

Thank you for your time and Consideration,

Daniel J. Noah
[e-mail]

[Anon]

I apologize, I posted to the wrong forum earlier.

A Better description:

The basic purpose of what I am asking for is that people here I work said that they didn't like the current system which only allowed them to update one part at a time they wanted the ability to update several records at a time for a work order on a single page. They wanted to be able select only the parts they wanted to update for a specific work order and then have a page that displays an update form for each part selected. Once they have filled out all of the forms on that page, they want to only have to click "Submit" once to update all of the selected records.

If anyone has an example of something similar to this using session variables, variable variables, or whatever other method, it would be greatly appreciated!

Thanks again,

Daniel J. Noah

[matto]

my approach:

first show the parts in a list with checkboxes.

(this is pseudo-code)
$partlist = db_query("select * from parts");
foreach($partlist as $part)
{
echo "<input type=checkbox name=parts[".$parts[0]."] value=yes>";
// parts[0] is the part id
}

now, if parts[12] is checked, this means, the part with id 12 is selected for edit.

the user makes his selection.

the script that gets this data, reads in the parts again:

$partlist = db_query("select * from parts");

then, if one part has been selected before, its fields are shown so that the user can edit them:

foreach($partlist as $part)
{
if($parts($partlist[0]) == "yes")
... show edit inputs named: name[id of the part], price[id of the part] etc. the inputs contain the original value containing from the db
}

after submit, update these fields.