I am new to PHP and hope someone can help me with this. 

I have a Select query that returns (among others) the values from two columns in a db table, "`ID`" and "`en`". 
When getting the results from the Select **I would like to store both these values for each item in a two dimensional array**. 

So far I have the below. 
The Select itself works correct but when pushing to the array it only outputs the last item from the Select results (for which it looks correct as well) so **my guess is instead of adding each item to the array I am overwriting it every time**. 

Can someone tell me what I am doing wrong here ?
Also, please let me know if something other than While should be preferred here. 

**My PHP:**

```
<?php     
    $tbl = "TranslationsMain";  

    $conn = new mysqli($servername, $username, $password, $dbname);
    if($conn->connect_error){
        die("Connection failed: " . $conn->connect_error);
    } 
    $sql = "SELECT * FROM " . $tbl;
    $result = $conn->query($sql);   
    while($translations = $result->fetch_assoc()){
        $arr = array('ID' => $translations['ID'], 'en' => $translations['en']);
    }
    $conn->close();
    print_r($arr);
?>

```

**Current output (tested with a small table):** 

```
Array ( [ID] => ID10 [en] => Value10 )

```

**Expected output:** 

```
Array ( [ID] => ID1 [en] => Value1, [ID] => ID2 [en] => Value2, [ID] => ID3 [en] => Value3, ... [ID] => ID10 [en] => Value10  )

```

Many thanks in advance, 
Mike