Mysql filter double dates -

i busy writing php program check products have being sold on specific date.

now facing problem same date being put database multiple times.

so when want read dates see dates displaying 10 times.

this query :

select date sales  order date desc 

i have being looking on internet while now, cant seem find it.

if give me little hand great.

thanks in forehand

you use distinct:

select distinct date sales  order date desc;