Title: dumcoder's Replies | WordPress.org

---

# dumcoder

  [  ](https://wordpress.org/support/users/dumcoder/)

 *   [Profile](https://wordpress.org/support/users/dumcoder/)
 *   [Topics Started](https://wordpress.org/support/users/dumcoder/topics/)
 *   [Replies Created](https://wordpress.org/support/users/dumcoder/replies/)
 *   [Reviews Written](https://wordpress.org/support/users/dumcoder/reviews/)
 *   [Topics Replied To](https://wordpress.org/support/users/dumcoder/replied-to/)
 *   [Engagements](https://wordpress.org/support/users/dumcoder/engagements/)
 *   [Favorites](https://wordpress.org/support/users/dumcoder/favorites/)

 Search replies:

## Forum Replies Created

Viewing 12 replies - 1 through 12 (of 12 total)

 *   Forum: [Fixing WordPress](https://wordpress.org/support/forum/how-to-and-troubleshooting/)
   
   In reply to: [Calculate occurrences of text word in postmeta meta_value](https://wordpress.org/support/topic/calculate-occurrences-of-text-word-in-postmeta-meta_value/)
 *  Thread Starter [dumcoder](https://wordpress.org/support/users/dumcoder/)
 * (@dumcoder)
 * [15 years, 8 months ago](https://wordpress.org/support/topic/calculate-occurrences-of-text-word-in-postmeta-meta_value/#post-1724370)
 * Alright. Thank you for all of your help. You have saved me hours of frustration.
 *   Forum: [Fixing WordPress](https://wordpress.org/support/forum/how-to-and-troubleshooting/)
   
   In reply to: [Calculate occurrences of text word in postmeta meta_value](https://wordpress.org/support/topic/calculate-occurrences-of-text-word-in-postmeta-meta_value/)
 *  Thread Starter [dumcoder](https://wordpress.org/support/users/dumcoder/)
 * (@dumcoder)
 * [15 years, 8 months ago](https://wordpress.org/support/topic/calculate-occurrences-of-text-word-in-postmeta-meta_value/#post-1724344)
 * That is beautiful. Thank you very much.
 * Now extending on that, is it possible to sort out the super_m value?
    As in count
   the ‘super_m’s with data?
 * So if:
    super_m = ” //don’t count super_m = ‘Hello.’ //count
 * Your help is very much appreciated.
 *   Forum: [Fixing WordPress](https://wordpress.org/support/forum/how-to-and-troubleshooting/)
   
   In reply to: [Calculate occurrences of text word in postmeta meta_value](https://wordpress.org/support/topic/calculate-occurrences-of-text-word-in-postmeta-meta_value/)
 *  Thread Starter [dumcoder](https://wordpress.org/support/users/dumcoder/)
 * (@dumcoder)
 * [15 years, 8 months ago](https://wordpress.org/support/topic/calculate-occurrences-of-text-word-in-postmeta-meta_value/#post-1724291)
 * My issue with that is, it only counts how many ‘_custom_meta’s have ‘super_m’
   in them. Not how many ‘super_m’s are in the ‘_custom_meta’ meta_key.
 * So if I have a ‘_custom_meta’ that contains ‘super_m’ more than once, it only
   counts it as one.
 *   Forum: [Fixing WordPress](https://wordpress.org/support/forum/how-to-and-troubleshooting/)
   
   In reply to: [Calculate occurrences of text word in postmeta meta_value](https://wordpress.org/support/topic/calculate-occurrences-of-text-word-in-postmeta-meta_value/)
 *  Thread Starter [dumcoder](https://wordpress.org/support/users/dumcoder/)
 * (@dumcoder)
 * [15 years, 8 months ago](https://wordpress.org/support/topic/calculate-occurrences-of-text-word-in-postmeta-meta_value/#post-1724177)
 * Ok so basically in my wp_postmeta table, I have 4 posts with the meta_key being‘
   _custom_meta’.
 * Now within those 4 posts, I want to count all occurrences of ‘super_m’.
 * So we know that ‘_custom_meta’ = 4
 * I need to know how many times ‘super_m’ is written in the contents of the strings.
 *   Forum: [Fixing WordPress](https://wordpress.org/support/forum/how-to-and-troubleshooting/)
   
   In reply to: [Calculate occurrences of text word in postmeta meta_value](https://wordpress.org/support/topic/calculate-occurrences-of-text-word-in-postmeta-meta_value/)
 *  Thread Starter [dumcoder](https://wordpress.org/support/users/dumcoder/)
 * (@dumcoder)
 * [15 years, 8 months ago](https://wordpress.org/support/topic/calculate-occurrences-of-text-word-in-postmeta-meta_value/#post-1724167)
 * returns 0. I can count 11 in the db.
 *   Forum: [Fixing WordPress](https://wordpress.org/support/forum/how-to-and-troubleshooting/)
   
   In reply to: [Navigation menu backround color incomplete](https://wordpress.org/support/topic/navigation-menu-backround-color-incomplete/)
 *  [dumcoder](https://wordpress.org/support/users/dumcoder/)
 * (@dumcoder)
 * [15 years, 8 months ago](https://wordpress.org/support/topic/navigation-menu-backround-color-incomplete/#post-1724159)
 * <img src=”[http://www.gleneirau3a.com/wp-content/themes/twentyten/images/headers/sunset.jpg&#8221](http://www.gleneirau3a.com/wp-content/themes/twentyten/images/headers/sunset.jpg&#8221);
   width=”940″ height=”198″ alt=””>
 * Your header image had a width of 940.
 *   Forum: [Fixing WordPress](https://wordpress.org/support/forum/how-to-and-troubleshooting/)
   
   In reply to: [Navigation menu backround color incomplete](https://wordpress.org/support/topic/navigation-menu-backround-color-incomplete/)
 *  [dumcoder](https://wordpress.org/support/users/dumcoder/)
 * (@dumcoder)
 * [15 years, 8 months ago](https://wordpress.org/support/topic/navigation-menu-backround-color-incomplete/#post-1724155)
 * ‘
    #access { background: black; display: block; float: left; margin: 0px auto;
   width: 940px; } ‘ should do it
 *   Forum: [Fixing WordPress](https://wordpress.org/support/forum/how-to-and-troubleshooting/)
   
   In reply to: [Logo Centering](https://wordpress.org/support/topic/logo-centering/)
 *  [dumcoder](https://wordpress.org/support/users/dumcoder/)
 * (@dumcoder)
 * [15 years, 8 months ago](https://wordpress.org/support/topic/logo-centering/#post-1719679)
 * wouldn’t recommend that
 *   Forum: [Fixing WordPress](https://wordpress.org/support/forum/how-to-and-troubleshooting/)
   
   In reply to: [Logo Centering](https://wordpress.org/support/topic/logo-centering/)
 *  [dumcoder](https://wordpress.org/support/users/dumcoder/)
 * (@dumcoder)
 * [15 years, 8 months ago](https://wordpress.org/support/topic/logo-centering/#post-1719676)
 * h2 {
    margin-left: auto; margin-right: auto; }
 * ??
 *   Forum: [Fixing WordPress](https://wordpress.org/support/forum/how-to-and-troubleshooting/)
   
   In reply to: [Logo Centering](https://wordpress.org/support/topic/logo-centering/)
 *  [dumcoder](https://wordpress.org/support/users/dumcoder/)
 * (@dumcoder)
 * [15 years, 8 months ago](https://wordpress.org/support/topic/logo-centering/#post-1719675)
 * `<center><a rel="" href="http://churroblog.com" title="Churro Blog"><span class
   ="navigation_spacer"><img src="http://churroblog.com/wp-content/uploads/2010/
   10/churrobloglogo.png" border="0" alt="Churro Blog" /></span></a></center>` ?
 *   Forum: [Fixing WordPress](https://wordpress.org/support/forum/how-to-and-troubleshooting/)
   
   In reply to: [Calculate occurrences of text word in postmeta meta_value](https://wordpress.org/support/topic/calculate-occurrences-of-text-word-in-postmeta-meta_value/)
 *  Thread Starter [dumcoder](https://wordpress.org/support/users/dumcoder/)
 * (@dumcoder)
 * [15 years, 8 months ago](https://wordpress.org/support/topic/calculate-occurrences-of-text-word-in-postmeta-meta_value/#post-1724141)
 * Lost.
 *     ```
       $dum = get_post_custom_values('_custom_meta');
       $coder = implode(':',$dum);
       $help = unserialize($coder);
       echo substr_count($help, 'super_m');
       ```
   
 * Previous working code on older wordpress looked something like this
 *     ```
       <?php
       $count = $wpdb->get_var("SELECT COUNT(*) FROM $wpdb->posts
       LEFT JOIN $wpdb->postmeta ON($wpdb->posts.ID = $wpdb->postmeta.post_id)
       LEFT JOIN $wpdb->term_relationships ON($wpdb->posts.ID = $wpdb->term_relationships.object_id)
       LEFT JOIN $wpdb->term_taxonomy ON($wpdb->term_relationships.term_taxonomy_id = $wpdb->term_taxonomy.term_taxonomy_id)
       LEFT JOIN $wpdb->terms ON($wpdb->term_taxonomy.term_id = $wpdb->terms.term_id)
       WHERE $wpdb->terms.term_id = '9'
       AND $wpdb->postmeta.meta_key = '$day'
       AND $wpdb->postmeta.meta_value != ''
       ");
       echo '(' .$count . ')';?>
       ```
   
 * Code executed in header….
 *   Forum: [Fixing WordPress](https://wordpress.org/support/forum/how-to-and-troubleshooting/)
   
   In reply to: [Calculate occurrences of text word in postmeta meta_value](https://wordpress.org/support/topic/calculate-occurrences-of-text-word-in-postmeta-meta_value/)
 *  Thread Starter [dumcoder](https://wordpress.org/support/users/dumcoder/)
 * (@dumcoder)
 * [15 years, 8 months ago](https://wordpress.org/support/topic/calculate-occurrences-of-text-word-in-postmeta-meta_value/#post-1724130)
 * Now what if I had multiple meta_keys with the same name I am trying to read? 
   Sorry for ignorance, it’s been a long day. Just figured I would look for some
   help, this has been holding me up a while and I am so burnt out on it.

Viewing 12 replies - 1 through 12 (of 12 total)