print values in order

divinequran's Avatar, Join Date: Oct 2008
Contributor
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.
Prasanna Gopal's Avatar, Join Date: Mar 2009
Newbie Member
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.
pete_bisby's Avatar, Join Date: Nov 2007
Go4Expert Member
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...-in-mysql.html) - there is a workaround .... a bit tedious, but possible.