读书人

php中mysql兑现数组式条件查询

发布时间: 2012-09-29 10:30:01 作者: rapoo

php中,mysql实现数组式条件查询

$answer_username=$dblink->mem_fetch_array("SELECT uid FROM `cy_member` WHERE username LIKE '%".$_GET ['answername']."%'");$anser_ids='';foreach ($answer_username as $answer_username){$anser_ids.="".$answer_username['uid'].",";}$anser_ids=rtrim($anser_ids,',');if($anser_ids){$answernamestr ="…… where q.answername like '%" . $_GET ['answername'] . "%' or q.auid in ($anser_ids)" : '';

读书人网 >Mysql

热点推荐