Reply to Ashok

Sorry for the late reply - I am not getting emails when a comment is posted.

I have not tested this, but I think it will work:

Change this:


   // Make the menu
   for ($i=0;$i<26 ;++$i ) {
      $this_letter = chr(ord('A') + $i);
      $letter_link = add_query_arg('first-letter',$this_letter,$this_page);
      ?>
      <a href="<?php echo $letter_link; ?>" title="<?php echo "letter-$this_letter"; ?>"> [<?php echo $this_letter; ?> ]</a>
   <?php }

   $query_letter = ($_GET['first-letter']) ? $_GET['first-letter'] : 'A';
   $mam_global_fields = " $wpdb->postmeta.meta_value AS meta_value, UPPER(SUBSTR($wpdb->postmeta.meta_value,1,1)) AS first_letter";
   $mam_global_where = " AND UPPER(SUBSTR($wpdb->postmeta.meta_value,1,1)) = '$query_letter'";


to this:


      $this_letter = 'All';
   $letter_link = add_query_arg('first_letter',$this_letter,$this_page);
   ?>
   <a href="<?php echo $letter_link; ?>" title="<?php echo "letter-$this_letter"; ?>"> [<?php echo $this_letter; ?> ]</a>
   <?php

   // Make the menu
   for ($i=0;$i<26 ;++$i ) {
      $this_letter = chr(ord('A') + $i);
      $letter_link = add_query_arg('first-letter',$this_letter,$this_page);
      ?>
      <a href="<?php echo $letter_link; ?>" title="<?php echo "letter-$this_letter"; ?>"> [<?php echo $this_letter; ?> ]</a>
   <?php }

   $query_letter = ($_GET['first-letter']) ? $_GET['first-letter'] : 'A';
   $mam_global_fields = " $wpdb->postmeta.meta_value AS meta_value, UPPER(SUBSTR($wpdb->postmeta.meta_value,1,1)) AS first_letter";
   if ( $query_letter != 'All' ) {
      $mam_global_where = " AND UPPER(SUBSTR($wpdb->postmeta.meta_value,1,1)) = '$query_letter'";
   }