Display MYSQL query result in horizontal view

[thesimvn]

We have employee attendance system in mysql database but it dont have the reporting capability, i am trying to generate reports using PHP. Let me explain clearly :employee punch in and punch out daily. These punch ins and outs are stored in mysql database table ( attendance). This table contain 5 fields like punch in, punchout, employeeid, note, attendanceid. Our employee names and other details are stored in other table ( employee).My query is that I want to generate a report using these two tables in horizontal view.example : column1 : employee namecolumn2 : punchincolumn3 : punchoutcolumn4 : punchincolumn : punchoutI am able to generate daily report for all employees but looking to generate weekly/monthly report.pls help.thanks,raj