Search the Community

Hello everyone im new here and im very happy that i found smth good here (just a think). im trying to create alphabetic power search module for joomla my web test is this ->http://vps365826.ovh.net/index.php/africa as you can see the alhabetic line ( A B C D E G I K L M N R S T U Z ) as you see some words missing well thats cause i dont have articles with words ex (F) photo ex. ( http://prntscr.com/e9j9iu ) well i want to create it with all alphabetic words even if we dont have article with that word i've created with my friend that code <div class="ordered"> <ul> <?php $db = JFactory::getDBO(); $query = 'SELECT count(*) as nm, SUBSTR(title,1,1) as alpha FROM #__content WHERE catid = '.$catid.' GROUP BY SUBSTR(title,1,1)'; $db->setQuery($query); $mostIng = $db->loadObjectList(); foreach ($mostIng as $row) { echo '<li data-text="'.$row->alpha.'">'.$row->alpha.' '.'</li>'; } ?> </ul> </div> but i want it somethink like that <div class="ordered"> <ul> <li class="orderedLabel closed">Αναζήτηση αλφαβητικά ></li> <li>A</li> <li>B</li> <li>C</li> <li>D</li> <li>E</li> <li>F</li> <li>G</li> <li>H</li> <li>I</li> <li>J</li> <li>K</li> <li>L</li> <li>M</li> <li>N</li> <li>O</li> <li>P</li> <li>Q</li> <li>R</li> <li>S</li> <li>T</li> <li>U</li> <li>V</li> <li>W</li> <li>X</li> <li>Y</li> <li>Z</li> </ul> </div> well thanks for your time and sorry for my bad english im trying to learing btw thank you very much!!!