mySQL Insert only when field is different

Question

I am using the following sql statement:

$sql = "INSERT INTO counter (uid, placeid, lastdate) VALUES
('" . $uid . "', '" . $place->place->id . "', '" . $added . "') 
ON duplicate KEY UPDATE count = count + 1`";

This keep tracks of how many times people check in. I do not want multiple check ins a day, so when if someone checks in twice a day we do not record it.

If $added = lastdate, I do not want to update the count.

Can this be done with a sql statement?

Mark Byers · Accepted Answer · 2010-10-04 23:37:32Z

1

This should work:

"INSERT INTO counter (uid, placeid, lastdate) VALUES
('" . $uid . "', '" . $place->place->id . "', '" . $added . "') 
ON duplicate KEY UPDATE count = count + ('" . $added . "' <> lastdate)"

answered Oct 4, 2010 at 23:37

Mark Byers

844k202 gold badges1.6k silver badges1.5k bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

John Over a year ago

no, that does not work. Maybe my variable name made it a little confusing. $added = the date of the check in. The count is getting incremented by one. So if $added = the value of lastdate then count is not incremented by one

Collectives™ on Stack Overflow

mySQL Insert only when field is different

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related