Go4Expert - print values in order

Go4Expert (http://www.go4expert.com/)

- PHP (http://www.go4expert.com/forumdisplay.php?f=26)

- - print values in order (http://www.go4expert.com/showthread.php?t=16271)

print values in order

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.

Re: print values in order

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.

Re: print values in order

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.