[php] multi-dimensional arrays, and you! - Tilted Forum Project Discussion Community

seretogis · 10-24-2003, 03:20 AM

I'm working on a photo-gallery-like project right now, and am running into some issues manipulating a multi-dimensional array. First, here's the info that I'm working with:

PHP Code:


			
mysql> select * from instance where gallery_id = 88 order by row_number,position;

+-------------+------------+----------+------------+----------+

| instance_id | gallery_id | image_id | row_number | position |

+-------------+------------+----------+------------+----------+

|          36 |         88 |        3 |          1 |        1 |

|          37 |         88 |       12 |          1 |        2 |

|          38 |         88 |        0 |          1 |        3 |

|          39 |         88 |        4 |          1 |        4 |

|          40 |         88 |       11 |          2 |        1 |

|          41 |         88 |        3 |          2 |        2 |

|          42 |         88 |        5 |          2 |        3 |

|          43 |         88 |        0 |          2 |        4 |

+-------------+------------+----------+------------+----------+

8 rows in set (0.00 sec)

In "Gallery 88", there are eight images, on two different rows. The order in which they should appear is the "position". What I would like to do is dump this data into a multi-dimension array in such a format that: $row[row_number][position]['image_id'] would be the image id of the image in the first position of the first row. For example, $row[2][1]['image_id'] == 12, and is the first image of the second row.

The sql wrapper that I use returns an array of an array as the results ( $results[0-254]['column_name'] ), and what I'm currently attempting to do is to select each row, and push each row into a "rows" array, like so:

PHP Code:


			
    function format_instances( $gallery_id ) {

        global $db, $instance_table;



        $next_row = get_current_row( $gallery_id );



        for ( $x=1; $x < $next_row; $x++ ) {

            $rows[] = $db->select_all( $instance_table, "WHERE gallery_id=" . $gallery_id .

                                        "AND row_number=" . $x );

        }



        return $rows;

    }

This doesn't seem to be working -- the result of the following code snippet is an endless loop of some sort which does not return the proper image_id value:

PHP Code:


			
        $gal = format_instances( $gallery_id );



        for ( $x=1; $x < $next_row; $x++ ) {

            for ( $w=0; $x < $positions; $w++ ) {

                $image_id = $gal[$x][$w]['image_id'];

                error_log( "blizzaaahh: " . $image_id );

            }

        }

It's past 6 am now (and I'm still awake), so I am probably missing something incredibly simple, but maybe I'm not? Thanks in advance.

seretogis · 10-24-2003, 01:48 PM

Yeah, it was simple.. The inner for loop was messed up :P

It was: for ( $w=0; $x < $positions; $w++ ) {

It needed to be: for ( $w=0; $w < $positions; $w++ ) {

devnull · 10-25-2003, 12:48 AM

glad I could help!! ... errr... j/k, hehe.

cheerios · 10-25-2003, 07:44 AM

heh, hate it when that happens. as good as a 100 line method to get a value out of a file. and it worked. only I forgot to set it into the member value. so when i accessed it, i got a big fat NULL!

devnull · 10-25-2003, 09:58 AM

I've done the same once where I had 6 seperate if/else if statements and instead of using '==' to check their value, I had put '=' by accident. Three hours and numerous outbursts later, I finally saw the mistake and fell on my floor laughing...

10-24-2003, 03:20 AM	#1 (permalink)
seretogis Huggles, sir? Location: Seattle	[php] multi-dimensional arrays, and you! I'm working on a photo-gallery-like project right now, and am running into some issues manipulating a multi-dimensional array. First, here's the info that I'm working with: PHP Code: mysql> select * from instance where gallery_id = 88 order by row_number,position; +-------------+------------+----------+------------+----------+ \| instance_id \| gallery_id \| image_id \| row_number \| position \| +-------------+------------+----------+------------+----------+ \| 36 \| 88 \| 3 \| 1 \| 1 \| \| 37 \| 88 \| 12 \| 1 \| 2 \| \| 38 \| 88 \| 0 \| 1 \| 3 \| \| 39 \| 88 \| 4 \| 1 \| 4 \| \| 40 \| 88 \| 11 \| 2 \| 1 \| \| 41 \| 88 \| 3 \| 2 \| 2 \| \| 42 \| 88 \| 5 \| 2 \| 3 \| \| 43 \| 88 \| 0 \| 2 \| 4 \| +-------------+------------+----------+------------+----------+ 8 rows in set (0.00 sec) In "Gallery 88", there are eight images, on two different rows. The order in which they should appear is the "position". What I would like to do is dump this data into a multi-dimension array in such a format that: $row[row_number][position]['image_id'] would be the image id of the image in the first position of the first row. For example, $row[2][1]['image_id'] == 12, and is the first image of the second row. The sql wrapper that I use returns an array of an array as the results ( $results[0-254]['column_name'] ), and what I'm currently attempting to do is to select each row, and push each row into a "rows" array, like so: PHP Code: `function format_instances( $gallery_id ) { global $db, $instance_table; $next_row = get_current_row( $gallery_id ); for ( $x=1; $x < $next_row; $x++ ) { $rows[] = $db->select_all( $instance_table, "WHERE gallery_id=" . $gallery_id . "AND row_number=" . $x ); } return $rows; }` This doesn't seem to be working -- the result of the following code snippet is an endless loop of some sort which does not return the proper image_id value: PHP Code: `$gal = format_instances( $gallery_id ); for ( $x=1; $x < $next_row; $x++ ) { for ( $w=0; $x < $positions; $w++ ) { $image_id = $gal[$x][$w]['image_id']; error_log( "blizzaaahh: " . $image_id ); } }` It's past 6 am now (and I'm still awake), so I am probably missing something incredibly simple, but maybe I'm not? Thanks in advance. __________________ seretogis - sieg heil perfect little dream the kind that hurts the most, forgot how it feels well almost no one to blame always the same, open my eyes wake up in flames

10-24-2003, 01:48 PM	#2 (permalink)
seretogis Huggles, sir? Location: Seattle	Yeah, it was simple.. The inner for loop was messed up :P It was: for ( $w=0; $x < $positions; $w++ ) { It needed to be: for ( $w=0; $w < $positions; $w++ ) { __________________ seretogis - sieg heil perfect little dream the kind that hurts the most, forgot how it feels well almost no one to blame always the same, open my eyes wake up in flames

10-25-2003, 12:48 AM	#3 (permalink)
devnull Crazy Location: Bit Bucket	glad I could help!! ... errr... j/k, hehe.

10-25-2003, 07:44 AM	#4 (permalink)
cheerios Banned Location: 'bout 2 feet from my iMac	heh, hate it when that happens. as good as a 100 line method to get a value out of a file. and it worked. only I forgot to set it into the member value. so when i accessed it, i got a big fat NULL!

10-25-2003, 09:58 AM	#5 (permalink)
devnull Crazy Location: Bit Bucket	I've done the same once where I had 6 seperate if/else if statements and instead of using '==' to check their value, I had put '=' by accident. Three hours and numerous outbursts later, I finally saw the mistake and fell on my floor laughing...