Forum Discussion
Filter 2 columns at the same time in a table
Hi. Newbie here! I have been trying to figure out how to filter two columns at the same time. In this instance, I want to filter the "SPLIT SALES" and "SPLIT SALES 2" columns by "HIPPKE". Essentially...
I have to filter multiple persons at end of month. Is there an easier way to accomplish this?
https://e.anyoupin.cn/EData/1241.html
//select * from filter_multi_columns;
xli_add_php~～
if(!empty($_POST["tbl"])){
//print_r($_POST);
$tblrowid=implode(',',$_POST["tbl"]);
echo $tblrowid;
$sql=<<<eof
select * from filter_multi_columns where (instr("$tblrowid",f04)>0 and f04 not like "") or (instr("$tblrowid",f05)>0 and f05 not like "");
eof;
//echo($sql);
\multiquery\multiquery_run($sql);
}
?>
<form action="" method=post>
～;
select * from (
select f04,'<input type=checkbox name="tbl[]" value='||f04||'>' options from filter_multi_columns group by f04 union
select f05,'<input type=checkbox name="tbl[]" value='||f05||'>' 选择 from filter_multi_columns group by f05) where f04 not like '';
;
xli_add_php~～
?>
<button>submit</button>
</form>
～;