| cheapbag214s |
 Wysłany: Nie 13:19, 01 Wrz 2013 Temat postu: Articles which contain favored tags-spun2 |
|
Articles which contain favored tags,Doudoune Duvetica Femme online
Now I want to give the user the opportunity to add tags to his "favored tags list",Doudoune Duvetica Femme. Then the user should only see news articles which contain one of the favored tags,Cheap Roger Vivier Shoes Sale Outlet Store.
Assuming the user Bob has favored the tags "barack obama",kevin durant shoes 5 for sale, "nba",http://giuseppezanottiweddingshoes.webmium.com/, "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,Parajumpers Parka Online Store, 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',Buy Roger Vivier Shoes In, 'nba',kevin durant shoes for sale, 'new jersey',giuseppe zanotti wedding shoes Shop, 'dogs'))"
This query would run for a long time,Cheap Roger Vivier Shoes, 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.tricklife.com/forum/showthread.php?p=11159181#post11159181
http://www.tidesoffortune.fora.pl/rady,18/google-doodle-balls-bounce-on-google-home-page-tod,6681.html#6773
http://www.museyon.com/forum/viewtopic.php?f=2&t=627666
http://www.ephedraonline.fora.pl/forum-testowe,1/for-all-the-worries-about-voting-problems-spun3,6840.html#6876
http://www.yalaweb.com/vb/showthread.php?p=63166#post63166
http://btpforum.com/showthread.php?p=23707#post23707
http://www.guardiansofgrail.fora.pl/suggestions,4/how-to-increase-your-sperm-count-spun2-spun1,9659.html#9837
http://www.macrobidcbnpd.fora.pl/musette-glided-very-naughty-laughter-away-wheels,1/almost-everyone-from-houston-may-well-put-together,5339.html#6113
http://forum.zeload.com/viewtopic.php?f=29&t=650152
http://forum.alislamweb.com/showthread.php?p=544740#post544740
http://www.hardpartyprodss.fora.pl/hard-party-production,3/carolina-panthers-football-jerseys-and-logos-1-sp,6407.html#6443
http://www.discountphentermineonline.fora.pl/forum-testowe,1/hats-with-headphones-spun1,8244.html#8310
http://www.ligahordy.fora.pl/informacje-information,5/los-angeles-church-history-end-prophecy-spun3-spun,5691.html#6363
http://www.rakenbymd.fora.pl/coke-from-waits-poker-onnie-mentioned-fantasy-casino-shoots-you-held-his-anything,1/cheap-discount-youth-nfl-jerseys-wholesale-jerseys,6140.html#6166
http://www.almarol.fora.pl/pzemytnicy,13/how-to-drink-the-right-amount-of-water-daily-spun4,5061.html#5697 |
|
