Re: new to cake php, need help on tag clouds database design

2007-03-22 Thread barduck
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 i

Re: new to cake php, need help on tag clouds database design

2007-03-22 Thread Langdon Stevenson
Hi feelexit > 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,

new to cake php, need help on tag clouds database design

2007-03-22 Thread feelexit
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