Hi,

I have selected mysql database table values as following

Code:
client    amount month      year

joe       $50    January    2005
nick      $52    Feburary   2005
rubble    $49    march      2005
nick      $52    January    2005
nick      $52    March      2005
rubble    $42    Feburary   2005
joe       $30    January    2006
nick      $32    Feburary   2006
rubble    $39    march      2006
som       $39    April      2006
joe       $25    January    2006
nick      $22    Feburary   2006
rubble    $19    march      2006
som       $19    April      2006
joe       $52    Feburary   2005
joe       $52    march      2005
rubble    $40    January    2005
I want the above values to print as
Code:
2005        Joe   Nick  rubble  

January     $50    $52   $49
Feburary    $52    $52   $40 
March       $52    $52   $40
and so on for each year in different table. The year as field type for month and client as field type for amount.