Dispaly crosstab
Posted: Thu Nov 10, 2005 6:43 am
Hi,
Im totally new to php and need some help please.
I have a mssql table with the following data
Name Amount Month
------- ---------- --------
John 500.00 10/2005
Jack 600.00 11/2005
The result Im trying to get using php is :-
Name 10/2005 11/2005
------- ---------- -----------
John 500.00
Jack 600.00
I am total stupped I can get the column headings but I can't seem to get the amounts in the correct columns. Could some please point me in the write direct as my code now looks a complete mess with for,while etc.......
any help would be much appreciated
Thx.
Im totally new to php and need some help please.
I have a mssql table with the following data
Name Amount Month
------- ---------- --------
John 500.00 10/2005
Jack 600.00 11/2005
The result Im trying to get using php is :-
Name 10/2005 11/2005
------- ---------- -----------
John 500.00
Jack 600.00
I am total stupped I can get the column headings but I can't seem to get the amounts in the correct columns. Could some please point me in the write direct as my code now looks a complete mess with for,while etc.......
any help would be much appreciated
Thx.