Help on query report...
| From: | Suprie | Date: | Wed, 15 Nov 2006 06:28:15 +0000 |
| Subject: | Help on query report... | ||
| Groups: | php.db | ||
| Request: | Send a blank email to php-db+get-42695@lists.php.net to get a copy of this message | ||
dear all,
i have this table
id | contract No | site id | handover date |status| finishing date |
contract value|actual value
1 | T0001 | LOS01 | 12-Apr-06 | Done | 11-Apr-06 |
12,000 | 12,000
2 | T0002 | LOS02 | 12-Apr-06 | Done | 11 Apr-06 |
11,000 | 11,000
3 | T0001 | LOS02 | | Done | 13-Apr-06
| 13,000 | 13,000
4 | T0003 | LOS01 | | Cancel |
| 11,000 |
now my manager asked me to produce summary report like :
Contract No | TOTAL site | Total Cancelled | Total Active | Handovered
| Contract Value |
T0001 | 2 | 0 | 2
| 1 | 25,000 |
T0002 | 1 | 0 | 1
| 1 | 11,000 |
T0003 | 1 | 1 | 0
| 0 | 11,000 |
is there some way to do it in mySQL? i'm using php 5 and mysql 5.1
right now i'm doing it manually, but i thinks it was really
complex...Could somebody help me with the query ?
many thanks,
br
--
Jangan tanyakan apa yang Indonesia telah berikan pada mu
tapi bertanyalah apa yang telah engkau berikan kepada Indonesia
-----BEGIN GEEK CODE BLOCK-----
Version: 3.1
GU/IT d- s: a-- C++ UL P L++ E W++ N* o-- K-
w PS Y-- PGP- t++ 5 X R++ tv b+ DI D+ G e+ h* r- z?
------END GEEK CODE BLOCK------