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]

Reply via email to