|
|
Posted by ZeldorBlat on 11/11/05 02:09
One way is to fetch the row as a numerically-indexed array and use the
numeric keys. The preferred (and much better) way is to alias the
column names in your query. So something like this:
CLNT_STATS_YTD.Vol_Collected as YTD_Vol_Collected
CLNT_STATS_MTD.Vol_Collected as MTD_Vol_Collected
CLNT_STATS_TD.Vol_Collected as TD_Vol_Collected
Then, when you fetch the result, you can refer to the columns as
YTD_Vol_Collected, MTD_Vol_Collected, etc.
Navigation:
[Reply to this message]
|