P PHTech Senior Member Joined Aug 21, 2006 Messages 588 Reaction score 0 Location Witbank Jul 31, 2008 #1 Hi there... Do you guys have any information on how to create a MySQL Crosstab query which I can use on of of my PHP intranet sites...?
Hi there... Do you guys have any information on how to create a MySQL Crosstab query which I can use on of of my PHP intranet sites...?
K koffiejunkie Executive Member Joined Aug 23, 2004 Messages 9,754 Reaction score 998 Location Australia Aug 9, 2008 #2 Like so.
P PHTech Senior Member Joined Aug 21, 2006 Messages 588 Reaction score 0 Location Witbank Aug 11, 2008 #3 Thanx... I have managed to figure it out by doing the combined SUM/IF function with a COUNT on the totals. THANX..!
Thanx... I have managed to figure it out by doing the combined SUM/IF function with a COUNT on the totals. THANX..!