Hello and welcome to our community! Is this your first visit?
Register
Enjoy an ad free experience by logging in. Not a member yet? Register.
Results 1 to 1 of 1
  1. #1
    New to the CF scene
    Join Date
    Jan 2012
    Location
    United States
    Posts
    4
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Smile Adding a tagging feature to blog

    Greetings,

    I've been trying to figure out how to implement a simple tagging feature to my blog script, but for the life of me, I can not figure it out!

    I understand how to actually add the tags to the database and each entry, but not how to retrieve them.

    For now, all I've formulated is this:

    1. Create a table called blog_tags add a tag_id field, tag_blog_id field and tag_name field.
    2. The tag_blog_id field will hold a blog ID - each tag a blog is given will have one entry in blog_tags: so, if an entry has 3 tags, it will have 3 entries in the blog_tags table
    3. Get a list of matching blog entries using a JOIN statement, joining blog_entries table and blog_tags table


    So, to make a long story short, I need help with the JOIN statement...any suggestions?

    Sorry if this post is a bit confusing, I've tried to explain it the best that I could

    Edit: I've seemed to have found a good solution, problem resolved!
    Last edited by createdigital; 01-02-2012 at 06:52 PM. Reason: Resolved


 

Tags for this Thread

Posting Permissions

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