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?](https://stackoverflow.com/questions/22662488/mysqli-fetch-assoc-expects-parameter-call-to-a-member-function-bind-param) — Dharman, May 01 '20 at 15:59

score 2 · Answer 1 · answered Dec 09 '15 at 06:59

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");
}

And if you want to know what's actually wrong use `printf("Problem with SQL Query: %s", $mysqli->error);`. — Gerald Schneider, Dec 09 '15 at 08:14

score 0 · Answer 2 · answered Dec 09 '15 at 08:06

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 09 '15 at 08:06

hvs

518
1
5
21

Nested Query mysqli

2 Answers2