Looping through MySQL and creating an array

BlooPanthr

I'm working on a project where I have a table album_image that has the id numbers from two other tables (album and image). What I'm looking to do is set up an array because it seems the only logical way to do it. The table looks something like

album_id- 1 image_id-2
album_id-1 image_id-8
album_id-2 image_id 20
album_id-2 image_id 1
album_id-2 image_id 5

...which basically comes down to a one to many relationship. What I want to do is connect to MySQL, get the information, put it into an array where $array[$album_id][columns]=$image_id. So my array basically be a row of $album_id, and an undefined number of columns [based on the number of $image_id]. I haven't made any declarations on the array until what I show here. This is what I have, but it doesn't work (my query works fine):

while ($row = mysql_fetch_array($result))
{
	$album_id = $row['album_id'];
	$image_id = $row['image_id'];
	$array[$album_id][]=$image_id;
}

//get the album information
for ($col=1; $col<$album_id; $col++)
{
	for ($ro=1; $ro<$i; $ro++)
	{
		echo "$array[$col][$ro]";
	}
}

I'm basically trying to create links on page and post the $image_ids to the next page to display an album.

Thanks any help!!!!

ahundiak

You have to start ro at 0

$ro_cnt = count($array[$col]);
for($ro = 0; $ro < $ro_cnt; $ro++)
{
echo $array[$i][$ro];
}

But are you sure album_id will always start at 1 and always go up without skipping any numbers? I don't think your design will work if have something like

album_id image_id
27 5
27 6
32 17
32 4

Actually, I think it will work. You can use array_keys() to recover the album_id even if they are out of sequence.

BlooPanthr

I have your suggestion a whirl, but nothing echoed out. It seems really odd... is the array not being made? Does that counter work right?

I shouldn't have any problem with the album_id because in the album table, it's auto-incremented, so there's no integer jump.

Thanks for your suggestion, but it's still not working out. hmmmm.

There nothing in php.ini that I need to setup for arrays, is there?

ahundiak

You should not need to setup anything for arrays.
I did see one slight problem in your loop. It should be:
for($i = 1; $i <= $album_id; $i++) {
Since $almub_id contains the highest actual id.

I was curious about using a 2d array so I wrote this.

<?php

function main()
{
  echo '<h1>Array 2D</h1><br />';
  $data[1][] = 10;
  $data[1][] = 15;
  $data[2][] = 20;
  $data[2][] = 25;
  $data[2][] = 30;

  // This is just to recover the album id's
  $keys = array_keys($data);
  for($i = 0; $i < count($keys); $i++) {
    echo 'Key ' . $i . ' Value ' . $keys[$i] . '<br />';
  }

  // This is just to cycle through the data
  for($i = 1; $i < 3; $i++) {
    $j_cnt = count($data[$i]);
    for($j = 0; $j < $j_cnt; $j++) {
      echo 'Row ' . $i . ' Col ' . $j . ' Value ' . $data[$i][$j] . '<br />';
    }
  }
}
main();
?>

It works ok. You might try to just print_r($data) just to confirm it's getting filled up by the query loop.