cheapbag214s
Kapitan jachtowy
Dołączył: 27 Cze 2013
Posty: 20086
Przeczytał: 0 tematów
Ostrzeżeń: 0/5
Skąd: England
|
 Wysłany: Nie 13:19, 01 Wrz 2013 Temat postu: Articles which contain favored tags-spun2 |
|
|
Articles which contain favored tags,[link widoczny dla zalogowanych]
Now I want to give the user the opportunity to add tags to his "favored tags list",[link widoczny dla zalogowanych]. Then the user should only see news articles which contain one of the favored tags,[link widoczny dla zalogowanych].
Assuming the user Bob has favored the tags "barack obama",[link widoczny dla zalogowanych], "nba",[link widoczny dla zalogowanych], "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,[link widoczny dla zalogowanych], 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',[link widoczny dla zalogowanych], 'nba',[link widoczny dla zalogowanych], 'new jersey',[link widoczny dla zalogowanych], 'dogs'))"
This query would run for a long time,[link widoczny dla zalogowanych], 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?
相关的主题文章：
[link widoczny dla zalogowanych]
http://www.tidesoffortune.fora.pl/rady,18/google-doodle-balls-bounce-on-google-home-page-tod,6681.html#6773
[link widoczny dla zalogowanych]
http://www.ephedraonline.fora.pl/forum-testowe,1/for-all-the-worries-about-voting-problems-spun3,6840.html#6876
[link widoczny dla zalogowanych]
[link widoczny dla zalogowanych]
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
[link widoczny dla zalogowanych]
[link widoczny dla zalogowanych]
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
Post został pochwalony 0 razy
|
|
FAQ
Szukaj
Użytkownicy
Grupy
Galerie
Rejestracja
Zaloguj się, by sprawdzić wiadomości
Zaloguj
