Massive Discounts - Ending Soon Limited Offer

Amazon Countdown Deals Closing Soon

Guaranteed Lifetime Commissions - Easy Sell and Unlimited

>
Results 1 to 2 of 2
  1. #1
    Join Date
    Oct 2012
    Posts
    1,341

    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

  2. #2

    nobita

    A very nice and meaningful forum, I really like your content. Thank you for sharing the information. Find out about me here: fireboy and watergirl

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

Ad Here