I want to get number or count of same meta_value of meta_key == 'parent_id'.How can i get it? What should be the wordpress query for counting records in same table?

enter image description here

//set the meta_key to the appropriate custom field meta key
$meta_key = 'parent_id';

$allmiles = $wpdb->get_var( $wpdb->prepare( 
  "SELECT meta_value,
  SUM(IF(meta_value = "Purva", 1,0)) AS 'parent_id',
  COUNT(meta_value) AS 'total'
  FROM $wpdb->wp_postmeta
  GROUP BY post_id
  ORDER BY parent_id DESC", 
) );

echo "<p>Total miles is {$allmiles}</p>"; 
   global $wpdb;
   $table_name = $wpdb->prefix . "postmeta"; 
   $login_name = sanitize_user( $_POST['parent_id'] ); 
   $prepare = $wpdb->prepare( "SELECT COUNT(*) FROM $table_name WHERE    meta_value = 'Purva' AND meta_key = 'parent_id' ", $login_name );
   $myrows = $wpdb->get_results( $prepare );
   echo '<pre>' . print_r( $myrows, true ) . '</pre>';

I tried this and get values but still something missing...

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.