[PHP] PDO result array Opcje

[karakara]

Witam serdecznie, robie zapytanie do bazy pobieram wszystkie wpisy i wszystkie zdjęcia powiązane z wpisami dostaję tablicę

[PHP] pobierz, plaintext 
Array
(
    [pro_id] => 5
    [0] => 5
    [pro_name] => Wpis 1
    [1] => Wpis 1
    [pro_text] => Opis wpisu 1
    [2] => Opis wpisu 1
    [pro_date] => 2012-09-30
    [3] => 2012-09-30
    [pro_visability] => 1
    [4] => 1
    [photo_id] => 3
    [5] => 3
    [photo_filename] => obr.jpg
    [6] => obr.jpg
    [photo_project_id] => 5
    [7] => 5
)
Array
(
    [pro_id] => 6
    [0] => 6
    [pro_name] => Wpis 2
    [1] => Wpis 2
    [pro_text] => Opis wpisu 2
    [2] => Opis wpisu 2
    [pro_date] => 2012-09-30
    [3] => 2012-09-30
    [pro_visability] => 1
    [4] => 1
    [photo_id] => 8
    [5] => 8
    [photo_filename] => 11651.jpg
    [6] => 11651.jpg
    [photo_project_id] => 6
    [7] => 6
)
Array
(
    [pro_id] => 6
    [0] => 6
    [pro_name] => Wpis 2
    [1] => Wpis 2
    [pro_text] => Opis wpisu 2
    [2] => Opis wpisu 2
    [pro_date] => 2012-09-30
    [3] => 2012-09-30
    [pro_visability] => 1
    [4] => 1
    [photo_id] => 6
    [5] => 6
    [photo_filename] => Zrzut.png
    [6] => Zrzut.png
    [photo_project_id] => 6
    [7] => 6
)
Array
(
    [pro_id] => 6
    [0] => 6
    [pro_name] => Wpis 2
    [1] => Wpis 2
    [pro_text] => Opis wpisu 2
    [2] => Opis wpisu 2
    [pro_date] => 2012-09-30
    [3] => 2012-09-30
    [pro_visability] => 1
    [4] => 1
    [photo_id] => 5
    [5] => 5
    [photo_filename] => ec.jpg
    [6] => ec.jpg
    [photo_project_id] => 6
    [7] => 6
)
Array
(
    [pro_id] => 6
    [0] => 6
    [pro_name] => Wpis 2
    [1] => Wpis 2
    [pro_text] => Opis wpisu 2
    [2] => Opis wpisu 2
    [pro_date] => 2012-09-30
    [3] => 2012-09-30
    [pro_visability] => 1
    [4] => 1
    [photo_id] => 7
    [5] => 7
    [photo_filename] => ps22.jpg
    [6] => ps22.jpg
    [photo_project_id] => 6
    [7] => 6
)
 
[PHP] pobierz, plaintext 

Chciałbym zrobić z tego tablicę

[PHP] pobierz, plaintext 
Array
( 
[0] => array(pro_id, pro_name, pro_text, pro_date, array(photo_filename, photo_filename ,photo_filename))
...
[PHP] pobierz, plaintext 

I tak dla każdego projektu

W tym momencie mam coś takiego

[PHP] pobierz, plaintext 
              $pro = array();
              foreach($result as $row) 
              {
                echo $row['photo_filename'];
                $pro[$row['pro_id']] = array($row['pro_name'], $row['pro_text'], $row['pro_date'], array());
                array_push($pro[$row['pro_id']][3], $row['photo_filename']);
              }
              print_r($pro);
[PHP] pobierz, plaintext 

To daje mi prawie efekt taki jak potrzebuje ale przy kazdej iteraacji, czyszcze sobie rablice ze zdjęciami i ostatecznie mam tam tylko jeden element

[PHP] pobierz, plaintext 
(
    [5] => Array
        (
            [0] => Wpis 1
            [1] => Opis wpisu 1
            [2] => 2012-09-30
            [3] => Array
                (
                    [0] => obr.jpg
                )
 
        )
 
    [6] => Array
        (
            [0] => Wpis 2
            [1] => Opis wpisu 2
            [2] => 2012-09-30
            [3] => Array
                (
                    [0] => 11651.jpg
                )
 
        )
 
)
 
[PHP] pobierz, plaintext 

[CuteOne]

[PHP] pobierz, plaintext 
$tempArray = array();
 
foreach($rows as $row) {
 
   if(!isset($tempArray[$row->id])) {
 
          $tempArray[$row->id] = array(
                 'x' => $row->x,
                 'y' => $row->y,
                 'images' => array($row->images)
          );
   }
   else {
 
           $tempArray[$row->id]['images'][] = $row->images;
   }
}
[PHP] pobierz, plaintext 

[karakara]

dzięki działa