[SOLVED] MYSQL Select Case...Query only 1 when repeated value

[nightkarnation]

Hello...Im wondering how can I code a query where i only want values that are not repeated...

 

Lets say:

 

$dataDate = mysql_query("SELECT date FROM alls_data ORDER BY `alls_data`.`date` ASC");

 

Here the query will result of some dates...September 18, September 17, September 16, September 16, September 16, September 15, etc, etc...

And there are repeated dates...I only want just once each day,

 

Any ideas?

Thanx in advance for ur reply,

Cheers!

[Maq]

I forget the exact syntax but something like:

 

SELECT DISTINCT date

[nightkarnation]

Cool it works perfectly, Thanx man!

 

SELECT DISTINCT date FROM alls_data ORDER BY `alls_data`.`date` ASC

[Maq]

NP, glad I could help!