How do i create the array with the values being fetched from database in php

Question

Say i am having set of rows in a table and each row is having a column called city with some values assigned to it iam iterating through the result set and i need to assign the list of city values of each row in to an array only unique

     foreach($res as $row){
       $cities =array();
       $cities[] = $row['city'];
       //when i say 
       var_dump($cities);
       //Iam not able to get array .how do i do that 
       $maincities = array('A','B',C)
     }

Answer 1

You're resetting $cities to a new array for each row you loop through. Better would be:

$cities = array();
foreach ($res as $row)
{
    if ( ! in_array($row['city'], $cities)) {
        $cities[] = $row['city'];
    }
}

Answer 2

Hi,

You should but $cities =array();before the foreach loop. Now you are erasing the array at each iteration.

Regards, Alin

Answer 3

1. You empty the $cities variable every time in the loop.
2. It is probably a lot better practise to only have unique cities in your resultset (SELECT DISTINCT city FROM ...)

Answer 4

For example:

$cities =array();
foreach($res as $row){      
   $cities[] = $row['city'];       
}
var_dump($cities);

However it depends on the content of $res

Answer 5

Using keys to eliminate duplicates:

$cities = array();
foreach($res as $row)
  $cities[$row['city']] = true;
$cities = array_keys($cities);