Hii Guido ..
Yes, am using PHP Runner, But thois is the first time am using it...
I have tried this 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
Username | Date | first_punch | second_punch | third_punch | fourth_puch ....
1) kiran 2012-01-20 09:00:10 09:10:15 10:15:10 11:00 ..............
My tool (PHP Runner) doesnt allow me to create new rows while it takes columns from table (attendance) so it gives me report like this
Username | Date | Punch_time
not more than these columns i cant create while generating a report...
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..)
All these are for display purpose only i dont need to do any operations on my table...(On front end i have to display my punches on report no action on my table)
Pls help me..