echo "<td>"; $widconn->query_class($dbname2, $_SESSION[cat], $_SESSION[ques]); echo "<br><br>"; if (isset($_SESSION[ques]) || $_POST[q_submit]) { unset($_SESSION["arr_px_labels"]); $widconn->query_cat($dbname, $dbname2, $_POST[sdate], $_POST[edate], $_POST[sel_brgy], $_POST[sel_hidden_value]); } echo "</td>"; //echo "<td valign=\"top\">"; /*if(isset($_SESSION[ques]) || $_POST[q_submit]): $widconn->query_cat($dbname,$dbname2,$_POST[sdate],$_POST[edate],$_POST[sel_brgy]); endif; */ echo "<td>"; //upon setting filters, set the necessary sessions here if ($_POST[q_submit]) { $queryconn->clean_db(); // set the session for start date and end date if ($_SESSION[filter] == 1) { $queryconn->querycrit($dbname, $dbname2, $_POST[sdate], $_POST[edate], $_POST[sel_brgy], $_POST[sel_fp_method]); } elseif ($_SESSION[filter] == 2) { //summary tables $_SESSION[smonth] = $_POST[smonth]; $_SESSION[emonth] = $_POST[emonth]; $sdate = strftime("%m/%d/%Y", mktime(0, 0, 0, $_POST[smonth], 1, $_POST[year])); $edate = strftime("%m/%d/%Y", mktime(0, 0, 0, $_POST[emonth] + 1, 0, $_POST[year])); $queryconn->querycrit($dbname, $dbname2, $sdate, $edate, $_POST[brgy], 0); //the fifth argument when set to zero, means that there is no form present in the query box } elseif ($_SESSION[filter] == 3) { //quarterly tables $arr_start_end = array('1' => array('01/01', '03/31'), '2' => array('04/01', '06/30'), '3' => array('07/01', '09/30'), '4' => array('10/01', '12/31')); $sdate = $arr_start_end[$_POST[sel_quarter]][0] . '/' . $_POST[year];