PHP Array make up, the meaning of

Question

I have results of an MySQL query. If I then create an array like:

$List = array();    
do {
  $List[] = $row;
} while($row = $test->fetch_assoc());

When I echo the content I get:

Array ( [0] => [1] => Array ( [SeqID] => SeqID0201 ) [2] => Array ( [SeqID] => SeqID0202 ) [3] => Array ( [SeqID] => SeqID0203 ) )

If I then pass the array through a foreach loop

foreach($List as $key => $value) {
    echo $key.' '.$value.'<br />';
}

I get:

1 Array
2 Array
3 Array

My question, how can I get the content of the query result array to pass through the foreach loop to produce the data.

Thanks for your help.

You have a multidimensional array. $value['SeqID'] is probably what you want. — Charlotte Dunois
– Charlotte Dunois, Commented Jul 17, 2016 at 21:15

Clément Laffitte · Accepted Answer · 2016-07-17 21:17:05Z

2

You probably want the result of :

foreach($List as $key => $value) {
    echo $key.' '.$value['SeqID'].'<br />';
}

answered Jul 17, 2016 at 21:17

Clément Laffitte

1066 bronze badges

Sign up to request clarification or add additional context in comments.

10 Comments

DCJones Over a year ago

Perfect. I don't know why I missed that. One last question, how can I get the result in to another array to use in a query, Like $fields[] = $key.' '.$value['SeqID'].'<br />';

Clément Laffitte Over a year ago

Like that: $fields[$key] = $value['SeqID'];?

DCJones Over a year ago

Hi, all I get is Array ( [] => ) when I print_r

Clément Laffitte Over a year ago

With $fields[$key] = $value['SeqID'] in the foreach?

DCJones Over a year ago

Hi, this is what I have: foreach($QList as $field => $val) { $fields[$key] = $value['SeqID']; } and when I print_r I get Array ( [] => ). I have tried all manor of combinations with no joy

|

Collectives™ on Stack Overflow

PHP Array make up, the meaning of

1 Answer 1

10 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

10 Comments

Your Answer

Sign up or log in

Post as a guest

Related