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.
The best practice in databases is to always have date field in one single field. By separating the month field, you have lost ability to sort or group them by date, and this is what is causing this to be a nightmarish problem. Make this change and the problem will become much simpler.
No, what divinequran is actually after is a crosstab query .... unfortunately, MySQL cannot do them "natively". Have a look at the following URL (http://rpbouman.blogspot.com/2005/10/creating-crosstabs-in-mysql.html) - there is a workaround .... a bit tedious, but possible.