MySQL Forums
Forum List  »  Newbie

Re: Amazon alike collaborative filtering
Posted by: Diego Medina
Date: November 10, 2007 02:50PM

Yes
here

select t2.product_id , t1.name from t2
join t2 as related_users
on
t2.product_id != related_users.product_id
 and
t2.user=related_users.user
join t1
on
t1.id=t2.product_id
 where related_users.product_id = 2

Diego Medina
Web Developer
http://www.fmpwizard.com

P.S. Please read this post if you are going to post code

Options: ReplyQuote


Subject
Written By
Posted
Re: Amazon alike collaborative filtering
November 10, 2007 02:50PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.