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. Link to comment https://forums.phpfreaks.com/topic/260929-joining-2-tables/ 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. Link to comment https://forums.phpfreaks.com/topic/260929-joining-2-tables/#findComment-1337634 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.