Nested Query mysqli

Question

I am trying to execute a nested query which is failing using mysqli::query method. The query works perfectly on mysql command prompt.

Here is the relevant piece of code:

$select_records = "SELECT c.creative_id
                        FROM creatives AS c
                        WHERE c.creative_id NOT
                        IN (
                            SELECT tr.creative_id
                            FROM  `term_relationships` AS tr
                            INNER JOIN  `terms` AS t ON t.term_id = tr.term_id
                            WHERE t.taxonomy =  'category'
                        )
                        ORDER BY c.creative_id ASC ";
$res = $this -> mysqli_connect -> query($select_records);

$res yields false

How to do this? Thanks.

Does this answer your question? mysqli_fetch_assoc() expects parameter / Call to a member function bind_param() errors. How to get the actual mysql error and fix it? — Dharman
– Dharman ♦, Commented May 1, 2020 at 15:59

ScaisEdge · Accepted Answer · 2015-12-09 06:59:16Z

2

try testing in this way

$mysqli = new mysqli("my_host", "my_user", "my_password", "my_db");

$select_records = "SELECT c.creative_id
                    FROM creatives AS c
                    WHERE c.creative_id NOT
                    IN (
                        SELECT tr.creative_id
                        FROM  `term_relationships` AS tr
                        INNER JOIN  `terms` AS t ON t.term_id = tr.term_id
                        WHERE t.taxonomy =  'category'
                    )
                    ORDER BY c.creative_id ASC ";

if ($result = $mysqli->query($select_record)) {
  printf("Select returned %d rows.\n", $result->num_rows);
} else {
  printf("Problem with Query");
}

answered Dec 9, 2015 at 6:59

ScaisEdge

133k10 gold badges98 silver badges111 bronze badges

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

1 Comment

Gerald Schneider Over a year ago

And if you want to know what's actually wrong use printf("Problem with SQL Query: %s", $mysqli->error);.

hvs · Accepted Answer · 2015-12-09 08:06:56Z

0

I made a stupid error. I was connecting to a different database than the one I intended. Hence the error. Sorry for the trouble.

answered Dec 9, 2015 at 8:06

hvs

5361 gold badge7 silver badges22 bronze badges

Collectives™ on Stack Overflow

Nested Query mysqli

2 Answers 2

1 Comment

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related