Your can use ODBC.
"Sommai Fongnamthip" <[EMAIL PROTECTED]> wrote in message
[EMAIL PROTECTED]">news:[EMAIL PROTECTED]...
> 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
>
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]