• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 183
  • 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
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Free Tool: SSL Checker

Scans your site and returns information about your SSL implementation and certificate. Helpful for debugging and validating your SSL configuration.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

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