query

confirm my booking with phone number

I understand your problem but in your question your going from submission of a form to querying data you expect in the database then displaying it. That covers a lot of steps. My first question is have you confirmed that your submitted form values are being stored as you expect? We need to rule out … Read more

Cannot retrieve home url with custom queries

home_url() uses get_home_url() which in turn uses get_option( ‘home’ ) to retrieve the home url. The code in get_option() includes this: // If home is not set use siteurl. if ( ‘home’ == $option && ” == $value ) return get_option( ‘siteurl’ ); I didn’t unwind all the previous code in the function, but it … Read more

Custom Query problem access the values

You’ve asked for an array and you are trying to use an object. $key = “sc_event_year”; $value = $today_year; global $wpdb; $results = $wpdb->get_results(“SELECT * FROM $wpdb->postmeta WHERE meta_key = ‘sc_event_year’ AND meta_value = $value”, ARRAY_A); foreach ($results as $result){ echo $post_id = $result[‘post_id’]; // <– here was the problem } Unless $value is a … Read more

custom query to get posts

Clarification of your question: You want to show Posts of a certain category named “ABC” AND also you want to filter the posts with the tag named “XYZ”. Answer: If this is the scenario, have you tried: WP_Query()? <?php // The Query $args = array(‘post_type’ => ‘post’, ‘category_name’ => ‘ABC’, ‘tag’ => ‘XYZ’, ‘meta_key’ => … Read more

Query Posts by date range with fixed beginning and end

You should probably add the filter, then use a new query, then remove the filter. function filter_where( $where ) { $where .= ” AND post_date >= ‘2012-03-01’ AND post_date <= ‘2014-03-01′”; return $where; } add_filter( ‘posts_where’, ‘filter_where’ ); $query = new WP_Query( array( ‘post_type’ => ‘shop_order’ ) ); while( $query->have_posts() ) : $query->the_post(); the_title(); the_content(); … Read more

+ More