freemancomputer Posted April 14, 2012 Share Posted April 14, 2012 I am working on a website that lists movies. On this I have user accounts. What I am trying to do is make it so a user can check off and rate the movies they have watched. Once the user checks a movie off I will have a list they can look at in there profile. My first thought was to add a column to the user table that will list the ID number of the movies from the move table along with there rating. I am not sure how to do something like this or if this is the best way. This is my first run at trying to get 2 different tables working together so Im not sure of the best starting point. Quote Link to comment Share on other sites More sharing options...
fenway Posted April 15, 2012 Share Posted April 15, 2012 You need a third table linking movieID to userID -- preferably with a timestamp, too. Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.