如果INSERT IGNORE回显“查询被忽略”？ （MySQL的/ PHP）

Question

I have a query like this:

$query="INSERT IGNORE INTO mytable (key, word1, word2) VALUES (1, 'abc', 'def')";

And I'd like to somehow "catch" if the query was ignored because the primary key already exists.

Is there any was to make an "if" statement so my program could notify the user that the query was ignored?

Answer 1

I solved it by using mysql_affected_rows to check if no rows were affected by the query.

    if($productquery&&mysql_affected_rows($conn)>0){

    echo "Success.";    
    echo mysql_affected_rows($conn); //returns 1

}else{

    echo "Some error." . mysql_error(). " ".mysql_affected_rows($conn); //returns 0 affected rows since it was ignored

}