Re: cross tab with mssql
| From: | amtd | Date: | Fri, 21 Sep 2001 08:03:17 +0000 |
| Subject: | Re: cross tab with mssql | ||
| References: | 1 | Groups: | php.db |
| Request: | Send a blank email to php-db+get-12630@lists.php.net to get a copy of this message | ||
Your can use ODBC.
"Sommai Fongnamthip" <sommai@thaithanakit.co.th> wrote in message
news:5.1.0.14.2.20010921124443.022a25a0@langsuan.thaithanakit.co.th...
> 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 1000
>
> This is the result I need.
> Customer# 21/9/2001 22/9/2001 23/9/2001
> ---------------------------------------------------------------
> A12345 1000 1000 1000
> B56789 1000 1000
>