PHP Unique Values from Column in Array

Question

I have an array that is generated from a SQL query that I run. It looks like the following:

$arr[$i]['id'] = $id;
$arr[$i]['name'] = $name;
$arr[$i]['email'] = $email;

How can I get the unique values from the email column? I appreciate the help.

^ can't filter on SQL for what I am doing? ^^ i need a solution immediately. Sorry — scriptdiddy, Jan 11 '13 at 1:30

Gareth Parker · Accepted Answer · 2013-01-11 01:30:22Z

Either filter it in your column using the DISTINCT method in MySQL, or use something like

$uniqueEmails = array();
foreach($arr as $array)
{
    if(!in_array($array['email'], $uniqueEmails)
        $uniqueEmails[] = $array['email'];
}

1 Answer