Member Avatar for python08

Hi there,

I've been having some issues with MYSQL.

I have three tables,

Blog, which has the fields:

  • Id
  • Headline
  • Author
  • Articlebody

Tags, with the fields:

  • tagId
  • tagName

and Lastly, article_tags (which is the relation), with the fields:

  • tagId
  • blogId

My issue is, I'm trying to add some functionality on my website that will let you see a list of all articles that a certain tag relates to when you click on the tag, what would be the best way to implement this, I've been trying for hours by joining tables.

Thanks for the help.

  • 1 Contributor
  • 1 Reply
  • 65 Views
  • 6 Hours Discussion Span
  • Latest Post Latest Post by python08
Member Avatar for python08

Nevermind, sorted this out. Thanks anyway guys!

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.