MySQL error!!!! please help

[j-dearden]

Hey all

i have a insert query that inserts a record into my database. however once the wuery has inserted i am prompted with the following message :-

Cannot add or update a child row: a foreign key constraint fails

however the record has been added. could some one plese help i am so confused.

regards

John

[cafrow]

Might help if you post the query.

[jasonahoule]

Kind of sounds like you are trying the insert twice.

[j-dearden]

Cheers for the replies but i have figured it out. The problem was i was trying to insert a value into the child table that didnt exist in the parent. simple but i can imagine common mistake.