| commentid | comment | iamgesid | ------------------------------------ | 1 | fool | 5557 | | 2 | fool2 | 5585 | ------------------------------------
| id | image | imagesid | --------------------------- | 1 | name1 | 5557 | | 2 | name2 | 5557 | | 3 | name3 | 5585 | ---------------------------
$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; } }
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)