zhjceltegqta
New Member
Hi how do i group this data:\[code\]**Date** **Day** **DURATION** **IDSTAFF**21-09-2010 Sun AM 1 22-09-2010 Mon AM 1 21-09-2010 Sun PM 2 22-09-2010 Mon PM 2 \[/code\]So it will become like this?\[code\]**Date** **Day** **DURATION** **IDSTAFF**21-09-2010 Sun AM 1 (am),2 (pm) 22-09-2010 Mon AM 1 (am),2 (pm)\[/code\]Using sql group by will only show one id staff. Can sql queries solve this or need to use php?