You can use AND and OR statements in MySQL. Try this: $count = $wpdb->get_var( “SELECT COUNT(*) FROM $wpdb->posts $where AND (post_status=”publish” OR post_status=”draft”)” );
Several things, Firstly you can add the following for pagination: ‘paged’ => ( get_query_var(‘paged’) ? get_query_var(‘paged’) : 1 ) This removes the need for the array_merge. Otherwise your existing code is fine except for some indentation. I would add the rest of the query though, e.g. defining the post type, the posts per page, etc
Instead of querying the database directly you could use the following code instead. printf( ‘<p>Total views : %s</p>’, get_post_meta( get_the_ID(), ‘views’, true ) );
A few things I would do/add/change: Instead of using a query function directly I would use $wpdb->get_results Second, $wpdb->num_rows will work now. Third: setup_postdata() is what you need to actually make use of the query outside of a loop. This means get_post(get_the_ID()) doesn’t apply to anything as there is no existing $post-ID to reference. I … Read more
its normal for get_results method you can use get_row method to get only one row.
Because you’re missing second argument, for more information see this post – http://make.wordpress.org/core/2012/12/12/php-warning-missing-argument-2-for-wpdb-prepare/. Also you’re doing it wrong, for security reason you shouldn’t pass variables into query directly that’s why you should use prepare() method – see Codex for usage info.
This is a SQL problem. Your query is wrong. You forgot to include the term_relationships table in the query, yet reference it during the JOIN. By including the term_relationships table, that would solve the problem with the query. SELECT ID, post_title, post_content, post_date FROM {$wpdb->posts} AS p JOIN {$wpdb->term_relationships} AS tr ON tr.object_id = p.id … Read more
Copy and paste this function into the function.php file under current theme. // Create a new filtering function that will add where clause to the query function filter_where( $where=”” ) { // posts in the last 30 days $where .= ” AND post_date > ‘” . date(‘Y-m-d’, strtotime(‘-30 days’)) . “‘”; return $where; } Paste … Read more
you doing something wrong your $result query returns multidimensional array of rows and each row has an array of keys values, try this, not tested but will work. <?php global $wpdb; $result = $wpdb->get_results ( “SELECT * FROM $wpdb->forms” ); foreach ( $result as $key => $row ) { echo $row->ID.'<br/>’; } ?>
$wpdb is a relatively simple wrapper around PHP’s mysql functions. If you can do it with PHP/SQL then you can do it with $wpdb. You’re question is not detailed or specific enough to afford a more detailed answer though. Nor is it detailed enough to say whether $wpdb is the best, or even an acceptable` … Read more