I got an alpha index (A | B | C | D |... ) to catalogue lyrics, so if the user wants to list all lyrics starting by "A" he simply clicks "A". But the returned results don't show lyrics started by "À" for example "Às pedras da rua".
How can I get all the results started by "A" including the ones with accented letters like "À"?
Here is the code I got:
Code: Select all
switch($task){
case "listforletter":
$action = "index.php?option=".$option."&Itemid=".$Itemid."&
amp;task=".$task."&letter=".$letter;
if($letter!='0')
$database->setQuery("SELECT COUNT(a.id) FROM #__jmovies as a WHERE a.access <= ".(int)$my->gid." AND SUBSTRING(a.title,1,1)='".$letter."'");
else
$database->setQuery("SELECT COUNT(a.id) FROM #__jmovies as a WHERE a.access <= ".(int)$my->gid." AND (SUBSTRING(a.title,1,1)='0'");
$total = $database->loadResult();
break;Thank you for your time !