Advertisement
iftekharul

Get Posts by First Letter

May 4th, 2015
271
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
PHP 0.67 KB | None | 0 0
  1. <?php
  2. /*
  3. Name: Get Posts by First Letter.
  4. Author: Iftekhar
  5. Author URI: http://www.tips4blog.com/
  6. */
  7.  
  8. function get_post_by_first_letters($letter) {
  9.         global $wpdb;
  10.         $table_name = $wpdb->prefix."posts";
  11.         $sql="SELECT ID, post_title FROM $table_name WHERE post_title LIKE '$letter%' AND post_type = 'post'";
  12.         $result = $wpdb->get_results($sql);
  13.         if($result === NULL){
  14.                 $result = 0;
  15.         }
  16.         return $result;
  17. }
  18. $post_title = get_post_by_first_letters('H');
  19. echo '<ul>';
  20. foreach($post_title as $title) {
  21.     echo '<li><a href="' . get_permalink($title->ID) . '">' . $title->post_title . '</a></li>';
  22. }
  23. echo '</ul>'
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement