Take the 2-minute tour ×
WordPress Development Stack Exchange is a question and answer site for WordPress developers and administrators. It's 100% free, no registration required.

I'm going to write a function to return the next/prev post in a specific category. can anyone tell me what the differences would be in using $wpdb as opposed to WP_Query(); eg new WP_Query(args)? what determines which of these should be used?

cheers,
Gregory

share|improve this question

3 Answers 3

up vote 1 down vote accepted

The wpdb class is the interface with the database. WP_Query uses wpdb to query the database. You should use WP_Query when dealing with the native WordPress tables, to integrate your code properly with the WordPress environment. Use wpdb directly when you need to access data in your own tables.

share|improve this answer

with a background in relational database development, what I needed was a guide to SQL. I finally found one I could relate to allowing me to understand the utility of $wpdb.

it would appear that using $wpdb is preferable to WP_Query if one is familiar with relational database design and SQL, and wants to keep database access as efficient as possible as long as one adheres to the safety precautions regarding data validation/preparation.

I'll play around with the $wpdb class/functions and move forward from there.

share|improve this answer
    
That’s not answer, is it? You should update your question if you want to add further details. –  toscho Jun 4 '12 at 16:57

Pay attention that wp_query() doesn't exist in WP core, so I think almost nobody of us can tell you what is it.

$wpdb is object of the wpdb class, which provides ability to prepare and run database queries.

I'm going to write a function to return the next/prev post in a specific category

Use next_post_link/previous_post_link functions to do it.

Updated: To better understand when you have to use WP_Query read this thread When to use WP_query(), query_posts() and pre_get_posts

share|improve this answer
    
can't use next_post_link(). they don't allow one to specify a single category, something that most people mentioning these functions tend to ignore... although one could perhaps get all of the terms for the current post and exclude all of them except for the one needed... worth considering. btw, wp_query() is documentated here: codex.wordpress.org/Class_Reference/WP_Query –  Gregory May 31 '12 at 14:30
    
@Gregory pay attention that you made a mistake in your question: you wrote wp_query() - it is a function. But WP_Query is a class. It's big different. –  Eugene Manuilov May 31 '12 at 14:39
    
thank you for the clarification. still, does anyone know when one should use $wpdb as opposed to WP_Query ? I've done quite a few searches on the 'net but haven't found any answers, at least as far as queries go rather than updates/inserts/deletes. –  Gregory Jun 1 '12 at 3:25
    
@Gregory I have updated my answer, check it out. –  Eugene Manuilov Jun 1 '12 at 4:59

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.