MySQL pivot table query with dynamic columns

See more:

MySQL

Hi,

I have a Table. looks something like this:


Employeename|Details |AttendanceDates|

========================================

Benjie |124 |2013.09-20|

Benjie |345 |2013.09-20|

Benjie |356 |2013.09-21|

Benjie |466 |2013.09-21|

Benjie |517 |2013.09-22|

Benjie |912 |2013.09-22|

Hannah |102 |2013.09-22|

Hannah |97 |2013.09-21|

Rose |251 |2013.09-21|

Rose |297 |2013.09-22|

Rose |302 |2013.09-20|

Rose |364 |2013.09-20|



and I want my list to show like this:


Employeename|2013.09-20|2013.09-21|2013.09-22|

===========================================================

Benjie |124 |345 |356 |466

Hannah |102 |97 | | | | |

Rose |251 |297 |302 |364

can anyone here show how to do this?