artigas wrote:
Greetings -

While all this is beyond what I already know about PHP and MySQL, all things being the same, has anyone looked at the data in the table itself?

I will make the sugestion that you dump (not sure of how to do this) the data to a text file and have a look to see that it all looks reasonable and that there are no 'unsual' (what would those be?) characters in the data.

Martijn wrote:
Perhaps a workaround would be like the suggested handling in php, to query all records and only return the records where title starts with a '$list'. Let me know if you find another way to solve the root of the problem, which is the database. If there is not, I will have a look on a short workaround in php.

if (substr($value,0,1) == $list) {
show this record
}

Does this provide you with enough information to try and adjust your viewlist.php file?

while(list($lid,$lcid,$ltitle,$phone,$hits,$rating,$votes)=$xoopsDB->fetchRow($result2)){
if (substr($ltitle,0,1) == $list) {
$catpath = $mytree->getPathFromId($lcid, "title");
$catpath= substr($catpath, 1);
$catpath = str_replace("/"," <span class='fg2'>»</span> ",$catpath);
$rankings[$e]['links'][] = array('id' => $lid, 'cid' => $cid, 'rank' => $rank, 'title' => $myts->htmlSpecialChars($ltitle), 'category' => $catpath, 'hits' => $hits, 'rating' => number_format($rating, 2), 'votes' => $votes, 'phone' => $phone);
$rank++;
}
}

Xoops worth the work: "There's something about XOOPS ... makes you want to work with it more"