rgb192
asked on
php pdo insert again if row columns are different
Some sort of id,
Timestamp
First name,
Last name,
Email
Weight
User may change any column
Want timestamp recorded if any column altered
User may change first
Timestamp
First name,
Last name,
Weight
User may change any column
Want timestamp recorded if any column altered
User may change first
ASKER
I literally want to 'insert again' if results are different
for example if user changes their weight (int) or email (varchar) then they get another row.
This is not an update.
for example if user changes their weight (int) or email (varchar) then they get another row.
This is not an update.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
This would insert into the needed first row every time.
Thanks for the points and thanks for using EE, ~Ray
It follows that if you create an UPDATE query that tries to UPDATE a row with column "weight" = 150 and the row already had column "weight" = 150, no update will occur. I have never tested this, but I expect that you could experiment with a DATETIME column to cause an update to occur every time. Just a thought, ~Ray