SELECT distinct DATE_FORMAT(dt,'%d.%m') as dt,DAYNAME(dt) as dname FROM tt_dhead_1 WHERE siteid = 1806 and dt>='2010-09-03' limit 8 03.09.2010
Array ( [dt] => 03.09 [dname] => Friday )
Array ( [dt] => 04.09 [dname] => Saturday )
Array ( [dt] => 05.09 [dname] => Sunday )
Array ( [dt] => 06.09 [dname] => Monday )
Array ( [dt] => 07.09 [dname] => Tuesday )
Array ( [dt] => 08.09 [dname] => Wednesday )
Array ( [dt] => 09.09 [dname] => Thursday )