[RESOLVED] Images in dynamic table don't appear in cells properly

[kilbey1]

I am guessing this is a complete newbie question, but I need a point in the right direction. With the following code, I can get my table cells to generate 2 across, pushing any left over to the row below - but when I try to loop through the images, they don't appear in the appropriate cells, instead generating cells straight across. I can see why in this particular example, but I'm not seeing where to place the while loop.

  $num_images = mysql_num_rows($result_images);

  for($z=1; $z<=$num_images; $z++)
  {
	?>	
		<td>
		<?php while ($row_images = mysql_fetch_array($result_images)) { ?>
			<img width="100" border="0" src="<?php echo $row_images['path']; ?>">
		<?php } ?>
		</td>
	<?php	
		if($z % 2 == 0)
		{
			echo "<tr></tr>";
		}	
  }	

[Weedpacket]

                echo "<tr></tr>"; 

I think you mean "</tr><tr>": end this row and start a new one.

I'm assuming here there's a <table><tr> before this code, and a </tr></table> after it, of course.

[kilbey1]

Hi, thanks for that correction. Yes, I do have table tags preceding this code. Here's the code in its entirety. When it displays, my images appear in the first cell only; if I wrap the while loop anywhere outside of the <td></td> tags, my images appear in individual cells but do not give me the expected result (with 3 images total, result should be 2 cols / 1st row, 1 col / 2nd row).

<table width="300" cellspacing="1" cellpadding="2" border="2">
        <tr>
		  <?php


$num_images = mysql_num_rows($result_images);

  for($z=1; $z<=$num_images; $z++)
  {
	?>	
		<td>
		<?php while ($row_images = mysql_fetch_array($result_images)) { ?>
			<img width="100" border="0" src="<?php echo $row_images['path']; ?>">
		<?php } ?>
		</td>
	<?php	
		if($z % 2 == 0)
		{
			echo "</tr><tr>";
		}	
  }	


	  ?>
    </tr>
  </table>

[kilbey1]

I attempted to adapt Weedpacket's code in the frequently asked questions, and it's getting closer - but I'm only displaying the 1st result in each cell. How can I get all results that I know exist (in this case, 3 results) so that picture 1 and 2 would appear in the top 2 cells, and picture 3 appears in the bottom left cell?

$query_images = "select id, name, path, type, size 
FROM images
WHERE name LIKE '508429%'";
$result_images = mysql_query($query_images); 
$row_images = mysql_fetch_array($result_images);

 <table width="300" cellspacing="1" cellpadding="2" border="2">
        <tr>
		  <?php

	//number of columns we want: 
	$display_columns = 2; 

	// We do the query, and find out how many items we'll need to list. 
	$count = mysql_num_rows($result_images); 

	// We have enough to figure out how many empty spaces there'll be left at 
	// the bottom of the table. 
	$padding = ($display_columns-1)-(($count-1)%$display_columns); 
	// 
	// We also know enough to know how many rows there'll be, but I for one 
	// don't really care about that right now. 

	//echo '<table border="1">'; 
	// Let's begin our loop. 
	for($i=0; $i<$count; $i++) 
	{    // Whenever $i is a multiple of $display_columns (including 0), 
		// it's a sign that we're hitting the start of a new row. 
		if($i%$display_columns == 0) 
			echo '<tr>'; 
		//Now for an item. 
		echo '<td>'; 
			echo '<img src="'.$row_images['path'].'">';
		echo '</td>'; 
		//Whenever $i is one less than a multiple of $display_columns, 
		// it's a sign that we're hitting the end of the current row. 
		if($i%$display_columns == $display_columns-1) 
			echo '</tr>'; 
	} 
	// That's all the items done; now we just need to pad the table out and 
	// wrap up. We don't need to pad at all if $padding is zero. 
	if($padding!=0) 
	{    for($i=0;$i<$padding;$i++) 
			echo '<td></td>'; 
		echo '</tr>'; 
	} 


	  ?>
    </tr>
  </table>

[kilbey1]

Eventual solution:

//set up images display
	//number of columns we want: 
	$display_columns = 3; 

// We do the query, and find out how many items we'll need to list. 
$count = mysql_num_rows($result_images); 	

?>

<p class="headline">Listings</p>
<table width="100%" border="0">
  <tr>
    <td align="center" valign="top"><center><img src="<?php echo $count['path']; ?>" width="300" /></center>
		<br />
        <br />	

       <table width="300" cellspacing="1" cellpadding="2" border="2">
    <tr>
	  <?php

	// We have enough to figure out how many empty spaces there'll be left at 
	// the bottom of the table. 
	$padding = ($display_columns-1)-(($count-1)%$display_columns); 
	// 
	// We also know enough to know how many rows there'll be, but I for one 
	// don't really care about that right now. 

	//echo '<table border="1">'; 
	// Let's begin our loop. 
	for($i=0; $i<$count; $i++) 
	{    // Whenever $i is a multiple of $display_columns (including 0), 
		// it's a sign that we're hitting the start of a new row. 
		if($i%$display_columns == 0) 
			echo '<tr>'; 
		//Now for an item. 
		$cellcount=0;
		while ($row_image = mysql_fetch_array($result_images)) { 
			echo '<td><center><img src="'.$row_image['path'].'" width="100"></center></td>';
			$cellcount++;
			if($cellcount >= $display_columns) {
				$cellcount=0;
				echo '</tr><tr>';
			}
		}

		if(($cellcount>0) && ($count>$display_columns)){
			for($fill=$cellcount; 
			$fill<$display_columns; $fill++){
				echo '<td></td>';
			}
		}
		//Whenever $i is one less than a multiple of $display_columns, 
		// it's a sign that we're hitting the end of the current row. 
		if($i%$display_columns == $display_columns-1) { 
			echo '</tr>'; 
		}
	} 


	  ?>
    </tr>
  </table>