Getting Empty array on INNER query in MySQL

Question

I am a newbie in PHP/MySQL and this is my first question on stackoverflow, so please ignore any mistake if I have made any.

I am trying to get records from a table through this query.

$CId = $this->input->post('Child_id'); //child_id is the value from a textfield

$r_detail = ("SELECT *
            FROM `result_details`
            WHERE ResultId
            IN (SELECT Result_Id
            FROM `results`
            WHERE childId = '".$CId." ')  " );

this query is returning an empty $r_detail. However when I query the same statement in PHPMyAdmin in localhost and change "$CID" to a number, I get the desired records.

Any Help will be much appreciated.

Are you using codeigniter??

Saty
– Saty

2015-06-03 07:27:36 +00:00
Commented Jun 3, 2015 at 7:27 — Saty
– Saty, Commented Jun 3, 2015 at 7:27

cjhill · Accepted Answer · 2015-06-03 07:28:46Z

1

You have a space in INNER JOIN WHERE: '".$CId." ' should be '".$CId."'.

answered Jun 3, 2015 at 7:28

cjhill

1,0842 gold badges11 silver badges31 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Danyal Sandeelo · Accepted Answer · 2015-06-03 07:28:56Z

0

   $r_detail  = ("SELECT *
        FROM `result_details`
        WHERE ResultId
        IN (SELECT Result_Id
        FROM `results`
        WHERE childId = '".$CId." ')  " );

has just string...you need to call some db function to get the data such as in code igniter may be

  $this->db->query($r_detail);

answered Jun 3, 2015 at 7:28

Danyal Sandeelo

12.4k10 gold badges57 silver badges90 bronze badges

Collectives™ on Stack Overflow

Getting Empty array on INNER query in MySQL

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related