Count number of rows and unique rows in wordpress custom plugin

Count number of rows and unique rows in wordpress custom plugin

1. No of rows:

$wpdb->get_results("SELECT COUNT(*) FROM wp_frmt_form_entry_meta WHERE meta_key= 'name-1'");
echo $wpdb->num_rows;
2. No of unique rows:

$wpdb->get_results("SELECT DISTINCT entry_id FROM wp_frmt_form_entry_meta");
echo $wpdb->num_rows;

 

 

 

Leave a Reply