Hii Guys...

This is my first post on this nice site..

I'm using PHP Runner to create report for below query.....


SELECT
Username,
date,
cast(group_concat(punch_time) as char) AS punches
FROM attendance
GROUP BY Username
ORDER BY date


Output looks like this...

Username | Date | punches

1) kiran 2012-01-20 09:00:10 , 09:10:15, 10:15:10,......

These punches i want to show on report page like this...

Username | Date | first_punch | second_punch | third_punch | fourth_puch ....
1) kiran 2012-01-20 09:00 10:09 10:15 10:15 ..............

so on as many punches as employee punches in a day ...



so is there anyway to generate columns randomly as based on my total number of punches (If i punch a total of 10 in a day it should display punches from first to ten randomly..)


Please help me guys...

Thanks ,
Kiran