将数组元素转换为单个字符串（PHP）

Question

So basically, I use this to retrieve data

$sql = "SELECT * FROM user WHERE id = ".$_POST['id'];
$user = $this->oDb->selectQuery($sql);

^^ that is this:

$aResult = array();
        while($row = $res->fetch_assoc()) {
            $aResult[] = $row;
        }
        return $aResult;

So that would return this:

Array ( [0] => Array ( [id] => 11 [voornaam] => Franklin [tv] => Delano [achternaam] => Roosevelt ) ) 

How do I convert Franklin which is 'voornaam' and Delano which is 'tv' and Roosevelt which is 'achternaam'

to either $user['voornaam']
$user['tv']
$user['achternaam']

so it would result in echo $user['voornaam'] which would say Franklin

or either $voornaam
$tv
$achternaam

or it would result in echo $voornaam which would say Franklin

Answer 1

echo $aResult[0]['voornaam'];

But this will only work, if you fetch just one row. (Not sure without trying, but I think you're whole code just works for returning only one row, because you always reassign the first element of the result)

Regarding you're other comment it is of course echo $whatEverYouPutTheResultInto[0]['voornaam']