不好意思发错重新发一下: select m.userid,m.username,m.sex,m.nation from members m where m.interest like '%d%' or m.interest like '%m%' and m.sex=$sex
$query = "select m.userid, m.username, m.sex, m.nation from members as m where (m.interest like '%d%' or m.interest like '%m%') and m.sex='" . $sex . "'";
select m.userid,m.username,m.sex,m.nation from members m where m.interest like '%d%' or m.interest like '%m%' and m.sex=$sex
from members as m
where (m.interest like '%d%' or m.interest like '%m%')
and m.sex='" . $sex . "'";
如果or不加括号的话,则不管m.sex的值是什么,只要他符合m.interest的一个就会被选出
如果sex不是数值型的话,还要加个单引