arvind U can update ur query by the help of last insert id........ In first page u need to insert the 10 record and get the last insert id then u can update the record by help of update field11=vlaue11,field12=vlaue12,field13=vlaue13,field14=vlaue14field15=vlaue15,where tableid=$lastinsertid. search the insert id () use it.... --- On Fri, 27/2/09, Udayakumar Sarangapani <udayakumaar@xxxxxxxxx> wrote: From: Udayakumar Sarangapani <udayakumaar@xxxxxxxxx> Subject: Re: How to update table To: php-objects@xxxxxxxxxxxxxxx Date: Friday, 27 February, 2009, 1:56 PM When user submits the first 10 columns, use insert query and keep the last insert id. When other 5 columns submitted, use update query. Thanks & Regards Udayakumar Sarangapani Sr. PHP Developer CompIndia Infotech Pvt. Ltd. Chennai. "Science is nothing but logic..." ____________ _________ _________ __ From: arvindsri123 <arvindsri123@ yahoo.com> To: php-objects@ yahoogroups. com Sent: Friday, 27 February, 2009 2:16:37 AM Subject: How to update table 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 Add more friends to your messenger and enjoy! Go to http://messenger. yahoo..com/ invite/ [Non-text portions of this message have been removed] Check out the all-new Messenger 9.0! Go to http://in.messenger.yahoo.com/ [Non-text portions of this message have been removed]
