[RESOLVED] Running array twice gives different results?

kilbey1

I have 3 images in an array. I want to display the first image in the array first, and then all 3 images in the array. I can get all the images to display in the array, but when I ask to show just the first image and then repeat the full array, only #2 and #3 are shown. How can I correct this?

Perhaps a better way of explaining this is, if I do this:

$row_main_image = mysql_fetch_array($result_images);
		echo $row_main_image['path'];

...it does give me the first image, but when I do this after it:

	
			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>';
				}
			}

...it only gives me 2 of the 3 available images. I really want all 3 images again.

Query:

$query_images = "select * 
	FROM images
	WHERE name LIKE '508429%'";
	$result_images = mysql_query($query_images);

1 - show me first image in array

<td align="center" valign="top"><center><img src="<?php echo $row_image['path']; ?>" width="300" /></center>
		<br />
        <br />

2 - show me all images in array

$count = mysql_num_rows($result_images); 	
		for($i=0; $i<$count; $i++) 
		{ 
			if($i%$display_columns == 0) 
				echo '<tr>'; 
			$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>';
			}
		}
		if($i%$display_columns == $display_columns-1) { 
			echo '</tr>'; 
		}
	}

bpat1434

I'd do it like this:

<?php

// Your query stuff here!!

$first_image = mysql_result($image_result, 0, 'path'); // Get the path to the first image

echo '<td align="center" valign="top"><center><img src="'.$row_image['path'].'" width="300" /></center>';

while($row = mysql_fetch_array($image_result))
{
  // Show the rest of your info here....
}

kilbey1

You'd think that would work, but what happens for me is this:

Image 1

Image 2 | Image 3

...when what I really want is...

Image 1

Image 1 | Image 2 | Image 3

Here's the chunk of code in its entirety.

//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 

$first_image = mysql_result($result_images, 0, 'path'); // Get the path to the first image 
echo $first_image;

?>" 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>

bpat1434

The interesting thing is, is that you loop within a loop. the while() loop runs for as many rows as there are. the for() loop runs for as many rows as there are. Kinda redundant huh?

Anyway, one option is to reset the pointer between the mysql_result and the for() loop:
[man]mysql_data_seek[/man]($images_result, 0);
See if that works.

kilbey1

mysql_data_seek...this is a new one for me. Thanks for pointing that out.

Since you mention the redundancy, I was trying to code my way into having clean tables for image display, so if I had 3 images and wanted to display it in 2 columns, it would display the 3rd image in the 2nd row and add a final cell to the table, closing it off. I'll dig into this further!

scrupul0us

from what i see... when you call out the first image, doesnt that effectively burn off the first dataset in the array leaving only two datasets

what you could do is assign the mysql array into another:

array = array

orrrrr dump eacdh out into variables then display

bpat1434

why use two arrays, when you can reset the internal pointer of the mysql result with mysql_data_seek($result_resource, row_id)?

mysql_data_seek I believe is what they were looking for, and it should work. Putting the information into another array is fairly redundant, but would also work.

@Kilbey:
You might want to read my tutorial/article on image galleries. It might help you...