Het is de bedoeling dat de laatste topic uit het forum in de homepage komt. De script die ik gemaakt het ziet er als volgt uit
Maar het probleem is dat ik geen topics zie
Weten jullie misschien waar het aan kan liggen?
PHP:
1
| <? /***************************************************************************** ------------------- * * | test.php | * * ------------------- * * ******************************************************************************/ ?> <html> <head> <title>Resultaten van alle topics!</title> </head> <body bgcolor="#336699"> <center> <table borderColor="#08315a" cellSpacing="0" width="752" bgColor="#7394b5" border="1"> <tr> <td> <p style="MARGIN-TOP: 0px; MARGIN-BOTTOM: 0px; WORD-SPACING: 0px" align="center"><font face="Verdana" size="2" color="#FFFFFF">HIER VIND JE DE RESULTATEN</font></p> </td> </tr> </table> </center> <br> <?php $ServerPath = "config.php"; $ServerURL = "http://instructor/vbb224/upload"; require($ServerPath); $db = @mysql_connect("$dbhost", "$dbuser", "$dbpasswd") or die("here we die at connection"); @mysql_select_db("$dbname",$db) or die("here we die"); $query = "select Thread.ThreadID, Thread.Title, Post.UserName from Post leftjoin Thread on (Thread.ThreadID = Post.ThreadID) where Thread.ForumID in (2,36, 37) order by Post.dateline desc limit 0, 10";$result = mysql_query($query) or die("Query failed");$forum = "<ul>";while ($line = mysql_fetch_array($result, MYSQL_ASSOC)) { $username = $line['UserName']; $thread = $line['ThreadID']; $address = "/vbb224/upload/showthread.php?s=&threadid=$thread"; $text = $line['Title']; $text = "<a href=\"$address\">$username: $text</a>"; $forum .= "<li>$text</li>";}$forum .= "</ul>";unset($line);?> <?phpecho "<center><table width=\"752\" border=\"2\" bordercolor=\"08315a\" bgcolor=\"#7394B5\" cellspacing=30>"; echo "<tr><td><p style=\"word-spacing: 0; margin-top: 0; margin-bottom: 0\"> <font face=\"Verdana\" size=\"2\"><a href=\"$ServerURL/showthread.php?s=&threadid=$thread" target="_blank\">$k</a></p></td></tr> "; echo "</font></table></center>" ?><br> <center> <table borderColor="#08315a" cellSpacing="0" width="752" bgColor="#7394b5" border="1"> <tr> <td> <p style="MARGIN-TOP: 0px; MARGIN-BOTTOM: 0px; WORD-SPACING: 0px" align="center"><font face="Verdana" size="2" color="#FFFFFF">Script made by -=real-one=-</font></p> </td> </tr> </table> </center> </body> </html>?> |
Maar het probleem is dat ik geen topics zie
Weten jullie misschien waar het aan kan liggen?
De enige echte....
/u/22486/jasonbrooks2.png?f=community)
:strip_exif()/u/49790/dance.gif?f=community)
