Creating Custom WP Query

Question

I've hit some sort of stumbling bock here, and I can't find my way over it.

I'm trying to craft a custom WP query that searches for posts by country of origin, selecting multiple countries at once.

I have a table that maps countries to regions, so the initial query will search for the selected region, and return all of the countries in that region as an array. For example, if you select Africa, it will return an array of countries within Africa.

if(!empty($_REQUEST['region'])){
     $region = $_REQUEST['region'];

    $regionresult = mysql_query("SELECT * FROM gallery_regions WHERE region='$region'") or die(mysql_error());
    $num_rows = mysql_num_rows($regionresult);

    if (!$regionresult) {
        $message  = 'Invalid query: ' . mysql_error() . "\n";
        $message .= 'Whole query: ' . $query;
        die($message);
    }
} else {
     $region = NULL;
}

That part works.

Now, I want to use the returning array to search my WP posts for any that originated from any of the countries in the array. This is the part I can't get to work:

$country_search = array(mysql_fetch_array($regionresult));
$args = array(
    'posts_per_page' => -1,
    'meta_query' => array(
        array(
            'key' => 'Country',
            'value' => '$country_search',
            'compare' => 'IN',
            'category' => 'Gallery'
        )
    )
);
$query = new WP_Query( $args );

I get no results back. In fact, if include echo "$args";, what I get back is simply the word "Array." I also only want it to return results from a specific category.

I'm sure that I'm overlooking something simple. Can anyone help?

Thanks!

ty

That returns this: "Array ( [posts_per_page] => -1 [meta_query] => Array ( [0] => Array ( [key] => Country [value] => $country_search [compare] => IN ) ) )" — Ty Morton
– Ty Morton, Commented Jun 24, 2012 at 17:36
'value' => '$country_search'should be 'value' => $country_search without quotes. — The Alpha
– The Alpha, Commented Jun 24, 2012 at 17:42
That yields me this:Array ([posts_per_page] => -1 [meta_query] => Array([0] => Array([meta_key] => Country [meta_value] => Array ([0] => Array([0] => 4 [id] => 4 [1] => Algeria [country] => Algeria [2] => AF [region] => AF ) ) [compare] => IN ) ) ) — Ty Morton
– Ty Morton, Commented Jun 24, 2012 at 17:45

Ty Morton · Accepted Answer · 2012-06-26 06:27:18Z

I thought the problem was that there were two array objects, and that this:

$country_search = array(mysql_fetch_array($regionresult));
$args = array(
    'posts_per_page' => -1,
    'meta_query' => array(
        array(
            'key' => 'Country',
            'value' => '$country_search',
            'compare' => 'IN',
        )
    )
);
$query = new WP_Query( $args );

Should have been this:

$country_search = array(mysql_fetch_array($regionresult));
$args = array(
    'posts_per_page' => -1,
    'meta_query' => array(
            'key' => 'Country',
            'value' => $country_search,
            'compare' => 'IN',
    )
);
$query = new WP_Query( $args );

But then, instead of returning no posts, it returned all of them. Grumble!

It tured out to be a combination of issues:

Instead of imploding the $country_search_array, it needs to be added as is to the query.
Since it's an array, we can't use the '=' for the compare value. It needs to be 'IN'

I couldn't have figured it out without the assistance I received here. Again, thanks!

gherkins · Accepted Answer · 2012-06-24 17:45:08Z

0

have you tried

'value' => $country_search,

instead of

'value' => '$country_search',

without the quotes?

answered Jun 24, 2012 at 17:45

gherkins

15.1k7 gold badges47 silver badges74 bronze badges

1 Comment

Ty Morton Over a year ago

Yes, I kept switching back and forth. Here's where I am right now:morepositive.com/gallery-test/?region=AF

Collectives™ on Stack Overflow

Creating Custom WP Query

2 Answers 2

Comments

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related