<?php |
<?php |
|
|
/*// most interesting |
/*// most interesting |
SELECT sum(heuristic_value) as sum, CNID |
SELECT sum(heuristic_value) as sum, CNID |
FROM `heuristic_results` group by CNID order by sum DESC limit 30 |
FROM heuristic_results group by CNID order by sum DESC limit 30 |
|
|
// spread of values |
// spread of values |
select floor(sum) as val,count(*) from (SELECT sum(heuristic_value) |
select floor(sum) as val,count(*) from (SELECT sum(heuristic_value) |
as sum FROM heuristic_results group by CNID) as a group by val*/ |
as sum FROM heuristic_results group by CNID) as a group by val*/ |
|
|
$series = Array(); |
$series = Array(); |
|
|
include_once("../lib/common.inc.php"); |
include_once("../lib/common.inc.php"); |
$query = "select heuristic_name, floor(heuristic_value) as val,count(*) from heuristic_results group by heuristic_name, val"; |
$query = "select heuristic_name, floor(heuristic_value) as val,count(*) from heuristic_results group by heuristic_name, val"; |
$result = $conn->query($query); |
$result = $conn->query($query); |
foreach ($result->fetchAll() as $r) { |
foreach ($result->fetchAll() as $r) { |
$series[$r["heuristic_name"]][$r["val"]] = $r[2]; |
$series[$r["heuristic_name"]][$r["val"]] = $r[2]; |
} |
} |
|
|
?> |
?> |