retrieving array from mysql and iterating through that array

Question

below is a php object which is retrieving some values from mysql db through a php method

$query = "SELECT imgpath from images";

$oMySQL->ExecuteSQL($query);

Now when i use this

$result=$oMySQL->ExecuteSQL($query);

it prints "Array" How to iterate through the array

Regards Jane

Can you post that array. use for or foreach to iterate array — Deadlock
– Deadlock, Commented Jul 16, 2013 at 7:56

DevZer0 · Accepted Answer · 2013-07-16 07:55:26Z

2

A simple foreach loop.

foreach ($result as $key => $val) {
      foreach ($val as $label => $item) {
            echo $label . " - " . $item;
      }
}

$key will hold the associative name the array element, and $val will hold the value of the element.

answered Jul 16, 2013 at 7:55

DevZer0

13.5k7 gold badges29 silver badges54 bronze badges

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

3 Comments

@DevZero it prints 0 - Array1 - Array2 - Array3 - Array4 - Array5 - Array6 - Array not the values

@JaneMarjana instead of echo, use print_r or var_dump functions

@JaneMarjana then you must loop again let me update my answer

R.P · Accepted Answer · 2013-07-16 07:56:23Z

2

You mean it print array when you do echo $result?

Then:

foreach($result as $index => $value) {
   echo $index . '=' $value;
}

answered Jul 16, 2013 at 7:56

R.P

5102 gold badges7 silver badges19 bronze badges