查询我写的phpmyadmin工作正常,不能用我的代码[关闭]

the query i want to execute

  "select * from `users` where `paid`= '0' and `experience_with`= 'baby_1_3' and `active`=1 and `type`='job_searcher'" 

i use codeigniter so o to execute i write

  print $query.$condition; //to see the query
$query = $this->db->query($query.$condition);
$result = $query->result();
return $result;

there are no errors just select all users

$query = mysql_query( "select * from users where paid= '0' and experience_with= 'baby_1_3' and active=1 and type='job_searcher'"); $result = mysql_fetch_assoc($query); print_r($result);