displaying data problem

[stradnus]

Hi!

I have a hard time to solve this out...

any help is much appreciated.

this is part of my sales view table:

year--- month--customer--itemcode--amount
2006---Oct------sungold------T15-------150
2006---Nov-----sungold------T15-------100
2006---Dec-----sungold------T15-------340
2006---Oct---diamondstar-----T15-------250
2006---Nov---diamondstar-----T15-------300
2006---Dec---diamondstar-----T15-------400
2006---Oct------sungold------K33-------450
2006---Nov-----sungold-------K33-------700
2006---Dec-----sungold-------K33-------840
2006---Oct---diamondstar-----K33-------850
2006---Nov---diamondstar-----K33-------900
2006---Dec---diamondstar-----K33-------980

and this is what I would like to display the information:

----------------item code.......and more...
-----------------month......and more...
customer------amount

------------------------T15--------------------------K33---------
-------------------Oct---Nov---Dec---------Oct---Nov---Dec
sungold---------150--100---340---------450--700----840
diamondstar---250--300---400---------850--900----980

please help. thanks in advance.

[leatherback]

Hi Stradnus,

you have to be more clear about what you are asking.
First off..

Where is the problem:
-> SQL - retrieval?
-> Processing of database output
-> HTML formatting?

Second:
What is the general pattern of how you want data exported

third:
What have you tried, and how did it fail>

[stradnus]

for contrast:

-this is my sql statement:
"select year,month,customer,itemcode,amount from sales_table";

-and the database output:
year--- month--customer--itemcode--amount
2006---Oct------sungold------T15-------150
2006---Nov-----sungold------T15-------100
2006---Dec-----sungold------T15-------340
2006---Oct---diamondstar-----T15-------250
2006---Nov---diamondstar-----T15-------300
2006---Dec---diamondstar-----T15-------400
2006---Oct------sungold------K33-------450
2006---Nov-----sungold-------K33-------700
2006---Dec-----sungold-------K33-------840
2006---Oct---diamondstar-----K33-------850
2006---Nov---diamondstar-----K33-------900
2006---Dec---diamondstar-----K33-------980

-my problem is how to display the same output in the web browser using php by following the format below:

---------------------T15--------------------K33-------
--------------Oct--Nov--Dec----------Oct--Nov---Dec
sungold-------150--100---340---------450--700----840
diamondstar---250--300---400---------850--900----980

please help. thanks in advance.

[leatherback]

hm...

Bit confused by the months... Are there only 3 months per year?

Anyway.. I think this is easiest solved along these lines, unless you are sure that each customer will always a value for each months/cust/year code... then you can just echo each item, and place a <br> when a new customer is read.

// Sort your query, so you ge the data in a usefull order
$query = "select year,month,customer,itemcode,amount from sales_table
  order by customer, itemcode, month";
$result  = mysql_query($query);
$lastcustomer = ""
while($row = mysql_fetch_array($result))
  {
  if($row['customer'] <> $lastcustomer)
    {
    if($lastcustomer <> "")
      {
      echo $lastcustomer;
      echo implode($months, '---');
      }
    // (re) create an empty output array
    $months = array(
    'year'=> '',
    'T15' => array('Oct'=>'', 'Nov'=>'', 'Dec', =>''),
    'K33'=> array('Oct'=>'', 'Nov'=>'', 'Dec', =>''));    

    }

  $months[year] = $row['year'];
  $months[$row['itemcode']][$row['month']] = $row['amount'];
  }