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]