MySQL question

Out of context: Reply #14

  • Started
  • Last post
  • 15 Responses
  • acescence0

    oh, i think i misunderstand how your tables are structured.

    seems to make more sense to have a global tags table, where each row is a unique tag, then posts and articles tables, then two tables that basically map a post or article id to a tag id.

    but maybe too late to go restructuring your whole db, ha.

    acescence 0Permalink
    UpvoteDownvote
    Flag
    • < Yes. You needs a link table if you want the potential to share tags.flavorful
    • 01. tag
      02. blog_post_Tag_Link
      03. articles_Tag_Link      flavorful
    • Where tag would hold all the unique tags available, and the link tables would be the match up for each table.flavorful
    • That can have tags.flavorful
    • thanks guys!cosmoo
    • No problemo homie! :D I've never used tags myself, but I've thought about them before in potential diagrams. No working example to share though.flavorful
    • example to share though. Good luck!flavorful
    Show [[ numHiddenNotes ]] more notesAdd Note
    SaveCancel

View thread