必須在查詢準備時間定義樞軸查詢的列數。 To achieve dynamic cross-tabulation, you have two options that involve writing application code:

Option 1: Query Distinct Values and Construct Dynamic SQL

Create an array of SQL fragments representing the maximum對於每個不同維度值的時間。

; $ way_array [] =“ max（if（`way` = $ way，`time'））為way_ $ way'; } $ pivotsql =“ select stop”。加入（“，”，$ Way_array）。 “從`fore of'of`of ot ot ot of ot ot of ot o of ot o of ot o';

example：; 如果（！array_key_exists（$ stopkey，$ stoparray））{ $ stoparray [$ stopkey] = array（“ stop” => $ stopkey）; } $ waykey =“ way_”。 $ row [“ Way”]; $ stoparray [$ stopkey] [$ waykey] = $ row [“ time”]; }