Show data array

Question

I have the following data obtained from a query:

I would like to read this data and show it on the screen, but first show all the goals, then show all the challenges and so on.

<?php 

$resultado = ibase_query($CONEXAO_TERM, QueryDashGraf1(substr($loja_selecionada, 0,3),$data_dash, $data_inicial,$ultimo_dia_f));//executa query e armazena o resultado em um array

while ($dash = ibase_fetch_row($resultado)){
 echo trim($dash['0']);
   
}
while ($dash = ibase_fetch_row($resultado)){
 echo trim($dash['3']);

}
?>

Doing so, the second While is not shown.

How do I make the data appear correctly on the screen?

Answer 1

In this example I’m creating a bi-dimensional vector, where the key is column and the value is an array of column values after I print everything. in the case and only one test, then just suit your case.

<?php 

$resultado = ibase_query($CONEXAO_TERM, QueryDashGraf1(substr($loja_selecionada, 0,3),$data_dash, $data_inicial,$ultimo_dia_f));//executa query e armazena o resultado em um array

while ($dash = ibase_fetch_row($resultado)){
    foreach ($dash as $key => $value) {
        $array_return[$key][] = $value;
    }

}
foreach ($array_return as $key => $sub_array) {
    foreach ($sub_array as $key => $value) {
        echo trim($value);
    }
}
?>