How to put data to array and search by specifically row?
I query from mytable like this.
I want to put it in array(PHP) and search like this
$index = 15;
$result = array_search(...)..); <--- age_range
and put that row ($result) to new array i created; Or somebody hav better
idea. Sorry some stupid question. Thank for help.
query
SELECT
CONCAT(2 * FLOOR(age / 2), '-', 2 * FLOOR(age / 2) + 5) AS 'age_range',
SUM(gload1) AS 'g1',
SUM(gload2) AS 'g2',
SUM(gload3) AS 'g3',
SUM(gload4) AS 'g4',
SUM(gload5) AS 'g5',
SUM(gload6) AS 'g6',
SUM(gload7) AS 'g7',
SUM(gload8) AS 'g8',
SUM(gload9) AS 'g9',
SUM(gload10) AS 'g10'
FROM
member
GROUP BY 1
ORDER BY age ;
No comments:
Post a Comment