but for 2011 april first week starts from friday,saturday...

using your query it gives like

date week

2011-04-01 1

2011-04-02 2

2011-04-03 2

2011-04-04 2

this looks like it starts from saturday....

any suggestions please....