PHP+MySQL多条件检索

SELECT a.byear,a.bname,b.tname FROM data as a left join teacher on a.tid=b.tid where a.bname like '%xxxx%' and a.byear='xxxx' and b.tname like '%xxxx%'

你的condition 只是where条件而已

依旧可以用，只不过，应该把内容中byear改成a.byear,tname 改成b.tname

SELECT a.*,b.tname FROM data as a left join teacher on a.tid=b.tid ".$condition." order by a.bid

用循环吧

比如，输入了$str="a,b,c"

$arrs = expode(",",$str)

for($i=1$i<count($arrs)$i++){

$sql="select * from student where name like ''%'".$arrs[$i]."%'"

$r = mysql_query9$sql)

if($r){

}else{

}

}

不知道你看 明白了没有。

---