[Webinar] Streamline your web hosting managementRegister Today

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 182
  • Last Modified:

only insert if different than existing

users have a title and body in their social networking website

using php, pdo with mysql

if they change their title and/or body  then

columns id,profile_id, timestamp, title, body.  If body,title is different save a new title,body
0
rgb192
Asked:
rgb192
1 Solution
 
GaryCommented:
Just run a normal update.
If they changed it then it will be updated, if they didn't change it then it will be the same as before.
0
 
rgb192Author Commented:
not what I was thinking because I want historical values

but you answered the question I wrote: which was update

thanks
0

Featured Post

Hire Technology Freelancers with Gigs

Work with freelancers specializing in everything from database administration to programming, who have proven themselves as experts in their field. Hire the best, collaborate easily, pay securely, and get projects done right.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now