Hey there,

Unique Arrays

In my database I have
Wood
Delta
Delta
Wood
Delta
Wood
Fire

I would like to be able to do a print out and receive only
Wood
Delta
Fire

My PHP code currently stands as this,

PHP Code:

  function getCompanies() {
   $sql_text = "SELECT * FROM ".$this->TABLES['statements']." ";

    $data = $this->sql->Select($sql_text);
    $i=0;
    $n=1;
    $len = count($data);

 for ($i=0; $i< $len; $i++) {
    
          $str .=''.$data[$i]['companyname'].'<br>';

}
    return $str;
  } 


Which prints out
Wood
Delta
Delta
Wood
Delta
Wood
Fire

I was told array_unique would solve my problems. But I'm not too sure on how to apply it within the code.

Example array_unique() example

<?php
$input = array("a" => "green", "red", "b" => "green", "blue", "red");
$result = array_unique($input);
print_r($result);
?>


The above example will output:

Array
(
[a] => green
[0] => red
[1] => blue
)

Yes, I've seen and tried that example before posting.
Tried to intergrate it, but can't get it working.

Because of the loop i think?
I'm not sure how to add database information pulled into the array and to store it without overwriting it. Each one will need to be unique.
I'm not too hot on the loops.