update page not updating

Hi again.
I tried to get fancy and make a multiple page insert form. the problem is that it is not updating the fields that I added. basically I tore apart the insert page made by DA and put it on three pages. the second page shows the info from page 1, plus the new fields. page three show page 1 and two info, ad then adds the options for adding photos.

it's broken...the page 2 shows the info correctly form page 1, making me think it is seeing the correct record. but no luck in updating the record after page 1.

by the way, i may have monkeyed it up a bunch as i tried to fix it, but i am stuck. please help.

all form processing must occur on the forms action page.

you have the form on inventory_Insert_2.php set to post to inventory_Insert_3.php. this will bypass the update record behavior that you added to the inventory_Insert_2.php page.

I changed the <form action> to the inventory_Insert_2.php. Is this what you are referring to?

still no update of information.

1) edit the WADAInsertRecordID form element to capture the Inventory_ID query string variable that is passed over:

<input name="WADAInsertRecordID" type="hidden" id="WADAInsertRecordID" value="<?php echo(isset($_GET['Inventory_ID'])?$_GET['Inventory_ID']:""); ?>" />

2) In the update record behavior, do not bind the Inventory_ID column to a value. the primary key column should be given a value, it will get it's value from the database.

Just starting to learn PHP

I think the number of closing ) is wrong or I need another ( in the code you supplied. I don't know where it goes.

how about between the ? and the $_GET to read ?($_GET

thanks.

in your form, you have a hidden form element:

<input name="WADAInsertRecordID" type="hidden" id="WADAInsertRecordID" value="" />

find that element and edit it to:

<input name="WADAInsertRecordID" type="hidden" id="WADAInsertRecordID" value="<?php echo(isset($_GET['Inventory_ID'])?$_GET['Inventory_ID']:""); ?>" />

Just starting to learn PHP

I think the number of closing ) is wrong or I need another ( in the code you supplied. I don't know where it goes.

the page is now blank when it loads.

thanks.

looked like to many closing ). page loads now. but still no update happening. should the fields be bound to the recordset or the upload form?

they should be bound to the update form.

I think you may be making this more difficult on yourself than it needs to be.

Instead of inserting the form on the first page, then updating it on subsequent pages, you just do the insert once on the last page.

See the following post for details on creating a multi page form:
showthread.php?t=8911

It's like you have know me my whole life. I am always making it more difficult. Thanks for the link. I will check it out.

David