How to make a request without repeated data?

Question

PHP

There is a request:

$procurement = mysql_query ("SELECT data_start_god 
FROM goods 
WHERE id_com_god='{$company['inde_com']}' ORDER BY `data_start_god` ASC LIMIT 7",$db);
while ($rowk = mysql_fetch_array($procurement))
echo "'{$rowk['data_start_god']}',";

How to change it so that the same data of the data_start_god variable does not repeat?

Answer 1

procurement = mysql_query ("SELECT data_start_god 
FROM goods 
WHERE id_com_god='{$company['inde_com']}' GROUP BY data_start_god  ORDER BY `data_start_god` ASC LIMIT 7",$db);
while ($rowk = mysql_fetch_array($procurement))
echo "'{$rowk['data_start_god']}',";