Let's say I had a database of different tv shows in a simple table. Users can come to the site and choose their three favorite shows, and these are stored in the database.
Now I want another user to come along and type in ONE of their favorite tv shows, and the database will return a list of other tv shows they might like, based on what other users have said.
I have managed to get up to the point where the database searches for the one show, and returns the other two matches for each user. Is it possible to get mysql/php to combine the returned shows that are the same, and generate a list with the most likely match at the top?
