ik krijg bij mijn forum steeds de volgende fout melding alleen ik kan de fout niet vinden: Forum HelpJePc.tk > testYou have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1
Hieronder staat ook forum.php dit is de pagina waarop die de fout weergeeft:
<?php
include ("config.php");
$cat = $_GET['cat'];
$forumid = $_GET['forumid'];
?>
<HTML>
<HEAD>
<TITLE><?php echo $forumname; ?></TITLE>
<LINK HREF="style.css" TYPE="text/css" REL="stylesheet">
</HEAD>
<BODY>
<?php
$query = mysql_query("SELECT naam FROM categories WHERE id=$cat") or die(mysql_error());
if(!mysql_num_rows($query)) {
echo "<CENTER>De geselecteerde categorie bestaat niet (meer).<BR>\n";
echo "<A HREF=\"categorieen.php\">Terug naar Categorieën</A><BR></CENTER>\n";
} else {
$naam = mysql_result($query, 0, "naam");
mysql_free_result($query);
echo "<A HREF=\"categorieen.php\">".$forumname."</A> > ";
echo "<A HREF=\"forum.php?cat=".$cat."\">".$naam."</A>";
$res = mysql_query("SELECT * FROM forum where id=$forumid") or die(mysql_error());
if(!mysql_num_rows($res)) {
echo "<CENTER>Het geselecteerde forumid bestaat niet (meer).<BR>\n";
echo "<A HREF=\"forum.php?cat=".$cat."\">Terug naar '".$naam."'</A><BR></CENTER>\n";
} else {
mysql_query("UPDATE forum SET hits=hits+1 where id=$forumid") or die(mysql_error());
if(mysql_num_rows($res)) {
$row = mysql_fetch_row($res);
echo " > <B>".$row[1]."</B><BR>\n";
?>
<BR>
<TABLE WIDTH="500" BORDER="1" CELLSPACING="0" CELLPADDING="2">
<TR>
<TD WIDTH="500">
<B>Onderwerp:</B> <?php echo $row[1]; ?><BR>
</TD>
</TR>
<TR>
<TD WIDTH="500">
<B>Gepost door:</B> <?php echo "<A HREF=\"mailto:".$row[5]."\">".$row[3]."</A>"; ?><BR>
<B>Gepost op:</B> <?php echo date("d/m/Y H:i", $row[4]); ?>
</TD>
</TR>
<TR>
<TD WIDTH="500">
<?php
echo nl2br($row[6]);
?>
</TD>
</TR>
</TABLE>
<br>
<?php
mysql_free_result($res);
$res2 = mysql_query("SELECT * FROM forumreplys where forumid=$forumid") or die(mysql_error());
if (mysql_num_rows($res2)) {
while($row = mysql_fetch_row($res2)) {
?>
<TABLE WIDTH="500" BORDER="1" CELLSPACING="0" CELLPADDING="2">
<TR>
<TD WIDTH="500">
<B>Reply:</B> <?php echo $row[2]; ?><BR>
</TD>
</TR>
<TR>
<TD WIDTH="500">
<B>Gepost door:</B> <?php echo "<A HREF=\"mailto: ".$row[4]."\">".$row[3]."</A>"; ?><BR>
<B>Gepost op:</B> <?php echo date("d/m/Y H:i", $row[5]); ?><BR>
</TD>
</TR>
<TR>
<TD WIDTH="500">
<?php
echo nl2br($row[6]);
?>
</TD>
</TR>
</TABLE>
<BR>
<?php
} // end while
mysql_free_result($res2);
} // end $aantal > 0
} // end message exists
?>
<BR>
<TABLE WIDTH="500" BORDER="1" CELLSPACING="0" CELLPADDING="2">
<TR>
<TD WIDTH="500" ALIGN="center">
<A HREF="postreactie.php?cat=<?php echo $cat."&forumid=".$forumid; ?>">Post Reactie</A> |
<A HREF="nieuwbericht.php?cat=<?php echo $cat; ?>">Nieuw Topic</A> |
<A HREF="forum.php?cat=<?php echo $cat; ?>">Terug naar '<?php echo $naam; ?>'</A><BR>
</TD>
</TR>
</TABLE>
<?php
} // end forumid exists check
} // end category exists check
?>
</BODY>
</HTML>
Kan iemand mij helpen??
Fout melding
246 views