Insert Data From Another Table With Foreign Key?Mar 20, 2011
I have a problem inserting a data into another table that has foreign key using PHP. I have a table named CUSTOMER_INFORMATION with fields(customer_no(PK), first_name, last_name, etc..) and a CATERING_RESERVATION table with fields(catering_no(PK), type_of_event, number_of_persons, customer_no(FK), etc).. I wanted to insert the customer_no in the CATERING_RESERVATION table but I have this error:
"Cannot add or update a child row: a foreign key constraint fails (`thesis/catering_reservation`, CONSTRAINT `catering_reservation_ibfk_1` FOREIGN KEY (`customer_no`) REFERENCES `customer_information` (`customer_no`) ON DELETE CASCADE)"
But I think I lack some codes on this. I'm just a newbie in php.[code]...
I AM TRYING TO INSERT THE DATA AT THE SAME TIME..