multidimensional arrays and mysql

[slightlyeskew]

Hey guys, I posted this in the database forum but I'm worried the topic might be a little too newb to get answered. Moderators if I've committed a serious faux pas by this double post I apologize 😃

I'm trying to connect to my db, pull out values from two fields and cycle through and store the values in a multidimensional array.

Normally to get one field out I would run this:

e.g.

$blaharray[] = 0;
$blahcounter = 0;
$test = $db->query("SELECT field1 FROM testTable");
while ($row = $test->fetchRow(MDB2_FETCHMODE_ASSOC))
       {
        foreach($row as $key => $value)
          {
             $blaharray[$blahcounter] = $value;
             $blahcounter++;
           }
        } 

I'm not sure how to translate this into a multidimensional version. As always, any help would be greatly appreciated.

[johanafm]

You're doing too much work yourself 😉

/* $blaharray[] = 0 creates an array containing one element with a value of 0: array(0).
You probably want: */
$blaharray = array();	// empty array
$test = ...;
while ($row = ...) {
	// the row is allready an array, so why go through all that extra trouble...
	// $blaharray = $row would put the row array in $blaharray, overwriting anything previous

// But the [] operator tells PHP to append a new array element and assign $row to this element
$blaharray[] = $row;
}

Thus you end up with

array( 0 => array ('field1' => 'somevalue'),
	1 => array('field1' => some other value')
)

But you could have made your code work by

// either
foreach($row as $key => $value) {
	$blaharray[$blahcounter][$k] = $value;
	$blahcounter++;
}

// or
foreach($row as $key => $value) {
	$blaharray[$blahcounter] = array($k => $value);
	$blahcounter++;
}

[pete_bisby]

Don't really need the $blahcounter either - using just $blaharray[] will append to the end of the array.