MySQL query into multi-dimensional array

Atomiku

Basicly, What im trying to do is have it so I have a multi-dimensional array so like the first "Dimension" is the row and the second "Dimension" is the collumn.

I have got REALLY close (In fact, ive pretty much done it) But theres one problem: This code below only loops once

<?$sql = mysql_query("SELECT * FROM `ranks`");
while($field = mysql_fetch_field($sql)){
	while($row = mysql_fetch_array($sql)){
		$rank[$row['rank']][$field->name] = $row[$field->name];
		$i++;
	}
	$i++;
}?>

Hopefully someone will know why it only loops once (Well, $i is actualy 2 at the end but thats because each loop loops once)

Anyway, Thanks in advance... Matt.

devinemke

$result = mysql_query('SELECT * FROM ranks');
while($row = mysql_fetch_assoc($result))
{
	$ranks[$row['rank_id']] = $row;
}

in this example you'll get an 2D-array ($ranks) with the primary key field (assumed called rank_id) as the array keys and a subarray as the value with the field names and the keys and the field values as the values. is that what you are after?

tekky

I dont quite get your logic... try this instead

$sql = 'SELECT * FROM table WHERE x=y';
$result = mysql_query($sql) or die('error in sql: ' . $sql . ' -- ' . mysql_error());
$i = 0;
while($row = mysql_fetch_assoc($result)) //fetch each result using the column name as the array key
{
  foreach($row as $column=>$val) //loop through each column
  { 
    $arr[$i][$column] = $val; //build array using incremental row # and column name
  }
  $i++; //increase the row counter
}

as to why yours only loops once...
mysql_fetch_field() requires an offset to get incremental field information.... you arent doing this so it assumes field 1 and returns that....

markg85

ehm this is completely new for me 😛 i didn`t knew that this was possible but let me get this straid..

you can put an entire database in a multidemensional array if i don`t mistake?

Weedpacket

Originally posted by markg85
ehm this is completely new for me 😛 i didn`t knew that this was possible but let me get this straid..

you can put an entire database in a multidemensional array if i don`t mistake?

Yes. When you fetch a row out from the database, you get it as an array. Once you've got it doesn't matter where it came from, it's just another array like any other.

One of the most powerful skills to learn in programming is finding the right way to represent your data. Pick the right representation and the coding can become trivial.