array of hashes

Anon

Hiya,

I'm trying to create an array of hashes (so, two dimensional array.. first dimension accessed by numbers, second accessed by strings)

Any idea why the following code doesn't seem to work?

$result = mysql_query("SELECT a,b,c FROM table1");

while ($row = mysql_fetch_array($result)) {
$myarray[] = $row;
}

What do I have to do to get this to work?

Thanks,
~Matt

Anon

Try doing an

array_push($row, $myarray)

instead.

Anon

You can't leave the index implicit. Create a counter
to use, i.e.:

  $i = 0;

  while ($row = mysql_fetch_array($result))
    {
    $myarray[$i] = $row;
    ++$i;
    }

Anon

That didn't work either.. same problem as when the index was implicit.

Anon

That worked!

I had to initialize the array first, and the order of array_push is opposite to what you had, but it works fine. Thanks!

$result = mysql_query("SELECT a,b,c FROM table1");

$myarray = array();

while ($row = mysql_fetch_array($result)) {
array_push($myarray, $row);
}

Anon

I realized that the original code also works.. the way I was trying to display the values was incorrect.

I was doing:

print("$myarray[0][a] -- $myarray[0]");

which doesn't work any way you do it. If you use printf, however, it works fine.

printf("%s -- %s", $myarray[0][a], $myarray[0]");

~Matt

Anon

Or even easier:

print($myarray[0][a]." -- ".$myarray[0]);

Jack