php - How do I not show duplicate error when using mysqli -

i using code below input transactions database. each transaction has unique "id" associated it, in phpmyadmin, declared "id" field (actually called transaction_id in database) unique value, preventing duplicates. when download transaction data database, adds in new transactions.

this causes large amount of duplicate errors:

*error: insert transactions (id, transaction_id ... duplicate entry '#############' key 'transaction_id'* 

i'd show errors except duplicate error. there way add else if or else statement below?

if (mysqli_query($conn, $sql)) {     echo "new record created successfully"; } else {     echo "error: " . $sql . "<br>" . mysqli_error($conn); } 

thanks guys. here's came with:

if (mysqli_query($conn, $sql)) { echo "new record created successfully"; } else if(mysqli_errno($conn) !== 1062) { echo "error: " . $sql . "<br>" . mysqli_error($conn); }