I have a MySQL table which contains the following type of information Date product 2011-12-12 azd 2011-12-12 yxm 2011-12-10 sdx 2011-12-10 ssdd Here is an example of a script I use to get data from this table lt php con mysql connect localhost username password if con die Could not connect mysql error mysql select db db con sql mysql query SELECT FROM buy ORDER BY Date while row mysql fetch array sql echo lt li gt lt a href http www website row Date html gt buy date j M Y strtotime row Date lt a gt lt li gt mysql close con gt This script displays every date from the table e g 12 dec 2011 12 dec 2011 10 dec 2011 10 dec 2011 I would like to only display unique dates e g 12 dec 2011 10 dec 2011

selecting unique values from a column

Use the DISTINCT operator in MySQL:

SELECT DISTINCT(Date) AS Date FROM buy ORDER BY Date DESC;

~ Answered on 2011-12-20 07:10:36