01-21-12, 04:47 #1Registered User
- Join Date
- Jan 2012
Unanswered: Using Mysql & PhpRunner how to create a report.
This is my first post on this nice site..
I'm using PHP Runner to create report for below query.....
cast(group_concat(punch_time) as char) AS punches
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...