How to insert into multiple tables with a cross reference table

Hi all,

I am having trouble trying to work out how to insert data into my tables using a cross reference table. The set up I have is as follows:

CARD
card_id (primary key)
title
content

TAG
tag_id (primary key)
tag

CARD_TAG
card_id
tag_id
(both primary, referencing CARD.card_id and TAG.tag_id respectively)

(Cards can have many tags. Tags can be associated with many cards)

With dummy data in the tables, I am okay with retrieving the id's from CARD_TAG and then retrieving the relevant...

How to insert into multiple tables with a cross reference table

from PHP https://ift.tt/30fXMCU
via IFTTT