Using the nth item in a php array

Question

I have created an array, as follows:

$results = array();
do {
  $results[] = $row_products;
} while ($row_products = mysql_fetch_assoc($products));

print_r($results);

This prints out the array like this:

Array ( 
[0] => Array ( 
       [productName] => product1 
       ) 
[1] => Array ( 
       [productName] => product2 
       ) 
[2] => Array ( 
       [productName] => product3 
     )

I want to now use say the second item in the array in another mysql query.

But I cannot define it. I have tried

$results[1];

but this does not work. So in effect, if I echo the second item, it would print 'product2'.

str · Accepted Answer · 2013-02-19 09:16:17Z

2

You should learn the basics about arrays here: http://www.php.net/manual/en/language.types.array.php

You are using a nested array, so you have the access it like this:

echo $results[1]['productName'];

Another solution would be to use $results[] = $row_products['productName']; and then just echo $results[1].

In addition, you should use a while loop instead of a do/while loop because $row_products does not seem to be defined for the first iteration.

while ($row_products = mysql_fetch_assoc($products)) {
  $results[] = $row_products;
}

answered Feb 19, 2013 at 9:16

str

45.5k18 gold badges117 silver badges134 bronze badges

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

Comments

Prasanth Bendra · Accepted Answer · 2013-02-19 09:15:48Z

0

try this :

echo $results[1]['productName'] ;

$results[1] is an array, If you want see the array print_r($results[1]);

answered Feb 19, 2013 at 9:15

Prasanth Bendra

33.2k9 gold badges56 silver badges74 bronze badges

Collectives™ on Stack Overflow

Using the nth item in a php array

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related