Wordpress database query not returning results

Question

apologies that this is very basic stuff but would really appreciate some help. I am trying to query a table in my Wordpress database by adding the following to my child theme's functions.php

$myresults = $wpdb->get_results("SELECT id FROM wp_my_table WHERE user_id=1");

I am trying to view the results of the query by adding

<?php
    var_dump($myresults);
?>

to one of the pages on my website, but it just displays 'NULL'. I have checked using phpMyAdmin and wp_my_table definitely exists, and contains entries where user_id=1. Any ideas?

Ozan Kurt · Accepted Answer · 2014-07-17 23:27:55Z

1

not get_results!!! query

$wpdb->get_results(...

to

$wpdb->query(...

answered Jul 17, 2014 at 23:27

Ozan Kurt

3,8634 gold badges22 silver badges36 bronze badges

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

4 Comments

user1684046 Over a year ago

Not working unfortunately - the var_dump still displays 'NULL'

user1684046 Over a year ago

Sorry but I'm not sure what that means!

Ozan Kurt Over a year ago

Send the part of the code where you connect to the database

user1684046 Over a year ago

I thought I didn't have to open a separate DB connection with $wpdb? The rest of the website works great so the database connection must be fine I guess? I have tried adding global $wpdb; before my code but that doesn't work either

user1684046 · Accepted Answer · 2014-07-18 00:17:16Z

0

Sorry, I missed something obvious - the scope of the $myresults variable didn't extend to the page I was performing the var_dump on!

answered Jul 18, 2014 at 0:17

user1684046

1,9792 gold badges14 silver badges17 bronze badges

Collectives™ on Stack Overflow

Wordpress database query not returning results

2 Answers 2

4 Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

4 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related