• 0 Vote(s) - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
Tables are Posts and Tags.

#1
Tables are Posts and Tags. 

One Post has Many Tags. And One Tag has Many Posts. A so-called 'Many-to-Many' relationship. 

This is solved with a intermediate table (post_tag) with id for post_id and tag_id and a created_at row. 

Now, How do you handle this in CodeIgniter? 

And before you answer. I also wish to learn how to handle updating records in intermediate table. 

As in, I remove a Post or I add a new Tag to a Post. 

Thanks, [Image: smile.gif]
Reply

#2
@michaleben123,

Can you setup an sqlfiddle ( http://sqlfiddle.com/ ) so that we can see all of the tables structure. This will help us help you.
Reply


Digg   Delicious   Reddit   Facebook   Twitter   StumbleUpon  


  Theme © 2014 iAndrew  
Powered By MyBB, © 2002-2020 MyBB Group.