Trying to show pictures of items with year and description and sold sign. It seems to work but shows pictures on the leftside of webpage instead of across the webpage

[vet911]

try {
echo "<br>";
foreach($dbh->query("SELECT * FROM test_shot WHERE sold=1 ORDER BY year ASC") as $row) {
	
						if($row['picture'] != "" && $row['picture'] != null)
						{
						echo "<div class='image-holder'><img src ='".$row['picture']."' width=300px /><br>";  
            			}
						if($row['year'] != "" && $row['year'] != null)
						{
							echo $row['year'];
						}
						if($row['description'] != "" && $row['description'] != null)
						{
							echo $row['description'];
						}
						if($row['sold'] == 1) {
							echo "<img src='images/sold1.png'><br>";//Add your image code here
							}
							elseif ($row['sold'] == 0) {
							
							echo "</div><br>";
						}
					}

	}	

catch (PDOException $e) {
  print $e->getMessage();
}

?>

 

[requinix]

Your HTML markup doesn't close the </div> properly. It also puts a <br> after it.

[vet911]

Thanks for the comment. I finally figured it out.

try {
echo "<br>";
foreach($dbh->query("SELECT * FROM test_shot WHERE testshot=1 ORDER BY year ASC") as $row) {
							
			echo "<div class='image-holder'><img src ='".$row['picture']."' width=300px /><br><a> ".$row['year']."  ".$row['description']."	</a>";
                      
            if($row['sold'] == 1) {
			echo "<img src='images/sold1.png'></div>";
			}
			elseif ($row['sold'] == 0) {							
			echo "</div>";
			}
		}
	}	

catch (PDOException $e) {
  print $e->getMessage();
}