I’m trying to retrieve information on my database. I wanted to display all pages using this statement, but I’m getting a blank ARRAY global $wpdb; $result = $wpdb->get_results ( ” SELECT * FROM $wpdb->wp_posts WHERE post_type=”page” ” ); echo $result; // display data Output: ARRAY EDIT: After changing below suggestions, I’m now using this. but … Read more
i want to retrieve custom posts using using custom query . my taxonomy is recipe_tx and terms (Beef) , (Chicken) etc in it . i have tried using SELECT p.* FROM wp_posts p, wp_term_taxonomy tt, wp_term_relationships tr WHERE p.ID=tr.`object_id` AND tt.`term_id`=tr.`term_taxonomy_id` AND (p.post_type=”recipe_cpt”) AND p.post_status=”publish” AND tt.`term_taxonomy_id` = 37 but no luck . can someone … Read more
In the Reading Settings, there is place to set the number of posts shown that affects the number of posts shown in all contexts. I’d like to show instead a certain number of posts on the homepage, and a different number of posts on pages like archive, search results, etc. I realize I could do … Read more
I’m aware there are several other posts that cover similar ground to what I’m about to ask. I have three custom post types running, in addition to ‘posts’. I want to run a loop that pulls all posts categorised under a particular category <?php $args = array( ‘post_type’ => ‘testimonial’, ‘posts_per_page’ => 1, ‘tax_query’ => … Read more
@toscho left a comment to this answer which had me thinking again. How much trust should we have in the global scope, specially regarding the post globals like $post? So what? The global variable can be overwritten from everyone before your check runs. That’s the point of global variables: global access. $post for instance is … Read more
I have read countless posts on ordering data by numeric value ( as opposed to string – it i have a numeric meta value and it gets ordered like this 1 11 12 2 233 etc as opposed to the way i want it I am using WP_Query have tried using meta_query => ‘NUMERIC’ but … Read more
I am using wordpress 3.2 and I did a query post like this: <?php query_posts(“posts_per_page=1post=type&page=post_parent=10”);?> Then I try to echo out the date of this post I queried like this. <?php echo the_date(); ?> It gives me the title of the post and the excerpt and the permalink but no date. What do you think … Read more
I’m working on a website for a company that will very likely be creating millions of posts via a custom post type. They’re prayers, so basically the user on the front end just submits a short phrase via a form. All the company cares about is the post content and the date posted. The site … Read more
How to query for mutiple meta key values with the same key $querystr = ” SELECT $wpdb->posts.* FROM $wpdb->posts, $wpdb->postmeta WHERE $wpdb->posts.ID = $wpdb->postmeta.post_id AND $wpdb->postmeta.meta_key = ‘key1’ AND $wpdb->postmeta.meta_value=”value1″ // why doesn’t this work? AND $wpdb->postmeta.meta_value=”value2″ AND $wpdb->posts.post_status=”publish” AND $wpdb->posts.post_type=”post” ORDER BY $wpdb->posts.post_date DESC “; next code <?php $args = array( ‘meta_query’ => array( … Read more
Whenever I create a new website I first create a staging site on a subdomain like “stage.domain-name.com”. After everything works correctly I export the database, open it in notepad++ and do a find/replace for “subdomain.domain-name.com” and replace it with “domain-name.com”… finally I import it into a new database for the live site. My question is… … Read more
