adding specific category query

  • hello there iam aweb developer and i am really intersted on your plugin actually i was trying to extend it to add the fucnction of querying only spesfic parent category here is what i used in the query var 

    //$biso=233;

		// 	$query = "SELECT  c.*
		// 	FROM {$wpdb->prefix}posts p LEFT JOIN wp_term_relationships ON p.ID = wp_term_relationships.object_id  ,
		// 	 {$wpdb->prefix}comments c 

		// 	 WHERE   p.ID = c.comment_post_ID   AND c.comment_approved > 0 AND p.post_type = 'product' AND p.post_status = 'publish' AND
		// 	  p.comment_count > 0 AND  term_taxonomy_id = 233  ORDER BY ".$order_by." LIMIT 0, ". $number_of_comments;

    but for some reason it’s not working it’s getting wrong comment’s not on the 233 taxonomy .. any help will be apperciated and i will be glad to hand you over my source code to use in future ver’s .. thanks asem

    https://www.ads-software.com/plugins/woocommerce-reviews-widget/

  • The topic ‘adding specific category query’ is closed to new replies.