cross tab with mssql
| From: | Sommai Fongnamthip | Date: | Fri, 21 Sep 2001 05:50:06 +0000 |
| Subject: | cross tab with mssql | ||
| Groups: | php.db | ||
| Request: | Send a blank email to php-db+get-12629@lists.php.net to get a copy of this message | ||
Hi,
I was used MS Access to make cross tab query with MS SQL. How could I do this with PHP? I was used syntax of MySQL but It did not work.
Thank you,
SF
This is an example data:
Customer# Bill date Bill amount-----------------------------------------------
A12345 21/9/2001 1000 B56789 21/9/2001 1000 A12345 22/9/2001 1000 A12345 23/9/2001 1000 B56789 23/9/2001 1000This is the result I need.
Customer# 21/9/2001 22/9/2001 23/9/2001---------------------------------------------------------------
A12345 1000 1000 1000 B56789 1000 1000