Doing $wpdb->get_results returns NULL, doing the same query in my DB returns correct value

Question

I have this query to do in my code:

  function get_item($id){
    global $wpdb;

    $post_id_query = "SELECT * FROM wp_postmeta WHERE post_id = ". $id ." AND meta_key LIKE '%main%'";
    $call_post_id_call = $wpdb->get_results($wpdb->prepare($post_id_query));

    return $call_post_id_call;
  }

  $main_item = get_item(34487);

If I run SELECT * FROM wp_postmeta WHERE post_id = 34487 AND meta_key LIKE '%main%' on my DB it works...

I'm not very keen on wordpress to be honest.

Try to run print $wpdb->last_query; before the return call and check the exact query being executed. Also, couldn't see any issues in the script, it should work if the query works in you DB. — Karthick
– Karthick, Commented Apr 29, 2020 at 15:06

Karthick · Accepted Answer · 2020-04-29 15:15:01Z

0

The following script will help you to identify if there any error exists in the query.

$wpdb -> show_errors ();
$call_post_id_call = $wpdb->get_results($wpdb->prepare($post_id_query));
$wpdb -> print_error ();

answered Apr 29, 2020 at 15:15

Karthick

2461 silver badge7 bronze badges

Add a comment |

Stack Exchange Network

Doing $wpdb->get_results returns NULL, doing the same query in my DB returns correct value

1 Answer 1

Your Answer

Hot Network Questions

Doing $wpdb->get_results returns NULL, doing the same query in my DB returns correct value

1 Answer 1

Your Answer

Sign up or log in

Post as a guest

Related

Hot Network Questions