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@xxxxxxxxx>
To: php-objects@xxxxxxxxxxxxxxx
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]
