仅显示数组PHP中的唯一值

Question

First I check if the current value is part of the array of already displayed values. If it's not, I display it. I still get duplicate values and I don't know why.. Here's my code:

while ($row = mysql_fetch_array($result))
{
    $displayed = array();
    if (!(in_array($row['Brand'],$displayed)))
    {
        array_push($displayed,$row['Brand']);
        echo '<li>';
        echo $row['Brand'];
        echo '</li>';
    }
}

Answer 1

You are reinitializing $displayed = array(); on every iteration of the while loop and essentially clearing any data in it. Move it outside, before the loop.