Displaying 1 result from an estimated 1 matches for "dim_array_".
2006 Jun 15
3
Can I call MySql statements directly??
...this:
SELECT a, b, DAYOFWEEK(date_time) as DOW,
HOUR(date_time) at hr,
AVG(x/y)
FROM records;
This is possible by creating a 3-dimentional array of a, b, date_time
containing x/y, and then finding averages and putting it into a
4-dimensional array of a, b, dow, and hr.
_3-dim_array_
a
b
date_time
_4-dim_array_
a
b
dow
hr
My reasons for not wanting to do it this way is that there could be
100,000+ records. Also, look at how pretty and compact that the MySql
statement is! I would much rather let MySql handle all that because
arrays will get very big, and I''...