Duplicate values in array

[Anon]

I was wondering how I can remove all duplicate values from an array then sort the array asc. Or maybe better is their a way to make an array only hold unique values so when I am populating the array it only excepts unique values.

[mithril]

Method 1:

  array_unique($array);
  sort($array);
  reset($array);

Method 2:

  $sql = "SELECT field FROM table ORDER BY field";
  $array = array();

  // code to connect a retrieve records

  while ($row = mysql_fetch_array($result)) {
    if (!in_array($row["field"], $array))
      $array[] = $row["field"];
  }

Method 3:

  $sql = "SELECT DISTINCT(field) AS field FROM table ORDER BY field";

  // code to connect a retrieve records

  while ($row = mysql_fetch_array($result))
    $array[] = $row["field"];

This is just a couple of ways, the Array section of the manual would probably be a good place to start reading. HTH.

-geoff