I am not sure I understand what are you trying to achieve, why would you need a table with tag, user id and post id?
For typical tag cloud implementation, I assume that you would have tags, users and posts, each user has set tags associated with it and each post has (different) set of tags for it. Right? In this case, your database will be something like that "tags" table, with "id" and "tag" "users" table, with "id" and all the other information you want to save for the user "posts" table, with "id" and all post related information Now, you have 2 tables for the relationship between tags, users and posts. "tags_users" HABTM table, with "tag_id" and "user_id" "posts_tags" HABTM table, with "post_id" and "tag_id" - barduck On Mar 22, 11:42 am, "feelexit" <[EMAIL PROTECTED]> wrote: > I just start a simple web application. Need to make tag clouds for it, > so it will look more like web 2.0 > > here's the problem, I have this table called "tags". > > tags has id, tag, users_id, posts_id, I dont want to have id to be my > primary key, I only want 3 columns, tag, users_id, posts_id, and I > want all these 3 columns to form my primary key. > > but based on wht I learned, I need to follow Cake's database naming > conventions, and I have to have "id" in the table, is there a way to > get rid of this "id" column? > > by the way, where is Cake's database naming conventions, I found linke > to Cake's naming conventions, but theres nothing about "database name > convention". --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "Cake PHP" group. To post to this group, send email to cake-php@googlegroups.com To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/cake-php?hl=en -~----------~----~----~----~------~----~------~--~---
