Database Query to Wordpress Database Returns a Count, not Rows

Question

I have the follow query I'm making to a MySQL database, for a Wordpress website:

global $wpdb; 

/*get time slots*/
$query = "
    SELECT DISTINCT routes.route_date, time_slots.name, time_slots.openings, time_slots.appointments
    FROM routes
    INNER JOIN time_slots ON routes.route_id = time_slots.route_id
    WHERE route_date
    BETWEEN 20140110
    AND 20140227 
    ORDER BY route_date, name
    "; 
$time_slots = $wpdb->query($query);

However the value of $time_slots is 245. Just a number. I don't know why. When I make the query in phpmyadmin, using the exact query, I get the expected results.

What am I doing wrong here and how can I get the array I'm expecting.

Please stop creating [database-query]. It is entirely unnecessary. We already have tags to cover the concept of database queries. Your question already has those tags. — Charles
– Charles, Commented Jan 11, 2014 at 8:09
Didn't realize it was that big of a deal. Maybe you can send me a list of tags you've approved. — BlackHatSamurai
– BlackHatSamurai, Commented Jan 11, 2014 at 8:10
Duplicate tags are a big deal! Tags are here to help categorize questions. If people pick the "wrong" one of a set of tags that are effectively the same, they risk not having their question found. — Charles
– Charles, Commented Jan 11, 2014 at 23:33

Rajendra Yadav · Accepted Answer · 2014-01-11 06:44:51Z

1

use for all record

$time_slots = $wpdb->get_results($query);

use for fetch row

$time_slots = $wpdb->get_var($query);

answered Jan 11, 2014 at 6:44

Rajendra Yadav

6353 silver badges12 bronze badges

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

Comments

BlackHatSamurai · Accepted Answer · 2014-01-11 07:29:09Z

1

Well you are right

  <?php $result = $wpdb->query('query'); ?>

$result will contain the number of rows affected, not the results

do this instead:

          $result =  $wpdb->get_results($query);

edited Jan 11, 2014 at 7:29

BlackHatSamurai

23.6k22 gold badges100 silver badges160 bronze badges

answered Jan 11, 2014 at 6:47

sanjeev

4,6512 gold badges22 silver badges28 bronze badges

1 Comment

BlackHatSamurai Over a year ago

$wpdb is the global variable to access the Wordpress database. It has nothing to do with the number of affected rows.

user2385712 · Accepted Answer · 2014-01-11 07:03:50Z

-1

function wpse_footer_db_queries(){ echo ''.PHP_EOL; } add_action('wp_footer', 'wpse_footer_db_queries');

answered Jan 11, 2014 at 7:03

user2385712

493 bronze badges

Collectives™ on Stack Overflow

Database Query to Wordpress Database Returns a Count, not Rows

3 Answers 3

Comments

1 Comment

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Related