2-dimensional array in PHP?

[OldRod]

I have a base_stats table that has a row for each race with 5 fields for each record. I'm wanting to read that into a 2-dimensional array in PHP so I can do some manipulation with it before using it, but I'm not having any luck.

Anyone got an example that shows how to do this?

[Chris]

Code: Select all

<?php

$array = array( array('foo', 'bar') );

foreach( $array as $array2 )
{
    foreach( $array2 as $array2value )
    {
        echo $array2value;  //foobar
    }
}

?>

Something like that?

[Jackolantern]

PHP does not natively support two-dimensional arrays like C++ does (like foo[2,1]), but does support "array or arrays" (like $foo[2][1]).

[OldRod]

I've got the table read in ok, using this code:

Code: Select all

	$qrystring = "SELECT * FROM $db_race_table";
	$result = mysql_query ($qrystring) or die("Could not select from table:$db_race_table");

	$ktr = 0;
	while ($race_row = mysql_fetch_assoc($result))
	{
		foreach ($race_row as $key=>$value)
		{
			$race_stats[$ktr][$key] = $value;
		}
        $ktr++;
	}

Now I just need to know how to reference it.

How do I reference the 2nd field in the 3rd record, for example?

My c++ past tells me $race_stats[3][2] should work, but it doesn't

[Jackolantern]

Remember that arrays are 0 based

[hallsofvallhalla]

yes it starts at 0

[0,1]

[OldRod]

This:

echo "$race_stats[1][0]";
echo "$race_stats[1][1]";

displays the following:

Array[0]
Array[1]

[hallsofvallhalla]

i am not seeing where you defined $race_stats as an array

$array_stats = array(value,value,value) ect

[OldRod]

I have:

$race_stats=array();

at the top of the file - I just didn't get it in when I copied/pasted the code, sorry

I'm thinking of going a different route to accomplish this - this is getting too frustrating

[Jackolantern]

I could be wrong, but because PHP is a weakly typed language, I am not sure that typing

Code: Select all

$variable = array();

will make it an array. Also, to make an array of an array, wouldn't it have to be

Code: Select all

$variable = array(array());

?

However, I am not sure if it can be done like that. Later in the code, did you treat it like an array, where you would fill it like

Code: Select all

$myArray[0][0] = $variableToFill

?