Marcel dank je wel voor de script....
Ik heb het script nou verwerkt in een tabel maar hij laat de post niet zien..
dit is het php bestandje...:
PHP Code:
<?php
/****************************************************************************
* ------------------- *
* | 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 left
join 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);
?>
<?php
echo "<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>
Zie je hier misschien een fout zodat die het niet doet?
En moet ik trouwens ook een nieuwe table maken voor deze script...??
Bookmarks