Въпрос относно MySQL

Pupe64etoo_92

Registered
Здравейте.
Искам да добавя на новини коментари.
И така написъл съм новина със id=1 например и искам да добавя коментар на тази новина. Добавих коментар на новина със id=1 но имам новина и с id=2 и там излиза същия коментар който съм добавил на новина с ид 1.
Как да огранича коментара да излиза само на id=1. Тоест коментара да е видим само за новина с id=1.
 
В таблицата с коментарите трябва да има едно поле в което ще записваш ID на самата новина

примерно

ID | NOVINA | KOMENTAR

и после пускаш заявка SELECT * FROM komentari WHERE novina = 'ID'
 
Код:
<?php
include("config.php");
include("class_pagination.php");
$rpp = 10;
$sql = "SELECT count(id_news) as `allz` FROM comments WHERE id_news = '$id_com' ORDER BY `id_news` DESC"; 

 // id_news това е колоната в която ми се записва идито на новината. id_com това е айдито на самия коментар. Във момента съм го направил ама пак същата работа



$pagination = new pagination($rpp,$sql);
$pagination->page($_GET['page']);
$query = mysql_query("SELECT * from `comments` LIMIT ".$pagination->limit().",".$pagination->rpp."");
while($d = mysql_fetch_assoc($query)) 
{  
$username=$d[username]; 
$minuti=$d[minuti]; 
$chas=$row[chas]; 
$den=$d[den]; 
$mesec=$d[mesec]; 
$godina=$d[godina]; 
$comment=$d[comment]; 


echo "<table align=center border=1px solid bordercolor=#000000 width=552 height=19 cellpadding=0 cellspacing=0>  
<tr> 
<td width=550 height=auto background=/images/newscomment/textcoment.jpg><font class='ws11' color='#EAEAEA' style='width:552; height:auto;'><div style='padding:3px; text-align:justify;'>".$comment."</div></font>
</td>
</tr>
<tr> 
<td> 
<table width=550 height=auto cellpadding=0 cellspacing=0> 
<tr>
<td width=552 height=auto background=/images/newscomment/infocomment.gif><font color=#FFFFFF class=ws9>Добавил:</font><font size=2pt color=#00FF00><strong> ".$username."</strong></font><font color=#FFFFFF class=ws9> на </font><font size=2pt color=#00FF00><strong>".$den."/".$mesec."/".$godina." - ".$chas.":".$minuti."</strong></font>
</td> 
</tr>
</table>
</td>
</tr>
</table><br />";
}
?>
<?php echo $pagination->showPages(); ?>

Пробвах и пак същата работа. Кажете нещо че ми писнаа.
 
PHP:
<?php
include("config.php");
include("class_pagination.php");
$rpp = 10;
$sql = "SELECT count(id_news) as `allz` FROM comments WHERE id_news = '$id_com' ORDER BY `id_news` DESC";

$pagination = new pagination($rpp,$sql);
$pagination->page($_GET['page']);
$query = mysql_query("SELECT * from `comments` WHERE id_news = '$id_com' ORDER BY `id_news` DESC LIMIT ".$pagination->limit().",".$pagination->rpp."");
while($d = mysql_fetch_assoc($query))
{ 
$username=$d[username];
$minuti=$d[minuti];
$chas=$row[chas];
$den=$d[den];
$mesec=$d[mesec];
$godina=$d[godina];
$comment=$d[comment];


echo "<table align=center border=1px solid bordercolor=#000000 width=552 height=19 cellpadding=0 cellspacing=0> 
<tr>
<td width=550 height=auto background=/images/newscomment/textcoment.jpg><font class='ws11' color='#EAEAEA' style='width:552; height:auto;'><div style='padding:3px; text-align:justify;'>".$comment."</div></font>
</td>
</tr>
<tr>
<td>
<table width=550 height=auto cellpadding=0 cellspacing=0>
<tr>
<td width=552 height=auto background=/images/newscomment/infocomment.gif><font color=#FFFFFF class=ws9>Добавил:</font><font size=2pt color=#00FF00><strong> ".$username."</strong></font><font color=#FFFFFF class=ws9> на </font><font size=2pt color=#00FF00><strong>".$den."/".$mesec."/".$godina." - ".$chas.":".$minuti."</strong></font>
</td>
</tr>
</table>
</td>
</tr>
</table><br />";
}

echo $pagination->showPages(); 
?>

EDIT: Грешката ти е там, че имаш 2 заявки, 1-вата само брои коментарите, а 2-рата заявка извежда коментарите и ти си задал само на 1-вата заявка WHERE id_news, а на 2-рата не си дефинирал нищо и затова ти извежда всичките коментари
 
CaTaHuK каза:
PHP:
<?php
include("config.php");
include("class_pagination.php");
$rpp = 10;
$sql = "SELECT count(id_news) as `allz` FROM comments WHERE id_news = '$id_com' ORDER BY `id_news` DESC";

$pagination = new pagination($rpp,$sql);
$pagination->page($_GET['page']);
$query = mysql_query("SELECT * from `comments` WHERE id_news = '$id_com' ORDER BY `id_news` DESC LIMIT ".$pagination->limit().",".$pagination->rpp."");
while($d = mysql_fetch_assoc($query))
{ 
$username=$d[username];
$minuti=$d[minuti];
$chas=$row[chas];
$den=$d[den];
$mesec=$d[mesec];
$godina=$d[godina];
$comment=$d[comment];


echo "<table align=center border=1px solid bordercolor=#000000 width=552 height=19 cellpadding=0 cellspacing=0> 
<tr>
<td width=550 height=auto background=/images/newscomment/textcoment.jpg><font class='ws11' color='#EAEAEA' style='width:552; height:auto;'><div style='padding:3px; text-align:justify;'>".$comment."</div></font>
</td>
</tr>
<tr>
<td>
<table width=550 height=auto cellpadding=0 cellspacing=0>
<tr>
<td width=552 height=auto background=/images/newscomment/infocomment.gif><font color=#FFFFFF class=ws9>Добавил:</font><font size=2pt color=#00FF00><strong> ".$username."</strong></font><font color=#FFFFFF class=ws9> на </font><font size=2pt color=#00FF00><strong>".$den."/".$mesec."/".$godina." - ".$chas.":".$minuti."</strong></font>
</td>
</tr>
</table>
</td>
</tr>
</table><br />";
}

echo $pagination->showPages(); 
?>

EDIT: Грешката ти е там, че имаш 2 заявки, 1-вата само брои коментарите, а 2-рата заявка извежда коментарите и ти си задал само на 1-вата заявка WHERE id_news, а на 2-рата не си дефинирал нищо и затова ти извежда всичките коментари

Сега въобще не ми излизат коментарите.
 
PHP:
<?php
include("config.php");

$query = mysql_query("SELECT * from `comments` WHERE id_news = '$id_com' ORDER BY `id_news` DESC");
while($d = mysql_fetch_array($query))
{ 
$username = $d['username'];
$minuti = $d['minuti'];
$chas = $row['chas'];
$den = $d['den'];
$mesec = $d['mesec'];
$godina = $d['godina'];
$comment = $d['comment'];


echo "<table align=center border=1px solid bordercolor=#000000 width=552 height=19 cellpadding=0 cellspacing=0> 
<tr>
<td width=550 height=auto background=/images/newscomment/textcoment.jpg><font class='ws11' color='#EAEAEA' style='width:552; height:auto;'><div style='padding:3px; text-align:justify;'>".$comment."</div></font>
</td>
</tr>
<tr>
<td>
<table width=550 height=auto cellpadding=0 cellspacing=0>
<tr>
<td width=552 height=auto background=/images/newscomment/infocomment.gif><font color=#FFFFFF class=ws9>Добавил:</font><font size=2pt color=#00FF00><strong> ".$username."</strong></font><font color=#FFFFFF class=ws9> на </font><font size=2pt color=#00FF00><strong>".$den."/".$mesec."/".$godina." - ".$chas.":".$minuti."</strong></font>
</td>
</tr>
</table>
</td>
</tr>
</table><br />";
}
?>

Я пробвай така ?
И интересно ми е от къде вземаш $id_com ?
 
Виж заявките и ше разбереш от къде вземам id_com
Код:
CREATE TABLE `news` (
`id_news` int(50) NOT NULL auto_increment,
`title` varchar(250) default NULL,
`cats` varchar(250) default NULL,
`newstext` text,
`minuti` varchar(50) default NULL,
`chas` varchar(50) default NULL,
`den` varchar(50) default NULL,
`mesec` varchar(50) default NULL,
`godina` varchar(50) default NULL,
`potrebitel` varchar(100) default NULL,
`url` varchar(255) default NULL,
PRIMARY KEY (`id_news`)
) ENGINE=MyISAM DEFAULT CHARSET=UTF8 AUTO_INCREMENT=1; 


CREATE TABLE `comments` (
  `id_com` int(50) NOT NULL auto_increment,
  `id_news` varchar(250) default NULL,
  `username` varchar(26) default NULL,
  `email` varchar(70) default NULL,
  `minuti` varchar(50) default NULL,
  `chas` varchar(50) default NULL,
  `den` varchar(50) default NULL,
  `mesec` varchar(50) default NULL,
  `godina` varchar(50) default NULL,
  `ip` varchar(160) default NULL,
  `comment` text,
  `title` varchar(250) default NULL,
  PRIMARY KEY  (`id_com`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=54 ;

Код:
<input type="hidden" value="<?php echo "$id_news" ?>" name="id_news">

id_new от таблица news го презаписвам в таблица comments id_news varchar(250) а id_com e йдито на коментарите.

Пак не се получава не излиза новина. Па и си махнал страницирането а и то трябва да е там pagination.
 
$id_com <--- Е променлива от кода.
id_com <--- Е просто име от базата данни за връзка с php кода.

Просто се използват еднакви имена за да е по-разбераемо.
 
Мене ме интересува в самата страница как вземаш $id_com ? Дай целия код на страницата
 
Ето кода:
Код:
<?php include ("config.php"); ?>
<?php 
 
$id_news = $_GET['id_news']; 
$archive="SELECT * FROM news WHERE id_news = '$id_news' ORDER BY godina DESC"; 
$godinass=mysql_query($archive); 

$num=mysql_numrows($godinass); 

mysql_close(); 

$i=0; 
while ($i < $num) { 

$id_news=mysql_result($godinass,$i,"id_news"); 
$title=mysql_result($godinass,$i,"title");
$potrebitel=mysql_result($godinass,$i,"potrebitel");
$chas=mysql_result($godinass,$i,"chas"); 
$minuti=mysql_result($godinass,$i,"minuti"); 
$den=mysql_result($godinass,$i,"den"); 
$mesec=mysql_result($godinass,$i,"mesec"); 
$godina=mysql_result($godinass,$i,"godina");  
$newstext=mysql_result($godinass,$i,"newstext");
$url=mysql_result($godinass,$i,"url");

echo "
<title>CS-XIPNOZA.INFO - $title</title>
<table align=center border=1px solid bordercolor=#000000 width=552 height=19 cellpadding=0 cellspacing=0> 
<tr> 
<td width=552 height=auto background=/images/newscomment/newszaglavie.gif><b><div align='left' class=ws11> $title </div></b>
</td> 
</tr> 
<tr> 
<td> 
<table width=552 height=auto cellpadding=0 cellspacing=0> 
<tr>
<td width=552 height=auto background=/images/newscomment/textnews.jpg><font class='ws10' color='#FFFFFF' style='width:550; height:auto;'><div style='padding:3px; text-align:justify;'><img style=padding:2px; align=right src=$url>$newstext<br /><br /></div></font>
</td>
</tr>
</table>
<tr>
<td background=/images/newscomment/infocomment.gif>
<font color=#FFFFFF class=ws9> Публикувана на 
<font size=2pt color=#00FF00><strong>$den/$mesec/$godina</strong></font>
<font color=#FFFFFF class=ws9> от</font><font size=2pt color=#00FF00> $potrebitel</font></td></tr></table>"; 
$i++; 
} 
?>
<br />
<table align="center" width="551" height="auto">
<tr>
<td width="551" height="27" style="border:#969696 1px solid"><div style="background-image:url(/images/newscomment/newszaglavie.gif)" align="center" class="ws11"><b>Коментари</b></div><div style="padding:2px;" id="contents">
</div><br /><center>
<?php
include ("config.php");

if($_POST['Submit']){ 

$minuti = $_POST['minuti']; 
$chas = $_POST['chas']; 
$den = $_POST['den']; 
$mesec = $_POST['mesec']; 
$godina = $_POST['godina']; 
$username = $_POST['username']; 
$comment = $_POST['comment'];  
if(empty($username)){ 
echo "Моля, въведете име"; 
die(); 
}; 
if(empty($comment)){ 
echo "<META HTTP-EQUIV=\"refresh\" CONTENT=\"0; URL=fullnews.php?id_news=$id_news\">";
die();
}; 

$query = "INSERT INTO `comments` ( `id_com` , `id_news` , `username` , `minuti`, `chas`, `den`, `mesec`, `godina`, `ip`, `comment`, `title`) 
VALUES ('NULL', '$id_news', '$username', '$minuti', '$chas', '$den', '$mesec', '$godina', '$ip', '$comment', '$title');"; 
$ok = mysql_query($query);
if($ok){ 
echo "<font class=ws10 color=#fff>Коментара е Добавен<META HTTP-EQUIV=\"refresh\" CONTENT=\"0; URL=fullnews.php?id_news=$id_news\"></font>";  
}else{ 
echo "Възникна грешка"; 
} 
}; 

?></center> 
<form action="fullnews.php?id_news=<?php echo "$id_news" ?>" method="post" name="form"> 
<input type="hidden" value="<?php print(date("i")); ?>" name="minuti"> 
<input type="hidden" value="<?php print(date("G")); ?>" name="chas"> 
<input type="hidden" value="<?php print(date("j")); ?>" name="den"> 
<input type="hidden" value="<?php print(date("F")); ?>" name="mesec"> 
<input type="hidden" value="<?php print(date("Y")); ?>" name="godina"> 
<input type="hidden" value="<?php echo $_SERVER['REMOTE_ADDR']; ?>" name="ip"> 
<input type="hidden" value="<?php echo "$id_news" ?>" name="id_news"> 
<input type="hidden" value="<?php echo "<font>".$user->data['username']."</font>" ?>" name="username"> 
<table align="center" width="551" height="auto" border="#000000 1px splid">
<tr>
<td id="lineLRBs" class="nav"> 
<h5 align="center"><img alt="Добави коментар" border="0" style="margin-right:6px; margin-top:3px; margin-bottom:-3px; cursor:pointer;" onclick="showContent(this);" /></h5>
<div align="center" style="display:none;">
<textarea rows=7 class=commentbox name=comment cols=45 type=text style="border:#000000 1px solid; background-color:#CCCCCC;"></textarea><br /><br /><input type=submit style="border:#000000 1px solid; background-color:#CCCCCC;" name=Submit value=Добави class=form> 
</div>
</form>
</td>
</tr>
</table>
 
PHP:
<?php
include("config.php");
include("class_pagination.php");

$idto = $_GET['id_news']; 

$rpp = 10;
$sql = "SELECT count(id_news) as `allz` FROM comments WHERE id_news = '$idto'";

$pagination = new pagination($rpp,$sql);
$pagination->page($_GET['page']);
$query = mysql_query("SELECT * FROM `comments` WHERE id_news = '$idto' LIMIT ".$pagination->limit().",".$pagination->rpp."");
while($d = mysql_fetch_array($query))
{ 
$username = $d['username'];
$minuti = $d['minuti'];
$chas = $row['chas'];
$den = $d['den'];
$mesec = $d['mesec'];
$godina = $d['godina'];
$comment = $d['comment'];


echo "<table align=center border=1px solid bordercolor=#000000 width=552 height=19 cellpadding=0 cellspacing=0> 
<tr>
<td width=550 height=auto background=/images/newscomment/textcoment.jpg><font class='ws11' color='#EAEAEA' style='width:552; height:auto;'><div style='padding:3px; text-align:justify;'>".$comment."</div></font>
</td>
</tr>
<tr>
<td>
<table width=550 height=auto cellpadding=0 cellspacing=0>
<tr>
<td width=552 height=auto background=/images/newscomment/infocomment.gif><font color=#FFFFFF class=ws9>Добавил:</font><font size=2pt color=#00FF00><strong> ".$username."</strong></font><font color=#FFFFFF class=ws9> на </font><font size=2pt color=#00FF00><strong>".$den."/".$mesec."/".$godina." - ".$chas.":".$minuti."</strong></font>
</td>
</tr>
</table>
</td>
</tr>
</table><br />";
}

echo $pagination->showPages(); 
?>

Така?
 
Ядосах се и го махнах това странициране ползвах един урок и си я направих перфектно остава само css файла за страниците да си напиша.

Ето го и кода дано е от полза за някой.

Код:
<table align="center" width="598" height="auto">
<tr>
<td width="598" height="27" style="border:#969696 1px solid" background="images/cenmenu.png"><div align="center" style="color:#D1D1D1;" class="ws11">Counter Strike Новина</div></td>
</tr>
<tr>
<td width="598" height="auto" style="border:#969696 1px solid">
<br />
<?php include ("config.php"); ?>
<?php 
 
$id_news = $_GET['id_news']; 
$archive="SELECT * FROM news WHERE id_news = '$id_news' ORDER BY godina DESC"; 
$godinass=mysql_query($archive); 

$num=mysql_numrows($godinass); 

mysql_close(); 

$i=0; 
while ($i < $num) { 

$id_news=mysql_result($godinass,$i,"id_news"); 
$title=mysql_result($godinass,$i,"title");
$potrebitel=mysql_result($godinass,$i,"potrebitel");
$chas=mysql_result($godinass,$i,"chas"); 
$minuti=mysql_result($godinass,$i,"minuti"); 
$den=mysql_result($godinass,$i,"den"); 
$mesec=mysql_result($godinass,$i,"mesec"); 
$godina=mysql_result($godinass,$i,"godina");  
$newstext=mysql_result($godinass,$i,"newstext");
$url=mysql_result($godinass,$i,"url");

echo "
<title>CS-XIPNOZA.INFO - $title</title>
<table align=center border=1px solid bordercolor=#000000 width=552 height=19 cellpadding=0 cellspacing=0> 
<tr> 
<td width=552 height=auto background=/images/newscomment/newszaglavie.gif><b><div align='left' class=ws11> $title </div></b>
</td> 
</tr> 
<tr> 
<td> 
<table width=552 height=auto cellpadding=0 cellspacing=0> 
<tr>
<td width=552 height=auto background=/images/newscomment/textnews.jpg><font class='ws10' color='#FFFFFF' style='width:550; height:auto;'><div style='padding:3px; text-align:justify;'><img style=padding:2px; align=right src=$url>$newstext<br /><br /></div></font>
</td>
</tr>
</table>
<tr>
<td background=/images/newscomment/infocomment.gif>
<font color=#FFFFFF class=ws9> Публикувана на 
<font size=2pt color=#00FF00><strong>$den/$mesec/$godina</strong></font>
<font color=#FFFFFF class=ws9> от</font><font size=2pt color=#00FF00> $potrebitel</font></td></tr></table>"; 
$i++; 
} 
?>
<br />
<table align="center" width="551" height="auto">
<tr>
<td width="551" height="27" style="border:#969696 1px solid"><div style="background-image:url(/images/newscomment/newszaglavie.gif)" align="center" class="ws11"><b>Коментари</b></div><div style="padding:2px;">
<?php
include ("config.php");
$id = $_GET['id_news'];

$pp = "10";
$page=$_GET['page']; 

if(!$_GET['page']) 
{
$page="1";
}
$limit = ($pp*$page)-$pp;
$redove=mysql_query("SELECT * FROM comments WHERE id_news = '$id' ORDER BY id_com DESC");
$max=mysql_numrows($redove); 
$total=ceil($max/$pp);
$query="SELECT * FROM comments WHERE id_news = '$id' ORDER BY id_com DESC LIMIT $limit,$pp";
$result=mysql_query($query);
$num=mysql_numrows($result);
mysql_close();
$i=0;
while ($i < $num) {

$username=mysql_result($result,$i,"username");
$minuti=mysql_result($result,$i,"minuti");
$chas=mysql_result($result,$i,"chas");
$den=mysql_result($result,$i,"den");
$mesec=mysql_result($result,$i,"mesec");
$godina=mysql_result($result,$i,"godina");
$comment=mysql_result($result,$i,"comment");

echo "<table align=center border=1px solid bordercolor=#000000 width=552 height=19 cellpadding=0 cellspacing=0> 
<tr>
<td width=550 height=auto background=/images/newscomment/textcoment.jpg><font class='ws11' color='#EAEAEA' style='width:552; height:auto;'><div style='padding:3px; text-align:justify;'>$comment</div></font>
</td>
</tr>
<tr>
<td>
<table width=550 height=auto cellpadding=0 cellspacing=0>
<tr>
<td width=552 height=auto background=/images/newscomment/infocomment.gif><font color=#FFFFFF class=ws9>Добавил:</font><font size=2pt color=#00FF00><strong>$username</strong></font><font color=#FFFFFF class=ws9> на </font><font size=2pt color=#00FF00><strong>$den/$mesec/$godina - $chas:$minuti</strong></font>
</td>
</tr>
</table>
</td>
</tr>
</table><br />";

$i++;
}

echo "<center>";

if ($page > 1) {
$prev = ($page - 1);
echo "<a href=\"fullnews.php?id_news=$id_news&page=$prev\"><font face=\"Trebuchet MS\">Предишна</font></a> ";
}
else echo "<font face=\"Trebuchet MS\">Предишна</font> ";

if (!$page or ($page > $total)) {
$page="1";
}

if ($total < 10) {
for($i=1 ; $i<=$total ; $i++) {
if ( ($page)==$i ) {
echo "<b>$i</b> ";
}
else {
echo "<a href=\"fullnews.php?id_news=$id_news&page=".$i."\">".$i."</a> ";
}
}
}
else {
for($i=1 ; $i<=3 ; $i++) {
if ( ($page)==$i ) {
echo "<b>$i</b> ";
}
else {
echo "<a href=\"fullnews.php?id_news=$id_news&page=".$i."\">".$i."</a> ";
}
}

if ($page <= 3) {
if ($page == 3) echo "<a href=\"fullnews.php?id_news=$id_news&page=4\">4</a> ";
echo "...";
for ($i=$total-2; $i<=$total; $i++)
echo "<a href=\"fullnews.php?id_news=$id_news&page=".$i."\">".$i."</a> ";
}
if ($page == 5) $parva.= "<a href=\"fullnews.php?id_news=$id_news&page=4\">4</a> ";

if ( ($page == 4) or ($page == 5) ) {
for ($i=$page; $i<=$page+1; $i++) {
if ($page == $i) echo "<b>$i</b> ";
else echo "<a href=\"fullnews.php?id_news=$id_news&page=".$i."\">".$i."</a> ";
}
echo "...";
for ($i=$total-2; $i<=$total; $i++)
echo "<a href=\"fullnews.php?id_news=$id_news&page=".$i."\">".$i."</a> ";
}

if ( ($page > 5) and ($page < ($total - 4)) ) {
echo "... ";
for ($i=$page-1; $i<=$page+1; $i++) {
if ($page == $i) echo "<b>$i</b> ";
else echo "<a href=\"fullnews.php?id_news=$id_news&page=".$i."\">".$i."</a> ";
}
echo "...";
for ($i=$total-2; $i<=$total; $i++)
echo "<a href=\"fullnews.php?id_news=$id_news&page=".$i."\">".$i."</a> ";
}

if ( $page > ($total - 5) ) {
echo "...";
for ($i=$total-5; $i<=$total; $i++) {
if ($page == $i) echo "<b>$i</b> ";
else echo "<a href=\"fullnews.php?id_news=$id_news&page=".$i."\">".$i."</a> ";
}
}
}

if ($page < $total) {
$next = ($page + 1);
echo "<a href=\"fullnews.php?id_news=$id_news&page=$next\"><font face=\"Trebuchet MS\">Следваща</font></a> ";
}
else echo "<font face=\"Trebuchet MS\">Следваща</font></center>"; 
?>
</div><br /><center>
<?php
include ("config.php");

if($_POST['Submit']){ 

$minuti = $_POST['minuti']; 
$chas = $_POST['chas']; 
$den = $_POST['den']; 
$mesec = $_POST['mesec']; 
$godina = $_POST['godina']; 
$username = $_POST['username']; 
$comment = $_POST['comment'];  
if(empty($username)){ 
echo "Моля, въведете име"; 
die(); 
}; 
if(empty($comment)){ 
echo "<META HTTP-EQUIV=\"refresh\" CONTENT=\"0; URL=fullnews.php?id_news=$id_news\">";
die();
}; 

$query = "INSERT INTO `comments` ( `id_com` , `id_news` , `username` , `minuti`, `chas`, `den`, `mesec`, `godina`, `ip`, `comment`, `title`) 
VALUES ('NULL', '$id_news', '$username', '$minuti', '$chas', '$den', '$mesec', '$godina', '$ip', '$comment', '$title');"; 
$ok = mysql_query($query);
if($ok){ 
echo "<font class=ws10 color=#fff>Коментара е Добавен<META HTTP-EQUIV=\"refresh\" CONTENT=\"0; URL=fullnews.php?id_news=$id_news\"></font>";  
}else{ 
echo "Възникна грешка"; 
} 
}; 

?></center> 
<form action="fullnews.php?id_news=<?php echo "$id_news" ?>" method="post" name="form">
<input type="hidden" value="<?php echo "$id_news" ?>" name="id_news">
<input type="hidden" value="<?php print(date("i")); ?>" name="minuti"> 
<input type="hidden" value="<?php print(date("G")); ?>" name="chas"> 
<input type="hidden" value="<?php print(date("j")); ?>" name="den"> 
<input type="hidden" value="<?php print(date("F")); ?>" name="mesec"> 
<input type="hidden" value="<?php print(date("Y")); ?>" name="godina"> 
<input type="hidden" value="<?php echo $_SERVER['REMOTE_ADDR']; ?>" name="ip">  
<input type="hidden" value="<?php echo "<font>".$user->data['username']."</font>" ?>" name="username"> 
<table align="center" width="551" height="auto" border="#000000 1px splid">
<tr>
<td id="lineLRBs" class="nav"> 
<h5 align="center"><img alt="Добави коментар" border="0" style="margin-right:6px; margin-top:3px; margin-bottom:-3px; cursor:pointer;" onclick="showContent(this);" /></h5>
<div align="center" style="display:none;">
<textarea rows=7 class=commentbox name=comment cols=45 type=text style="border:#000000 1px solid; background-color:#CCCCCC;"></textarea><br /><br /><input type=submit style="border:#000000 1px solid; background-color:#CCCCCC;" name=Submit value=Добави class=form> 
</div>
</form>
</td>
</tr>
</table>
</td>
</tr>
</table>
 

Back
Горе