PHP/MYSQL - Insert into ignore, and ignore a specified column

Question

I need to be able to only insert a row if the data doesn't already exist, except for the date column, which would always be different, so it will always insert a new row even though it shouldn't.

my code:

$postID = $_POST['postID']; //example, 817
$userID = logged_in(); //example, 2
$date = time();

mysql_query("INSERT IGNORE INTO likes SET userID='$userID', postID='$postID', date='$date'");

I would like to be able to do something like:

mysql_query("INSERT IGNORE date INTO likes SET userID='$userID', postID='$postID', date='$date'");

Ja͢ck · Accepted Answer · 2012-08-15 04:30:58Z

3

If you have a UNIQUE constraint on userID and postID you can do whatever you're doing now, the date column would not get updated if there's already a record.

If you want to have the date column updated if the record does exist (for that particular user and post) you can use ON DUPLICATE KEY UPDATE date = '$date'.

answered Aug 15, 2012 at 4:30

Ja͢ck

174k39 gold badges269 silver badges317 bronze badges

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

2 Comments

Ja͢ck Over a year ago

I would suggest you check the docs and also make sure you don't already have existing indexes, but this should do it: ALTER TABLE LIKES ADD UNIQUE(userID, postID);

Dylan Cross Over a year ago

Ohh, now I understand what you meant by the unique constraints, I never even thought about doing it this way, thanks. I'll have to be using this more often.

Collectives™ on Stack Overflow

PHP/MYSQL - Insert into ignore, and ignore a specified column

1 Answer 1

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related