Hii Guys...
I'm new member to this nice site...
Here my first question ..
1) I have attendance table (fields like username,date,puch_time) which contains punch timings of every employee .
My question is ..
I want to show a report like this ..

username | date | first_punch | second_punch | third_punch ..... .

My problem was...
2) SELECT username,date,group_concat(punch_time) as punches FROM attendance GROUP BY username,date;

Here i can get data of every employee in single column but i want to show these single data column(punches ) in diff columns like first_punch, second_punch ... so on ...

Guys please help me out ...Thanks in advance