0

I have problem with proper error message (message when exists) in sql query which should insert records when not exist...

for example:

 INSERT INTO list (code, name, address,)
SELECT 'ABC', 'ABC name', 'Johannesburg'
FROM list
   WHERE NOT EXISTS(
   SELECT code, name, address
   FROM list
   WHERE code = 'ABC'
   AND name = 'ABC name'
   AND address = 'Johannesburg'
     )
LIMIT 1



if(mysqli_query($link, $sql)){

    echo "Records added successfully.";

} else{

    echo "ERROR: Could not able to execute $sql. " . mysqli_error($link);

}

is it possible to make extra error message which would tell if this record already exists?

thank you for any advices

luke9999
  • 151
  • 1
  • 3
  • 9

0 Answers0