require_once "../pdefine.php"; $sqlStr="SELECT substr(seihin.bunrui,1,2) as 'dai',count(seihin.id) as 'kazu' from seihin inner join maker on seihin.makercode=maker.makercode ". "inner join tbl_bunrui on seihin.bunrui=tbl_bunrui.syokubun where media=3 and (maker.MAKERCODE!=20000 and maker.MAKERCODE!=20001 and maker.MAKERCODE!=20003 and maker.MAKERCODE!=20004) ". " and ifnull(viewfrom,now())<=now() and ifnull(viewto,now()) >=now() group by substr(seihin.bunrui,1,2)"; $rs = $mdb2jsia->queryAll($sqlStr); ?>