Getting category of a table in Mysql

Question

Staff I have a product registration table and in it I have categories:

$consulta = mysql_query('select categoria from produtos order by categoria');
 while ($var=mysql_fetch_array($consulta))
    {
        echo "<a href='editar.php?categoria=$var[categoria]'>$var[categoria]</a><br><br>";
    }

The problem is he brings me like this:

-Bebidas
-Bebidas
-Higiene e Limpeza
-Higiene e Limpeza
-Mercearia
-Padaria e Confeitaria

Like leaving only one Category title and not duplicated like this one. Ever since I thank!

Answer 1

Only necessary to group by field categoria

SQL Search

$consulta = mysql_query('select categoria from produtos group by categoria order by categoria');