when i execute a query like this:
“$to_copy = implode(’,’,[selected]);
$sql = “INSERT INTO Emp_Accommodate (EmployeeNo, NameAr, Room_IDF, House_IDF) SELECT EmployeeNo, NameAr, Room_IDF, House_IDF FROM Employee WHERE NameAr =’$to_copy’”;
sc_exec_sql($sql);
[selected] = array();
}”
It displays this error:" [Microsoft][ODBC Driver 11 for SQL Server][SQL Server]Cannot insert duplicate key row in object ‘dbo.Emp_Accommodate’ with unique index ‘IX_Emp_Accommodate’. The duplicate key value is (101137, ). SQLState: 01000 Error Code: 3621 Message: [Microsoft][ODBC Driver 11 for SQL Server][SQL Server]The statement has been terminated.
INSERT INTO Emp_Accommodate (EmployeeNo, NameAr, Room_IDF, House_IDF) SELECT EmployeeNo, NameAr, Room_IDF, House_IDF FROM Employee WHERE NameA …"
So, How can i display error message instead of the error shown above?