php - Getting Empty array on INNER query in MySQL -

i newbie in php/mysql , first question on stackoverflow, please ignore mistake if have made any.

i trying records table through query.

$cid = $this->input->post('child_id'); //child_id value textfield  $r_detail = ("select *             `result_details`             resultid             in (select result_id             `results`             childid = '".$cid." ')  " ); 

this query returning empty $r_detail. when query same statement in phpmyadmin in localhost , change "$cid" number, desired records.

any appreciated.

you have space in inner join where: '".$cid." ' should '".$cid."'.