<?php
$product='xyz';
$product=strtoupper($product);
$ids = $wpdb->get_col("SELECT ID FROM $wpdb->posts WHERE UCASE(post_title) LIKE '%$product%' AND post_type='post' AND post_status='publish'");
if ($ids) {
$args=array(
'post__in' => $ids,
'posts_per_page' => -1,
'caller_get_posts'=> 1
);
$my_query = null;
$my_query = new WP_Query($args);
if( $my_query->have_posts() ) {
echo 'List of Posts';
while ($my_query->have_posts()) : $my_query->the_post(); ?>
<p><a href="<?php the_permalink() ?>" rel="bookmark" title="Permanent Link to <?php the_title_attribute(); ?>"><?php the_title(); ?></a></p>
<?php
endwhile;
}
wp_reset_query(); // Restore global post data stomped by the_post().
}
?>
[moderated fixed code]
Note the change I made to the SQL statement — UCASE(post_title)
Can I add category_name, meta_key=specs&meta_value=, in the args ?
regards,
Ashwin.
Note you didn’t put anything after meta_value= so if you want all posts with meta_key=specs you don’t have to specify the meta_value= unless you want to limit it to a specific value.
You’d have to use category__in so you’d need to know the ID of the categories you wanted:
//get specified post IDs in category 1, 53, or 3, where "meta_key" is "season" and "meta_value" is "2"
$args=array(
'category__in' => array(1,56,3),
'meta_key'=>'season',
'meta_value'=> '2',
'post_type' => 'post',
'post__in' => $ids,
'posts_per_page' => -1,
'caller_get_posts'=> 1
);
I have two select fields(one for metakey/value and one for category) one input field(for post name) in a custom search page.
I have written the code for both
<?php
$location = $_POST[“location”];
$product = $_POST[“product”];
$category = $_POST[“cat”];
$catname = get_cat_name($category);
?>
<!– if custom field location is mentioned Category is not Mentioned –>
<?php
if($location!=”All” && $category==0) {
$query = “meta_key=specs&meta_value=” . $location;
$my_query = new WP_Query($query); ?>
<?php while ($my_query->have_posts()) : $my_query->the_post(); ?>
<h2>” rel=”bookmark” title=”Permanent Link to <?php the_title_attribute(); ?>”>
<?php the_title(); ?>
<?php endwhile; } ?>
<!– if category and location both are mentioned –>
<?php
if($category!=0 && $location!=”All”) {
$query = “meta_key=specs&meta_value=” . $location . “&category_name=” . $catname;
$my_query = new WP_Query($query); ?>
<?php while ($my_query->have_posts()) : $my_query->the_post(); ?>
<h2>” rel=”bookmark” title=”Permanent Link to <?php the_title_attribute(); ?>”>
<?php the_title(); ?>
<?php endwhile; } ?>
Now, I need to get posts based on postname($product) and from a specific category($catname). Also, based on postname and the post with the give meta_key/value pair. Lastly all three.
Then you’ll need to replace the $args statement with something like:
$cat_id = get_cat_ID($catname');
$args=array(
'category__in' => array($cat_id),
'meta_key'=>'specs',
'meta_value'=> $location,
'post_type' => 'post',
'post__in' => $ids,
'posts_per_page' => -1,
'caller_get_posts'=> 1
);
lovely, thanks very much. 🙂
