How to search post by subcategories in wordpress. Is it even possible? I was going through the wordpress plugin for searching it. The name is "Facetious Search", but it is limited to categories only. I have googled a lot for this, but got no solution.
> if plugin doesnt provide you desire output then you can get the post of sub category by manually ie from data base.
> First you need to parent category id then you can get its sub category from table wp_term_taxonomy
> after geting subcategory list. you can get the object_id from table Table: wp_term_relationships where term_taxonoy_id=sub category_id
> and From boject_id you can get the post from wp_posts table where object_id is the post id. eg
<?php global $wpdb;$prefix=$wpdb->prefix;
$subcateogyr_list=$wpdb->get_results("Select * from ".$prefix."term_taxonomy WHERE parent='main_category_id'");
foreach($subcateogyr_list as $subcat
$object_id=$wpdb->get_results("select * from ".$prefix."term_relationships where term_taxonomy_id='$subcat['term_id']'");
foreach($object_id as $object_post){
$post_detail=$wpdb->get_row("select * from ".$prefix."posts where id='$object_post['object_id']");
print_r($post_detial);//you will get the post detail
}
}
?>