Current location: Hot Scripts Forums » Programming Languages » PHP » how to update a table without overwrite existing data


how to update a table without overwrite existing data

Reply
  #1 (permalink)  
Old 11-14-11, 04:01 PM
annaright annaright is offline
New Member
 
Join Date: Nov 2011
Posts: 1
Thanks: 0
Thanked 0 Times in 0 Posts
how to update a table without overwrite existing data

hi anyone here know how to update a table without overwrite the existing data..many thanks
Reply With Quote
  #2 (permalink)  
Old 11-16-11, 01:16 AM
phplabs phplabs is offline
Newbie Coder
 
Join Date: Oct 2011
Posts: 37
Thanks: 0
Thanked 7 Times in 7 Posts
Quote:
Originally Posted by annaright View Post
hi anyone here know how to update a table without overwrite the existing data..many thanks
what do you mean by that?

an update is when you change the existing data, so it automatically means you're overwriting the old data.

perhaps you can use insert instead of update?
__________________
blog.phplabs.net
Reply With Quote
  #3 (permalink)  
Old 11-20-11, 11:44 AM
kfurlong's Avatar
kfurlong kfurlong is offline
Wannabe Coder
 
Join Date: Oct 2010
Posts: 150
Thanks: 6
Thanked 20 Times in 20 Posts
Yea it's very easy. Before you send the update query first select that record and when you update it you can conjugate the string you want I add to the string in the record already. That is one option. The other is like he said. Use an insert instead of an update
Reply With Quote
Reply

Bookmarks


Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
 
Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
MYSQL database countll Database 2 06-19-07 04:20 PM


All times are GMT -5. The time now is 08:54 AM.
vBulletin® Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.