[RESOLVED] Assigning var values from 2-D array

[forsooth]

I have a MySQL count, group-by query. It results in a 2 D array. I'm stuck on how to assign the values to a list of variables using the while/foreach loops. I've tried all sorts of crazy things, but cannot get it.

$sql = "SELECT  riounit        AS unit
              , COUNT(riounit) AS countunit
          FROM $c_keytable
      GROUP BY riounit
      ORDER BY riounit" ;
$result = mysql_query ( $sql ) ;

$i = 1 ;

while ( $row = mysql_fetch_assoc ( $result ) )
{
  foreach ( $row as $countunit => $value )
  {
     ${unit . $i} = $countunit[$value] ;
     $i++ ;
  }
}

// desired results:

$unit1 = 3
$unit2 = 5
$unit3 = 2
$unit4 = 7  ... etc.

[NogDog]

My recommendation would be to create an array, not a bunch of scalar variables.

$result = mysql_query ( $sql ) ;
$units = array();
while ( $row = mysql_fetch_assoc ( $result ) )
{
   $units[$row['unit'] = Row['countunit'];
}

Then you can access what you need from the $units array using a foreach loop, or any of the many useful built-in array functions.

[forsooth]

Hi, Nog Dog

Thank you for your reply. I could quite get your suggested code to work. I didn't know enough to tweak it.

But I borrowed from your code and here is something that seems to work. Any comments would be appreciated. Thanks!

$sql = "SELECT  riounit        AS unit
              , COUNT(riounit) AS countunit
          FROM $c_keytable
      GROUP BY riounit
      ORDER BY riounit" ;
$result = mysql_query ( $sql ) ;

$i = 1 ;

while ( $row = mysql_fetch_assoc ( $result ) )
{
  ${"unit" . $i} = $row["countunit"] ;
  $i++ ;
}

[bradgrafelman]

Why are you using variable variable names? As NogDog pointed out above, using array is preferable over doing that.

NogDog gave you the code to create the array. So, how did you try to use it?