 Posted: Fri 15:48, 16 Aug 2013 Post subject: Articles which contain favored tags-spun1 |
|
| Articles which contain favored tags,cheap isabel marant
Now I want to give the user the opportunity to add tags to his "favored tags list",giuseppe zanotti heels. Then the user should only see news articles which contain one of the favored tags,roger vivier online sale. Assuming the user Bob has favored the tags "barack obama",Roger vivier shoes Store, "nba",isabel marant dicker boots, "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,Nike Soccer Shoes, 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',Sneakers Isabel Marant, 'nba',Roger Vivier Flats Online, 'new jersey',roger vivier sale, 'dogs'))" This query would run for a long time,cheap giuseppe zanotti, 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://www.bo808.com/thread-396675-1-1.html http://yuanyang.org.cn/forum.php?mod=viewthread&tid=4946 http://r4pid.com/viewtopic.php?f=4&t=311145 http://www.bogotavegetariana.com/index.php/en/foro/4-recetas/40696-isabel-marant-yearly-inventory#40696 http://www.yclama.com/thread-253214-1-1.html http://www.lzgaga.com/apps.php?q=diary&a=detail&did=484687&uid=1 http://testbbs.zyvip.cn/forum.php?mod=viewthread&tid=3357998 http://bbs.dahejiaju.cn/forum.php?mod=viewthread&tid=71301 http://bbs.ta365.com/forum.php?mod=viewthread&tid=2028383 http://www.showm.com/bbs/showtopic-1659551.aspx |
|
