Attendance report of month

See more:

PHP

I have 2 table
first table is like this

Empid Name Desgnation
1 ab cd
2 bc aa
second table is

Empid status Doc

1 Present 2014-05-01

2 Absent 2014-05-01

1 Present 2014-05-02


I want to desplay my result like this

Empid name 1 2 3 4 5 6 7 ...............31

1 ab present Present

2 bc Absent

please help