Може ли малко помощ отнсно система за коментари!

kosta

Registered
Имам сиситема за коментари вграде в система за нови обаче кагоато зивежда коментарите показват само по един ето кода !


Код:
								<?
$user = $_GET['read'];
$rq = mysql_query("SELECT * FROM `novini` WHERE newsname='$user'");
$row = mysql_fetch_assoc($rq);

$new = wordwrap($row['newstext'], 73, '<br />', $row['newstext']);

echo "
        <h1 style='color:#fff;'>$row[newsname]</h1>
                        <div class='news_center'>
                $new 
                        </div>
                        <div class='news_down' align='left'>Дата на публикация: <b>$row[date]</b>, автор: <a href='profile/$row[newsauthor]' class='news_link'><font color='#a8a8a8'><b>$row[newsauthor]</b></font></a>, коментари: <a href='news/read/$row[id]'><font color='#a8a8a8'><b>0</b></font></a></div><br>";

?>
   <br>
<?
$c = mysql_query("SELECT * FROM `comments` WHERE news_name='$row[newsname]'") or die(mysql_error());
$br = mysql_num_rows($c);
$id = $_GET['id'];
$rq2 = mysql_query("SELECT * FROM `comments` WHERE news_name='$id'  ORDER BY id");
$row2 = mysql_fetch_assoc($rq2);

$text = wordwrap($row2['comment'], 73, '<br />', $row2['comment']);

$news_name = $row['news_name'];
$i++;
 


echo "
        <h1 style='color: #fff;'>Коментари по новината</h1>
                        <div class='news_center'>
					<br><h2 style='color:#fff;'>#$i - $row2[author], <font size='1'>$row[date]</font></h2>	
					<div class='comment_center'>
                $text
				</div><br>
                        </div>   <div class='news_down' align='left'>Коментари: <b>$br</b></div><br>";



						?>
	

			  
<?
if(isset($_POST['addComment']))
{
 if(isset($_POST['submit'])){
 $news_name = $row['newsname'];
 $comment = $_POST['comment'];
 $date = date("d.m.Y,  H:i:s");
 $author = $_SESSION['userinfo']['username'];

 mysql_query("INSERT INTO comments (news_name, date, comment, author) VALUES ('$news_name', '$date', '$comment', '$author')");
unset($_POST['comment']);
unset($_POST['submit']);
}
}
?>
<? if(isset($_SESSION['logged'])){ ?>
<form method="post" action="">
Коментар:<br>
<textarea name="comment" cols="30" rows="3"></textarea><br>
<input type="hidden" name="name" value="<? echo $_GET['read'] ; ?>" />
<input type="submit" name="addComment" class="submit" value="Добави" />
</form>
<?} ?>
 
Я пробвай така:
PHP:
                        <?
$user = $_GET['read'];
$rq = mysql_query("SELECT * FROM `novini` WHERE newsname='$user'");
$row = mysql_fetch_assoc($rq);

$new = wordwrap($row['newstext'], 73, '<br />', $row['newstext']);

echo "
        <h1 style='color:#fff;'>$row[newsname]</h1>
                        <div class='news_center'>
                $new 
                        </div>
                        <div class='news_down' align='left'>Дата на публикация: <b>$row[date]</b>, автор: <a href='profile/$row[newsauthor]' class='news_link'><font color='#a8a8a8'><b>$row[newsauthor]</b></font></a>, коментари: <a href='news/read/$row[id]'><font color='#a8a8a8'><b>0</b></font></a></div><br>";

?>
   <br>
<?
$c = mysql_query("SELECT * FROM `comments` WHERE news_name='$row[newsname]'") or die(mysql_error());
$br = mysql_num_rows($c);
$id = $_GET['id'];
$rq2 = mysql_query("SELECT * FROM `comments` WHERE news_name='$id'  ORDER BY id");
$i=1;
while ($row2 = mysql_fetch_assoc($rq2)) {
$text = wordwrap($row2['comment'], 73, '<br />', $row2['comment']);

$news_name = $row['news_name'];

 


echo "
        <h1 style='color: #fff;'>Коментари по новината</h1>
                        <div class='news_center'>
               <br><h2 style='color:#fff;'>#$i - $row2[author], <font size='1'>$row[date]</font></h2>   
               <div class='comment_center'>
                $text
            </div><br>
                        </div>   <div class='news_down' align='left'>Коментари: <b>$br</b></div><br>";
$i++;

}
                  ?>
   

           
<?
if(isset($_POST['addComment']))
{
 if(isset($_POST['submit'])){
 $news_name = $row['newsname'];
 $comment = $_POST['comment'];
 $date = date("d.m.Y,  H:i:s");
 $author = $_SESSION['userinfo']['username'];

 mysql_query("INSERT INTO comments (news_name, date, comment, author) VALUES ('$news_name', '$date', '$comment', '$author')");
unset($_POST['comment']);
unset($_POST['submit']);
}
}
?>
<? if(isset($_SESSION['logged'])){ ?>
<form method="post" action="">
Коментар:<br>
<textarea name="comment" cols="30" rows="3"></textarea><br>
<input type="hidden" name="name" value="<? echo $_GET['read'] ; ?>" />
<input type="submit" name="addComment" class="submit" value="Добави" />
</form>
<?} ?>
 

Back
Горе