<?php
-$script = $_SERVER['SCRIPT_NAME'].'/assistant/stats';
$month=date('Y-m');
$month_sql='';
if(isset($_GET['month'])) {
}
?>
-<form action="<?=$script?>/" method="GET">
+<form action="<?=$URL?>/" method="GET">
YYYY-MM: <input type="text" name="month" autofocus value="<?=$month?>" />
<input type="submit" value="SELECT BY MONTH" />
</form>
foreach($queries as $description => $sql) {
echo "<h2>$description</h2>";
- echo $this->html->render_item_table($result = $this->db->safe_query($sql)->fetchAll(PDO::FETCH_ASSOC));
+ echo $this->html->render_item_table($result = $this->db->safe_query_fetch($sql));
}