| 我现在想要设定一个参数$newsubcate，它有4个取值，不同的值跟不同的条件，我尝试着在帆软数据库查询里面写了下面这个语句，但是错了，不知道正确的应该怎么写？ ${if(newsubcate='1',"and (newsubcate_id = '1' and subcate_id in ('63','64','66','67')) or (newsubcate_id = '0' and subcate_id = '67')",if(newsubcate='2',"and (newsubcate_id = '2' and subcate_id in ('63','64')",if(newsubcate='3',"and (newsubcate_id = '3' and subcate_id in ('63','64','67')",if(newsubcate='4',"and (newsubcate_id = '4' and subcate_id in ('63','64')",""))))} |
