I am working on a MySQL table which have a primary key on two fields. I would like to retrieve primary key error during an insertion with PHP. please help me...My php code does not show any error.. but it is not inserting the values in the table if it already contains those values..
mysql_query("insert into external values(1111,'xxx','yyy')");
for my table both first and second column together act as primary key.if my table already contains the entry like 1111 xxx zzz. this code will not insert these values. but there is no error msg too..
Thanks in advance!