'm basically trying to build an E-commerce application on MVC and I just want this feature of recommendation. I've registered users and want to recommend new products related to their previous purchased. I've their previous purchase records in database.
I've 5 tables
Products: PId, ProductName, Price, Quantity, CategoryId(fk) Category: CId, CategoryName Users: UserId, FName, LName, Email, Password, City Orders: OrderId, FullName, Address, City, Total, UserId(fk) OrderDetails: OdId, OrderId(fk), ProductId(fk)
I've some data in Orders and OrderDetails table of Customers who has made some purchasing.
Now I want, If the same user visits again I want to show him/her some products of same category that he/she has purchased.
Sorry for my english, I just need some Ideas or example. Do I have to do "join" between tables ?