I have a pivot table that outputs the following result set:
as you can see column names are 0.9,1.2,1.5 etc etc
in my php, I cant reference the number
echo $order->a;
I get error:Parse error: syntax error, unexpected T_DNUMBER, expecting T_STRING or T_VARIABLE
How can I correctly fetch this column or perhaps adjust the sql to have an alias? like a or b? like:
select * from t pivot ( avg(stock) for length in ([0.9] as a, [1.2] as b)) piv
Thanks as always,