View difference between Paste ID: s9dPiJRX and 7B9cwagX

-include_once 'connect.php';
+<?php
 
-$player_id = '6';
+    $db_host = '';
     $db_user = '';
-$result_value = array();
+    $db_password = '';
     $dbName = '';
-for ($ix = 1; $ix <= 16; $ix++) {
+
-$result_value[$ix] = array();
+    $db = mysql_connect($db_host,$db_user,$db_password) or die(mysql_error());
-for ($iy = 1; $iy <= 16; $iy++) {
+    if(!$db) die(mysql_error());
-$result_value[$ix][$iy] = array();
+    if(!mysql_select_db($dbName,$db)) die(mysql_error());
-}
+
-}
+    $player_id = 6;
 
-$pullMapInfo = "SELECT x, y, z, value FROM mapinfo WHERE id='{$player_id}'";
+    $arr3d = array();
-$pullMapInfo2 = mysql_query($pullMapInfo) or die(mysql_error());
+
-$pullMapInfo3 = mysql_fetch_assoc($pullMapInfo2);
+    /* Initialization to get a "dense" array
-$x = $pullMapInfo3["x"];
+    $z_row = array_fill(0, $max_z, '<DEFAULT>');
-$y = $pullMapInfo3["y"];
+    $y_row = array_fill(0, $max_y, $z_row);
-$z = $pullMapInfo3["z"];
+    $arr3d = array_fill(0, $max_x, $y_row);
     unset($y_row, $z_row); // Do not waste memory
-$result_value[$x][$y][$z] = $pullMapInfo3["value"];
+    */
 
-for($iz = 1; $iz <= 3; $iz++){
+    $query = "SELECT x, y, z, value FROM mapinfo WHERE id='{$player_id}'";
-    echo 'Layer ', $iz, '<br>';
+
-for($ix = 1; $ix <= 16; $ix++){
+    $handle = mysql_query($query) or die("$query: error: " . mysql_error());
-for($iy = 1; $iy <= 16; $iy++){
+
-    $result_value[$x][$y][$z] = $pullMapInfo3["value"];
+    while($row = mysql_fetch_array($handle))
-    echo '<br>';
+    {
-}
+        // $row is an array with x, y, z and value keys in this order
-}
+        list($x, $y, $z, $value) = $row;
-}
+
         /* This if we had used mysql_fetch_assoc instead
         $x = $row['x'];
         $y = $row['y'];
         $z = $row['z'];
         $value = $row['value'];
         */
         if (!isset($arr3d[$x]))
             $arr3d[$x] = array();
         if (!isset($arr3d[$x][$y]))
             $arr3d[$x][$y] = array();
         $arr3d[$x][$y][$z] = $value;
     }
     mysql_free($handle);