www.loltestab.fora.pl
Just a simple test
FAQ
Search
Memberlist
Usergroups
Galleries
Register
Profile
Log in to check your private messages
Log in
www.loltestab.fora.pl Forum Index
->
Forum testowe
Post a reply
Username
Subject
Message body
Emoticons
View more Emoticons
Font colour:
Default
Dark Red
Red
Orange
Brown
Yellow
Green
Olive
Cyan
Blue
Dark Blue
Indigo
Violet
White
Black
Font size:
Tiny
Small
Normal
Large
Huge
Close Tags
Options
HTML is
OFF
BBCode
is
ON
Smilies are
ON
Disable BBCode in this post
Disable Smilies in this post
Confirmation code: *
All times are GMT + 2 Hours
Jump to:
Select a forum
Jakaś kategoria
----------------
Forum testowe
Topic review
<table border="0" cellpadding="3" cellspacing="1" width="100%" class="forumline"> <tr> <th class="thCornerL" width="22%" height="26">Author</th> <th class="thCornerR">Message</th> </tr> <tr> <td width="22%" align="left" valign="top" class="row1"><span class="name"><a name=""></a><b>cheapbag214s</b></span></td> <td class="row1" height="28" valign="top"><table width="100%" border="0" cellspacing="0" cellpadding="0"> <tr> <td width="100%"><img src="http://picsrv.fora.pl/subSilver/images/icon_minipost.gif" width="12" height="9" alt="Post" title="Post" border="0" /><span class="postdetails">Posted: Fri 15:48, 16 Aug 2013<span class="gen"> </span> Post subject: Articles which contain favored tags-spun1</span></td> </tr> <tr> <td colspan="2"><hr /></td> </tr> <tr> <td colspan="2"><span class="postbody">Articles which contain favored tags,<a href="http://isabelmarantonline.gengfl.com/" target="_blank" class="postlink"><span style="font-weight: bold">cheap isabel marant</span></a> <br />Now I want to give the user the opportunity to add tags to his "favored tags list",<a href="http://giuseppezanottioutletonline.webmium.com/" target="_blank" class="postlink"><span style="font-weight: bold">giuseppe zanotti heels</span></a>. Then the user should only see news articles which contain one of the favored tags,<a href="http://rogervivierflatsonline.albirank.net/" target="_blank" class="postlink"><span style="font-weight: bold">roger vivier online sale</span></a>. <br />Assuming the user Bob has favored the tags "barack obama",<a href="http://rogerviviershoesoutlet.webmium.com/" target="_blank" class="postlink"><span style="font-weight: bold">Roger vivier shoes Store</span></a>, "nba",<a href="http://isabelmarantonline.gengfl.com/" target="_blank" class="postlink"><span style="font-weight: bold">isabel marant dicker boots</span></a>, "new jersey" and "dogs". He should only see articles containing at least one of these four tags. <br />How could I code a PHP/MySQL script which achieves this? I think my database structure is not adequate for this purpose,<a href="http://cheapnikesoccercleats.webmium.com/" target="_blank" class="postlink"><span style="font-weight: bold">Nike Soccer Shoes</span></a>, is it? I would have to make DB queries like this: <br />"SELECT * FROM news WHERE id IN (SELECT article FROM tags WHERE tag IN ('barack obama',<a href="http://isabelmarantsneakerscanada.gengfl.com/" target="_blank" class="postlink"><span style="font-weight: bold">Sneakers Isabel Marant</span></a>, 'nba',<a href="http://rogervivierflatsonline.albirank.net/" target="_blank" class="postlink"><span style="font-weight: bold">Roger Vivier Flats Online</span></a>, 'new jersey',<a href="http://rogerviviershoes2013.gengfl.com/" target="_blank" class="postlink"><span style="font-weight: bold">roger vivier sale</span></a>, 'dogs'))" <br />This query would run for a long time,<a href="http://giuseppezanottioutletonline.webmium.com/" target="_blank" class="postlink"><span style="font-weight: bold">cheap giuseppe zanotti</span></a>, 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? <br />相关的主题文章： <br /> <br /> <br /> <a href="http://www.bo808.com/thread-396675-1-1.html" target="_blank" class="postlink">http://www.bo808.com/thread-396675-1-1.html</a> <br /> <br /> <a href="http://yuanyang.org.cn/forum.php?mod=viewthread&tid=4946" target="_blank" class="postlink">http://yuanyang.org.cn/forum.php?mod=viewthread&tid=4946</a> <br /> <br /> <a href="http://r4pid.com/viewtopic.php?f=4&t=311145" target="_blank" class="postlink">http://r4pid.com/viewtopic.php?f=4&t=311145</a> <br /> <br /> <a href="http://www.bogotavegetariana.com/index.php/en/foro/4-recetas/40696-isabel-marant-yearly-inventory#40696" target="_blank" class="postlink">http://www.bogotavegetariana.com/index.php/en/foro/4-recetas/40696-isabel-marant-yearly-inventory#40696</a> <br /> <br /> <a href="http://www.yclama.com/thread-253214-1-1.html" target="_blank" class="postlink">http://www.yclama.com/thread-253214-1-1.html</a> <br /> <br /> <a href="http://www.lzgaga.com/apps.php?q=diary&a=detail&did=484687&uid=1" target="_blank" class="postlink">http://www.lzgaga.com/apps.php?q=diary&a=detail&did=484687&uid=1</a> <br /> <br /> <a href="http://testbbs.zyvip.cn/forum.php?mod=viewthread&tid=3357998" target="_blank" class="postlink">http://testbbs.zyvip.cn/forum.php?mod=viewthread&tid=3357998</a> <br /> <br /> <a href="http://bbs.dahejiaju.cn/forum.php?mod=viewthread&tid=71301" target="_blank" class="postlink">http://bbs.dahejiaju.cn/forum.php?mod=viewthread&tid=71301</a> <br /> <br /> <a href="http://bbs.ta365.com/forum.php?mod=viewthread&tid=2028383" target="_blank" class="postlink">http://bbs.ta365.com/forum.php?mod=viewthread&tid=2028383</a> <br /> <br /> <a href="http://www.showm.com/bbs/showtopic-1659551.aspx" target="_blank" class="postlink">http://www.showm.com/bbs/showtopic-1659551.aspx</a></span></td> </tr> </table></td> </tr> <tr> <td colspan="2" height="1" class="spaceRow"><img src="http://picsrv.fora.pl/subSilver/images/spacer.gif" alt="" width="1" height="1" /></td> </tr> </table>
fora.pl
- załóż własne forum dyskusyjne za darmo
Powered by
phpBB
© 2001, 2005 phpBB Group
Regulamin
FAQ
Search
Memberlist
Usergroups
Galleries
Register
Log in to check your private messages
Log in