I had a transaction script that "was" working fine. Now I think it maybe due to a "duplicate key error". At least that is the error being printed out.
Here is the table "Profiles_Skicerts"[innodb]: P_ID - PK, Normal Index (int) Skicert - PK, Normal Index (varchar) N_Year - int, allow null L_Used - int, allow null Here is the printout of insert statement from echo: INSERT INTO Profiles_Skicerts (P_ID, SkiCert, N_Year, Lused) VALUES (14, 'one', 2,4) INSERT INTO Profiles_Skicerts (P_ID, SkiCert, N_Year, L_used) VALUES (14, 'two', 1,4) INSERT INTO Profiles_Skicerts (P_ID, SkiCert, N_Year, _used) VALUES (14, 'three', 7,6) INSERT INTO Profiles_Skicerts (P_ID, SkilCert, N_Year, L_used) VALUES (14, 'four', 5,4) INSERT INTO Profiles_Skicerts (P_ID, SkilCert, N_Year, L_used) VALUES (14, 'five', 7,5)1062 : Duplicate entry '14-five' for key 1 THe P_ID is non auto inc and is being passed over via mysql_insert_id() I don't understand where my mistake could be. Thank you . Stuart -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
