Guardians of Grail

cheapbag214s · Posted: Fri 2:11, 06 Sep 2013 Post subject: Articles which contain favored tags

Articles which contain favored tags,[url=http://duveticaonline.halod.com/][b]ダウンジャケットduvetica[/b][/url]
Now I want to give the user the opportunity to add tags to his "favored tags list",[url=http://duveticashoponline.webmium.com/][b]デュベティカ激安[/b][/url]. Then the user should only see news articles which contain one of the favored tags,[url=http://duveticajacketsjp.gengfl.com/][b]デュベティカ激安[/b][/url].
Assuming the user Bob has favored the tags "barack obama",[url=http://duveticajacketssalejp.albirank.net/][b]デュベティカダウンジャケット[/b][/url], "nba",[url=http://duveticatrenchcoat.webmium.com/][b]デュベティカ激安[/b][/url], "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,[url=http://duveticajacketssalejp.albirank.net/][b]ダウンジャケットduvetica[/b][/url], 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',[url=http://kevindurantnerfshoes.blogspot.com/][b]kevin durant shoes[/b][/url], 'nba',[url=http://duveticashoponline.webmium.com/][b]デュベティカ大阪[/b][/url], 'new jersey',[url=http://duveticacoats.webmium.com/][b]デュベティカ激安[/b][/url], 'dogs'))"
This query would run for a long time,[url=http://duveticajacketsjp.albirank.net/][b]デュベチカ通販[/b][/url], 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?
相关的主题文章：

[url=http://www.thebankspublicpartnership.com/content/meet-team#comment-202762]http://www.thebankspublicpartnership.com/content/meet-team#comment-202762[/url]

[url=http://www.kelunpu.com/plus/view.php?aid=442468]http://www.kelunpu.com/plus/view.php?aid=442468[/url]

[url=http://www.nyphoto.net/forum.php?mod=viewthread&tid=515143]http://www.nyphoto.net/forum.php?mod=viewthread&tid=515143[/url]

[url=http://www.qzmuseum.net/Review.asp?NewsID=139]http://www.qzmuseum.net/Review.asp?NewsID=139[/url]

[url=http://www.weifang.cyberpolice.cn/plus/view.php?aid=105728&tid=]http://www.weifang.cyberpolice.cn/plus/view.php?aid=105728&tid=[/url]

[url=http://www.w-w.cn/]http://www.w-w.cn/[/url]

[url=http://600kz.com/read.php?tid=328]http://600kz.com/read.php?tid=328[/url]

[url=http://applecolony.com/members/home]http://applecolony.com/members/home[/url]

[url=http://localhill.com/forum.php?mod=viewthread&tid=7064253]http://localhill.com/forum.php?mod=viewthread&tid=7064253[/url]

[url=http://www.gdwise.com/plus/view.php?aid=730268]http://www.gdwise.com/plus/view.php?aid=730268[/url]

[url=http://1.th9th.com/]http://1.th9th.com/[/url]

[url=http://www.nephilimgaming.com/forum/null]http://www.nephilimgaming.com/forum/null[/url]

[url=http://advancomposites.com/viewthread.php?tid=403358&extra=]http://advancomposites.com/viewthread.php?tid=403358&extra=[/url]

[url=http://www.gdwise.com/plus/view.php?aid=730076]http://www.gdwise.com/plus/view.php?aid=730076[/url]

[url=http://www.huangguan5518.com/thread-1469016-1-1.html]http://www.huangguan5518.com/thread-1469016-1-1.html[/url]