Re: Triggers on two tables to get Primary Keys (Auto Increment) into third linking table

[Vladimir Velan]

Thank you for your reply, What I have used is below:

mysqli_multi_query($con,"
START TRANSACTION;
INSERT INTO author(AuthorTitle, F_Name, L_Name, Email, Contact)
VALUES('$AuthorTitle','$F_Name','$L_Name','$Email','$Contactauthor');
SET @AuthorId = LAST_INSERT_ID();
INSERT INTO study(Title) VALUES('$Title');
SET @StudyId = LAST_INSERT_ID();
INSERT INTO casestudy (AuthorId, StudyId, Submitted)
VALUES(@AuthorId, @StudyId, NOW());
COMMIT;
");