[RESOLVED] Structuring This Array

kbc1

Hi all

Using the following example:

I have 4 images in the database each with an imagetypeid value.

e.g:
name | imagetypeid

image1.jpg | 1
image2.jpg | 2
image7.jpg | 2
image34.jpg | 5

Now I need to loop through the records and put them into an array which needs to be structured as such:

Array(
    [1] => Array
        (
            [0] => image1.jpg
        )

[2] => Array
    (
        [0] => image2.jpg
        [1] => image7.jpg
    )

[5] => Array
    (
        [0] => image34.jpg

    )
)

You can see the first array KEY is the IMAGETYPEID value and then within that I have all the images associated to that imagetypeid.

Here is my PHP code which is currently not doing what I need:

		while ($row = mysqli_fetch_array($res)) {
			$image 		= $row['image'];
			$typeid 	= $row['imagetypeid'];

		$array[$typeid] = array($largeimage);
	}
	mysqli_free_result($res);

It is overwriting one of the record which shares the same imagetypeid.

Can someone provide an example of how I can fix this?

Many Thanks

bradgrafelman

Easiest way would be to change this line:

$array[$typeid] = array($largeimage);

(which is currently assigning - e.g. overwriting the previous value - an array with a single element) to simply append the current element onto the end of the existing array, e.g. by appending '[]' onto the end of the variable that contains the array. See the following section in the PHP manual for more info (including code examples): Creating/modifying with square bracket syntax.

CoursesWeb

Hi,
Try this code:

$array = array();
while ($row = mysqli_fetch_array($res)) {
  $image         = $row['image'];
  $typeid     = $row['imagetypeid'];

  $array[$typeid][] = $largeimage;
}
mysqli_free_result($res);

kbc1

But if I do the following:

$array[] = array($largeimage);

that looses the key value being the $typeid. I need to group the images into the correct array based on their $typeid.

kbc1

CoursesWeb - That worked exactly right - thank you!

bradgrafelman - I see what you were trying to mean as CourdsesWeb explained. Now the penny has dropped...