sorting tables

From: Date: Fri, 03 May 2002 08:02:28 +0000
Subject: sorting tables
Groups: php.db 
Request: Send a blank email to php-db+get-18958@lists.php.net to get a copy of this message
Hi everybody I am doing a select in my oracle DB where i get some records. These records are grouped by product id, cost, etc, and amount sold every month. Then, i show all regs in a table, but as the ORDER BY is done also with the month / year, because i want to show how much every month is sold, it creates a new line even also the product is the same. Then i have my table with x times the same product, in every month column zero values except the amount for that month. Is there a way to show one product per row with every amount on every month column? Thx in advance

« previous php.db (#18958) next »