Difficulty finding values in an array

Question

The following code is an increment code in an array.

However, I haven’t been able to select any array value. If so print_r in it, it shows all but if I try to access with $guarda_array[1] he returns Array and not the name I want. Some part of the code is wrong?

$guarda_array = array();
$count_pub=mysqli_query($db, "SELECT nome FROM publicidades_sponsors");
$count_tudo=mysqli_num_rows($count_pub);
while($gu=mysqli_fetch_assoc($count_pub)){
    array_push($guarda_array, $gu);
}

The print_r shows the following

Array ( [0] => Array ( [nome] => DIDAXIS1.png ) [1] => Array ( [nome] => DIDAXIS2.png ) [2] => Array ( [nome] => DIDAXIS3.png ) [3] => Array ( [nome] => DIDAXIS4.png ) ) 

Answer 1

The structure of your array is like this:

Array ( 
    [0] => Array ( 
        [nome] => DIDAXIS1.png 
    ) 
    [1] => Array ( 
        [nome] => DIDAXIS2.png 
    ) 
    [2] => Array ( 
        [nome] => DIDAXIS3.png 
    ) 
    [3] => Array ( 
        [nome] => DIDAXIS4.png 
    ) 
)

Then realize your attempt misses:

$guarda_array[1]

That one $guarda_array[1] has as content an array, so it returned array, to catch the nome inside $guarda_array[1]:

$guarda_array[1]['nome']

Answer 2

If the intention is to have as a result array with the field "name" of SELECT, you need to do:

$guarda_array = array();
$count_pub=mysqli_query($db, "SELECT nome FROM publicidades_sponsors");
$count_tudo=mysqli_num_rows($count_pub);
while($gu=mysqli_fetch_assoc($count_pub)){
    array_push($guarda_array, $gu["nome"]);
}