So I have been able to post the comment in the page I am creating and that comment is also saved in the comment table in the database with the id of the picture but when i am in the first picture and I comment the comments are posted saved in the database with the id 1 and then i go to the second the comments are also posted and saved in the tabel comment with the id of the picture 2. But my problem is that when i go to the second picture i can also see the comments of the first picture. So in all of my pictures I can see comments of pictures with other id. How can i manage to solve this problem. Please suggest me sth

I'll describe a little bit my database

name of database is art
picture tabel I have named piktur(id_piktur,Titulli,Pershkrimi,Piktur_url) rsGallery is picture recordset
the comment tabel I have named komente(id_koment,id_piktur,Tekst)rsKomente is comment recordset
Tekst is the column where the comment is save
I'm using the session variable so i can get the id of the picture from the picture table and insert it in id picture column of the comment tabel

this is the piece of code i guess i should make some conditions but i have tried sth myself but I have not managed to solve my problem. The pictures in my page are organised with paging and repeat region only showing 1 picture at a time. the comment are also repeat region showing all the comments at a time.

<p>
      <?php  while ($row_rsKomente = mysql_fetch_assoc($rsKomente)) { ?>
        <?php
$id_piktur=$row_rsGallery['Id_piktur']; $_SESSION['id_piktur']=$id_piktur; 
          echo $row_rsKomente['Tekst']."<br/>" ;?>
        <?php } ?>
  </p>

my entire code is shown below if you don't think this code is enough for solving the problem gallery.php. Oh and I've been using DreamWeaver. Thank you in advance! :)

<?php require_once('Connections/art.php'); ?>
<?php session_start() ?>
<?php
if (!function_exists("GetSQLValueString")) {//this is some code i don't shown in here because it has nothing to do with the problem i want to solve}






if ((isset($_POST["MM_insert"])) && ($_POST["MM_insert"] == "form1") &&(isset($_SESSION['id_piktur'])) ) {
  $insertSQL = sprintf("INSERT INTO komente (Tekst,id_piktur) VALUES (%s,'".$_SESSION['id_piktur']."')", GetSQLValueString($_POST['tekst'], "text"));


  mysql_select_db($database_art, $art);
  $Result1 = mysql_query($insertSQL, $art) or die(mysql_error());
}


$maxRows_rsGallery = 1;
$pageNum_rsGallery = 0;
if (isset($_GET['pageNum_rsGallery'])) {
  $pageNum_rsGallery = $_GET['pageNum_rsGallery'];
}
$startRow_rsGallery = $pageNum_rsGallery * $maxRows_rsGallery;


mysql_select_db($database_art, $art);
$query_rsGallery = "SELECT Pershkrim, Piktur_url, Rankim,id_piktur FROM piktur";
$query_limit_rsGallery = sprintf("%s LIMIT %d, %d", $query_rsGallery, $startRow_rsGallery, $maxRows_rsGallery);
$rsGallery = mysql_query($query_limit_rsGallery, $art) or die(mysql_error());
$row_rsGallery = mysql_fetch_assoc($rsGallery);


if (isset($_GET['totalRows_rsGallery'])) {
  $totalRows_rsGallery = $_GET['totalRows_rsGallery'];
} else {
  $all_rsGallery = mysql_query($query_rsGallery);
  $totalRows_rsGallery = mysql_num_rows($all_rsGallery);
}
$totalPages_rsGallery = ceil($totalRows_rsGallery/$maxRows_rsGallery)-1;
 $maxRows_rsKomente = 10; $pageNum_rsKomente = 0; if (isset($_GET['pageNum_rsKomente'])) {   $pageNum_rsKomente = $_GET['pageNum_rsKomente']; } $startRow_rsKomente = $pageNum_rsKomente * $maxRows_rsKomente; 
mysql_select_db($database_art, $art); $query_rsKomente = "SELECT Tekst,id_piktur FROM komente"; $query_limit_rsKomente = sprintf("%s LIMIT %d, %d", $query_rsKomente, $startRow_rsKomente, $maxRows_rsKomente); $rsKomente = mysql_query($query_limit_rsKomente, $art) or die(mysql_error()); $row_rsKomente = mysql_fetch_assoc($rsKomente);   if (isset($_GET['totalRows_rsKomente'])) {   $totalRows_rsKomente = $_GET['totalRows_rsKomente']; } else {   $all_rsKomente = mysql_query($query_rsKomente);   $totalRows_rsKomente = mysql_num_rows($all_rsKomente); } $totalPages_rsKomente = ceil($totalRows_rsKomente/$maxRows_rsKomente)-1; 

$queryString_rsGallery = "";
if (!empty($_SERVER['QUERY_STRING'])) {
  $params = explode("&", $_SERVER['QUERY_STRING']);
  $newParams = array();
  foreach ($params as $param) {
    if (stristr($param, "pageNum_rsGallery") == false &&
        stristr($param, "totalRows_rsGallery") == false) {
      array_push($newParams, $param);
    }
  }
  if (count($newParams) != 0) {
    $queryString_rsGallery = "&" . htmlentities(implode("&", $newParams));
  }
}
$queryString_rsGallery = sprintf("&totalRows_rsGallery=%d%s", $totalRows_rsGallery, $queryString_rsGallery);


$queryString_rsKomente = "";
if (!empty($_SERVER['QUERY_STRING'])) {
  $params = explode("&", $_SERVER['QUERY_STRING']);
  $newParams = array();
  foreach ($params as $param) {
    if (stristr($param, "pageNum_rsKomente") == false &&
        stristr($param, "totalRows_rsKomente") == false) {
      array_push($newParams, $param);
    }
  }
  if (count($newParams) != 0) {
    $queryString_rsKomente = "&" . htmlentities(implode("&", $newParams));
  }
}
$queryString_rsKomente = sprintf("&totalRows_rsKomente=%d%s", $totalRows_rsKomente, $queryString_rsKomente);
?>


<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<title>Paintings</title>
<link href="style_gallery.css" rel="stylesheet" type="text/css" />
</head>


<body>


  </div>
<div id="logo_wrapper">
<!-- For the example logo, we used a font called "Ink Burrow", which is free from the major font sites. -->
<div id="logo"><img src="_images/logo.png" width="600" height="79" align="right" /></div>
</div>
<div id="main_container">
<div id="menu_container">
<div id="menu">
<ul id="base_menu" >
<li><a href="index.php">Home</a></li>


<li><a href="#">About</a></li>


<li><a href="gallery.php">Gallery</a></li>
<ul class="sub_menu">
<li><a href="#" title="Charcoal" >Charcoal </a></li>
        <li><a href="#" title="Oil paintings" >Oil paintings</a></li>
        <li><a href="#" title="Sketches" >Sketches </a></li>
        <li><a href="#" title="Our latest podcast" >Video Podcast</a></li>
</ul>
<li><a href="#">Contact </a></li>


<li><a href="#">Events</a></li>
<li><a href="login.php">Log in</a></li>


</ul>
</div>
</div>
<div id="mainArticle">
    <h1>Painting Gallery</h1>
      <p>Welcome !</p>
    <p>
      <?php do{ ?>


   <?php   $id_piktur=$row_rsGallery['id_piktur']; $_SESSION['id_piktur']=$id_piktur;             echo $row_rsKomente['Tekst']."<br/>" ;                      ?>         <?php }  while ($row_rsKomente = mysql_fetch_assoc($rsKomente)); ?>  </p>



      <form id="form1" name="form1" method="POST" action="<?php echo $editFormAction; ?>">
        <p>
          <label for="comment">Comment : </label>
        </p>
        <p>
          <textarea name="tekst" id="tekst" cols="45" rows="5">
Member Avatar

@sophy27

Displaying only the comments that are related to one specific image

What error are you getting?

Do you have an image of how it looks?

It's more easier if there's an error on which line so right now it's just guessing.

Be a part of the DaniWeb community

We're a friendly, industry-focused community of 1.20 million developers, IT pros, digital marketers, and technology enthusiasts learning and sharing knowledge.