Click here to Skip to main content
14,423,094 members
Rate this:
Please Sign up or sign in to vote.
See more:
I want to display all the related images for a comment in a box together but display the comments in a different div Something like on the image that I have attached.

The output that I want to get
JSFiddle Example in HTML

If there is a new post then repeat the main div with PHP.

I can't figure out how should I do this. I assume that I have to break the loop somewhere.

The database structure:
posts:
| commentid |  comment  | iamgesid |
------------------------------------
|     1     |   fool    |   5557   |
|     2     |  fool2    |   5585   |
------------------------------------


multiple_image:
| id |  image  | imagesid |
---------------------------
| 1  |  name1  |    5557  |
| 2  |  name2  |    5557  |
| 3  |  name3  |    5585  |
---------------------------


The code for fetching the comment with the related images:
$sql = "SELECT * FROM images
    JOIN posts ON (images.imagesid=posts.imgs)
    ORDER BY  postID";
  $result = $conn->query($sql);
  if (!$result) {
      trigger_error('Invalid query: ' . $conn->error);
  }

  if ($result->num_rows > 0) {
    // output data of each row
    $comment = '';
    while($row = $result->fetch_assoc()) {
      if ($row['name'] == NULL) {
        $imgs= '';
      } else {
        $imgs= "<img width='' src='../images/".$row['name']."' >";
      }

  if($comment != $row['content']){
      echo $row['content'];
     $comment = $row['content'];
  }
    echo $imgs;
  } 

 }


What I have tried:

I have tried to loop div as well but it is just looped the div itself.
Posted
Comments
Richard Deeming 26-Feb-19 13:05pm
   
Galarist_00 26-Feb-19 16:42pm
   
Not the same!

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)




CodeProject, 503-250 Ferrand Drive Toronto Ontario, M3C 3G8 Canada +1 416-849-8900 x 100