galabin123
Registered
добавянето на коментари е супер и работи ,но при изкарване на коментарите ми показва следната грешка
ето го и кода
PHP:
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '-2, 2' at line 1ето го и кода
PHP:
<?php
if($_POST['upload'])
{
$bio = $_GET['id'];
$coment = addslashes(htmlspecialchars($_POST['coment']));
$date = date('d/m/y');
$adder = $_SESSION['username'];
$zapis = mysql_query("INSERT INTO comment(bio,adder,coment,date) VALUES('$bio','$adder','$coment','$date')") or die(mysql_error());
}
if(!empty($username))
{
echo '
<form action="" method="post" enctype="multipart/form-data">
<textarea name="coment" cols="" rows=""></textarea>
<ul class="textareasubmission">
<li><input type="submit" name="upload" value="Добави Коментар" class="post"> </li>
</ul>
</form>
';
}
$broinastranica = 2;
$pageNum = 1;
if(isset($_GET['page']))
{
$pageNum = $_GET['page'];
}
$redove = ($pageNum - 1) * $broinastranica;
$bio = $_GET['id'];
$db = sprintf("SELECT * FROM comment WHERE bio='$id' ORDER BY id DESC LIMIT $redove, $broinastranica", $bio);
$results = mysql_query($db)or die(mysql_error());
while($row = mysql_fetch_array($results)){
$adder = $row['adder'];
$coment = stripslashes($row['coment']);
$date = $row['date'];
echo '
<ul class="commentslist">
<li class="level1">
<div class="thumb">
<a href="#"><img src="./images/comments1.gif" alt="" /></a>
</div>
<div class="desc">
<div class="commentlinks">
<a href="#" class="reply">Reply</a>
<a href="#" class="like">Like</a>
<a href="#" class="dislike">Dislike</a>
</div>
<h5><a href="#" class="colr">By MySebbb:</a></h5>
<p class="time">7 months ago</p>
<div class="clear"></div>
<p class="txt">
Lorem ipsum dolor sit amet, consectetuer adipiscing elit. Sed elit. Nulla sem risus, vestibulum in, volutpat eget, dapibus ac, lectus. Curabitur dolor sapien.
</p>
</div>
</li>
</ul>
';
}
$query = "SELECT COUNT(id) AS numrows FROM comment WHERE bio='$bio'";
$result = mysql_query($query) or die('Error, query failed');
$row = mysql_fetch_array($result, MYSQL_ASSOC);
$numrows = $row['numrows'];
$maxPage = ceil($numrows/$broinastranica);
$self = $_SERVER['PHP_SELF'];
$nomeranastranici = '';
for($page = 1; $page <= $maxPage; $page++)
{
if ($page == $pageNum)
{
$nomeranastranici .= " $page ";
}
else
{
$nomeranastranici .= " <a href=\"$self?id=$bio&page=$page\">$page</a> ";
}
}
if ($pageNum > 1)
{
$page = $pageNum - 1;
$predishna = " <a href=\"$self?id=$bio&page=$page\"> [<] </a> ";
$parva = " <a href=\"$self?id=$bio&page=1\">[първа]</a> ";
}
else
{
$predishna = ' ';
$parva = ' ';
}
if ($pageNum < $maxPage)
{
$page = $pageNum + 1;
$sledvashta = " <a href=\"$self?id=$bio&page=$page\"> [>] </a> ";
$posledna = " <a href=\"$self?id=$bio&page=$maxPage\">[последна]</a> ";
}
else
{
$sledvashta = ' ';
$posledna = ' ';
}
echo $parva . $predishna . $nomeranastranici . $sledvashta . $posledna;
?>
