Do this: First page... $sql = "UPDATE agreement SET Field1 = Value1, Field2 = Value2, ... Field10 = Value10 WHERE ID = IDValue"; Second page... $sql = "UPDATE agreement SET Field11 = Value11, Field12 = Value12, ... Field15 = Value15 WHERE ID = IDValue"; You will need to pass the value for the primary key from one page to the next. Another option... Instead of writing the first query to the db, save it in an array and store it as a session variable. Then, complete the session variable (array) on the second page, and write all of the fields to the db at once. Then, destroy the session variable. This will keep the record from being half-completed if the browser is closed for some reason, or other problem occurs. On Thu, Feb 26, 2009 at 2:54 PM, Joe Forsythe <jforsythe@xxxxxxxxxxxxxxxxxx>wrote: > You are still doing an update. You are just updating the last 5 > fields in the table with the new information. > -- > Joe > > > On Feb 26, 2009, at 2:46 PM, arvindsri123 wrote: > > > Hi All, > > > > I have a new problem now, > > > > I have a table(agreement) with 15 fields/column, and i have 2 page, on > > first page there is 10 forms fields, and on 2nd page 5 forms fields. > > > > when user(arvind) will come on first page, will fill all the 10fields > > and will click submit button, all the 10 fields info will store in > > table, and the user(arvind) will reach on 2nd page and here he will > > again fill all the 5 fields and will click submit. > > > > how i can do that ? I know normal update query which does update > > existing data, but here case is differ, i don't need to update > > existing data, i need to add rest 5 fields to fill by new data. > > > > I hope all of u wil understand my probs, i tried to explain as much as > > i can. > > > > waiting for help. > > > > Thanks, > > Arvind > > [Non-text portions of this message have been removed] > > > [Non-text portions of this message have been removed]
