SELECT distinct DATE_FORMAT(dt,'%d.%m') as dt,DAYNAME(dt) as dname FROM tt_dhead_2 WHERE siteid IN (1806) and dt>='2010-09-09' limit 8 09.09.2010
Array ( [dt] => 09.09 [dname] => Thursday )
Array ( [dt] => 10.09 [dname] => Friday )
Array ( [dt] => 11.09 [dname] => Saturday )
Array ( [dt] => 12.09 [dname] => Sunday )
Array ( [dt] => 13.09 [dname] => Monday )
Array ( [dt] => 14.09 [dname] => Tuesday )
Array ( [dt] => 15.09 [dname] => Wednesday )
Array ( [dt] => 16.09 [dname] => Thursday )