Sign up |
It came to out attention that the "related Files Setin in our articles was not pickin up the "Category 2" Titles... How can we adjust our code for that? Included is our page template, "Related Content" starts on Line 365
It looks like it should be loading articles that have the same categoryNum.
You can try showing what MySQL query is being used to load related articles by adding 'debugSql' => true (see below). And you can put a showme() statement right below that see what's being loaded.
$where = "categoryNum = '".mysql_escape($articlesRecord['categoryNum'])."' AND num != '".intval($articlesRecord['num'])."'";
list($relatedArticles, $relatedArticlesMetaData) = getRecords(array(
'tableName' => 'articles',
'allowSearch' => false,
'limit' => 5,
'orderBy' => 'createdDate DESC',
'where' => $where,
'debugSql' => true, // debug
showme($relatedArticles); exit; // debug
Let me know what you find out.