Problem med news script.
Yo eksperter... :)Jeg har et problem med mit nyhed script... det virker 99% men mangler man kan oprette nyheder osv osv osv men når vi kommer til comment delen, som faktisk også virker... er det så at jeg vil have sådan at den skriver fx Comment #1 osv osv osv... men nu skriver den Comment #"det antal comments der er lavet ialt, til ALLE nyheder... håber i vil kigge på det... :)
_____________________
SQL DB
_____________________
#Denne hvor news skrives i.
CREATE TABLE news_body (
id int(11) NOT NULL auto_increment,
overskrift tinytext NOT NULL,
nick tinytext NOT NULL,
email tinytext NOT NULL,
dato tinytext NOT NULL,
txt text NOT NULL,
svar int(11) NOT NULL default '0',
forsmag text NOT NULL,
image varchar(25) NOT NULL default '',
PRIMARY KEY (id)
) TYPE=MyISAM;
#Denne hvor Comment skrives i.
CREATE TABLE news_msg (
id int(11) NOT NULL auto_increment,
nick tinytext NOT NULL,
email tinytext NOT NULL,
dato tinytext,
txt text NOT NULL,
spm tinyint(4) NOT NULL default '0',
ipnummer varchar(255) NOT NULL default '',
PRIMARY KEY (id)
) TYPE=MyISAM;
_____________________
SLUT SQL DB
_____________________
_____________________
PhP kode - front-de.php
_____________________
<?php
include("functions/connect.php");
include('tagster_lib.php');
?>
<link rel="STYLESHEET" type="text/css" href="style.css">
<center>
<TABLE WIDTH=475 BORDER=0 align="center" CELLPADDING=0 CELLSPACING=0>
<TR>
<TD> <img src="images/news_01.gif" width=475 height=15 alt=""></TD>
</TR>
<TR>
<TD background="images/news_bg.gif" WIDTH=475 >
<table width="95%" border="0" align="center" cellpadding="0" cellspacing="0">
<tr>
<td><?
$id = $_GET['id'];
$query = mysql_query("SELECT * FROM news_body WHERE id=$id");
$r = mysql_fetch_array($query);
echo "<font size=\"3\"><b>$r[overskrift]</b><br></font>";
if ($r[email] == "") {
echo "<font color=\"#999999\" size=\"1\">$r[nick] ($r[dato])</font><br>";
} else {
echo "<em><font color=\"#779BBF\" size=\"1\"><a href=\"mailto: $r[email]\">$r[nick]</a> ($r[dato])</font><br></em>";
echo "<img src='images/separator1.gif' border=\"0\"><br><br>";
}
$r["txt"] = tagster_format($r["txt"], "_blank", "");
$r["txt"] = str_replace("[bold]", "<b>", $r["txt"]);
$r["txt"] = str_replace("[/bold]", "</b>", $r["txt"]);
$r["txt"] = str_replace("[italic]", "<em>", $r["txt"]);
$r["txt"] = str_replace("[/italic]", "</em>", $r["txt"]);
$r["txt"] = str_replace("[pic]", "<img src=", $r["txt"]);
$r["txt"] = str_replace("[/pic]", ">", $r["txt"]);
$r["txt"] = str_replace("
$r["txt"] = str_replace("
$r["txt"] = str_replace("", "<u>", $r["txt"]);
$r["txt"] = str_replace("", "</u>", $r["txt"]);
echo $r["txt"];
echo "<br>";
?></td>
</tr>
</table></TD>
</TR>
<TR>
<TD> <IMG SRC="images/news_03.gif" WIDTH=475 HEIGHT=15 ALT=""></TD>
</TR>
</TABLE>
<br>
<TABLE WIDTH=475 BORDER=0 align="center" CELLPADDING=0 CELLSPACING=0>
<TR>
<TD> <img src="images/news_01.gif" width=475 height=15 alt=""></TD>
</TR>
<TR>
<TD background="images/news_bg.gif" WIDTH=475 ><table width="95%" border="0" align="center" cellpadding="0" cellspacing="0">
<tr>
<td><?
$query = mysql_query("SELECT * FROM news_msg WHERE spm=$_GET[id] ORDER BY id");
while ($r = mysql_fetch_array($query)) {
if ($r[email] == "") {
echo "<em>Comment #$r[id] ($r[dato])</em> <br> $r[nick] ";
} else {
echo "<em>Comment #$r[id] (". $r["dato"] .")</em> <br> <a href=\"mailto: $r[email]\">". htmlentities($r["nick"]) ."</a> <font color=\"#999999\" size=\"1\"></font><br>";
}
$r["txt"] = tagster_format($r["txt"], "_blank", "");
$r["txt"] = str_replace("[bold]", "<b>", $r["txt"]);
$r["txt"] = str_replace("[/bold]", "</b>", $r["txt"]);
$r["txt"] = str_replace("[italic]", "<em>", $r["txt"]);
$r["txt"] = str_replace("[/italic]", "</em>", $r["txt"]);
echo $r["txt"];
echo "<br><img src='images/separator1.gif' border=\"0\"><br>";
}
?>
<br>
<table width="300" border="0" align="left" cellpadding="0" cellspacing="0" style="FONT-SIZE: 8pt">
<tr>
<td> <div align="left"><b>Comment</b><br>
<br>
</div>
<form method="post" action="functions.php">
<div align="left">
<input type="hidden" name="id" value="<?= $id; ?>">
<input type="hidden" name="perform" value="reply">
Name:
<input type="text" name="nick" value="<? echo $_COOKIE['nick']; ?>" class="input">
<br>
Email:
<input type="text" name="email" value="<? echo $_COOKIE['email']; ?>" class="input">
<br>
<textarea rows="7" name="txt" class="input" style="width: 322px"></textarea>
<br>
<input type="submit" name="send" value="Send" style="font-size: 7pt; font-family: Tahoma;">
<input type="checkbox" name="cookie">
Save my name and email. <br>
</div>
</form></td>
</tr>
</table></td>
</tr>
</table></TD>
</TR>
<TR>
<TD> <IMG SRC="images/news_03.gif" WIDTH=475 HEIGHT=15 ALT=""></TD>
</TR>
</TABLE>
<br>
</center>
</body>
</html>
_____________________
SLUT PhP kode - front-de.php
_____________________
