php中,mysql兑现数组式条件查询
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)" : '';