 Wysłany: Nie 20:28, 01 Wrz 2013 Temat postu: Articles which contain favored tags-spun2 |
|
| Articles which contain favored tags,duvetica jackets canada outlet shop
Now I want to give the user the opportunity to add tags to his "favored tags list",Woolrich Up to 70% Off Overstock Woolrich Women's Apparel. Then the user should only see news articles which contain one of the favored tags,parajumpers sale free shipping. Assuming the user Bob has favored the tags "barack obama",roger vivier shoes for sale, "nba",cheap adidas soccer cleats, "new jersey" and "dogs". He should only see articles containing at least one of these four tags. How could I code a PHP/MySQL script which achieves this? I think my database structure is not adequate for this purpose,giuseppe zanotti outlet online Sale, is it? I would have to make DB queries like this: "SELECT * FROM news WHERE id IN (SELECT article FROM tags WHERE tag IN ('barack obama',http://duveticaouterwear.blogspot.com/, 'nba',parajumpers jacket sale, 'new jersey',youth soccer cleats store, 'dogs'))" This query would run for a long time,kevin durant shoes online store, wouldn't it? There must be a database structure which is more appropriate than mine. Do you have an idea for this problem? Which DB structure do I need and what queries must I use then? 相关的主题文章： http://mc.xhiber-dynamic.com/forum/index.php?topic=188863.msg188877#msg188877 http://jztianxia.com/forum.php?mod=viewthread&tid=7154 http://dcatlt.com/qq/forum.php?mod=viewthread&tid=953282 http://www.nongxiaotushu.com/thread-287299-1-1.html http://cnmanguo.com/home.php?mod=space&uid=2845&do=blog&id=24844 http://georgiebones.com/node/1148274 http://img.kuqito.com/forum.php?mod=viewthread&tid=7550188 http://21auto.com.cn/bbs/ http://fevershot.net/forum_X15_Running/forum.php?mod=viewthread&tid=98086&extra= http://huyou.haochake.com/home/space.php?uid=52291&do=blog&id=341473 |
|
