用子查询来实现推荐功能

$query1 = select disinct(b2.username)

                 from bookmark b1, bookmark b2

                 where b1.usernam = '$valid_user'

                 and b1.username != b2.username

                 and b1.bm_url = b2.bm_url

该查询将给出一个与当前用户意向相似的人的列表

$query2 =  select bm_url

                   from bookmark

                   where username in

                                                 ($query1)

假如用户已经有了该书签，就不要再推荐给他

and bm_url not in

                           (select bm_url from bookmark where username="$valid_user")

并且只推荐大众化的的标签，不推荐太个性化的标签

group by bm_url

having count(bm_url) > $popularity

 

评论

1 楼 8792321 2009-02-05  

[/color][color=indigo]