get_results($wpdb->prepare(
“SELECT dmod.sku, dmod.title, dmod.description, CONCAT_WS(‘ ‘, auth.fname, auth.lname) as author, mulauth.module_sku, mulauth.author_sku, multi_disc.discipline_sku, disc.discipline, res.learn_res_type, CONCAT_WS(‘ – ‘, gfrom.grade, gto.grade) as grade, media.media_type, mulkwd.keyword_sku, keyword.keyword, abet.outcome, CONCAT_WS(‘ ‘, pubmonth.month, pubyear.year) as pubdate, docs.url, muldocs.url_sku
FROM csevl_multi_author mulauth
LEFT JOIN csevl_author auth ON auth.sku = mulauth.author_sku
LEFT JOIN csevl_data_mod dmod ON dmod.sku = mulauth.module_sku
LEFT JOIN csevl_multi_discipline multi_disc ON dmod.sku = multi_disc.md_module_sku
LEFT JOIN csevl_discipline disc ON multi_disc.discipline_sku = disc.sku
LEFT JOIN csevl_learn_res_type res ON dmod.learn_res_type = res.sku
LEFT JOIN csevl_grade gfrom ON dmod.grade_from = gfrom.sku
LEFT JOIN csevl_grade gto ON dmod.grade_to = gto.sku
LEFT JOIN csevl_mediatype media ON dmod.media_type = media.sku
LEFT JOIN csevl_multi_kwd mulkwd ON dmod.sku = mulkwd.module_sku
LEFT JOIN csevl_keyword keyword ON mulkwd.keyword_sku = keyword.sku
LEFT JOIN csevl_abetlearning abet ON dmod.abet_learning = abet.sku
LEFT JOIN csevl_publication_year pubyear ON dmod.pub_year = pubyear.sku
LEFT JOIN csevl_months pubmonth ON dmod.pub_month = pubmonth.sku
LEFT JOIN csevl_multi_documents muldocs ON dmod.sku = muldocs.module_sku
LEFT JOIN csevl_documents docs ON muldocs.url_sku = docs.url_sku
WHERE dmod.sku = ” . $_GET[‘sku’] .””));
$max = count($module_information);
for ($i=0; $i < $max; $i++) {
//declare vars
$module_sku = $module_information[$i]->sku;
$prev_module_sku = $module_information[$i-1]->sku;
$title = $module_information[$i]->title;
$description = $module_information[$i]->description;
$resourceType = $module_information[$i]->learn_res_type;
$grade = $module_information[$i]->grade;
$media_type = $module_information[$i]->media_type;
$abet = $module_information[$i]->outcome;
$pubdate = $module_information[$i]->pubdate;
$cost = $module_information[$i]->costdesc;
//display table row based on title duplication
if ($module_sku != $prev_module_sku) {
echo “
// ——–TITLE——- //
echo “
” . $title . “
“;
// ——–DESCRIPTION——– //
echo “
- ” . $description . “
“;
// ——–AUTHOR(S)——- //
echo “
- “;
- ” . $module_information[$k]->author . “
$k = $i;
$author_check = array();
do {
if (!in_array($module_information[$k]->author_sku, $author_check)) { //check for duplication
if ($module_information[$k]->author_sku != 0) {
echo “
“;
}
}
array_push($author_check, $module_information[$k]->author_sku);
$k++;
} while ($module_information[$k]->sku == $module_information[$k-1]->sku);
echo “
“;
// ——–LEARNING RESOURCE TYPE——– //
echo “
- ” . $resourceType . “
“;
// ——–DISCIPLINE(S)——– //
echo “
- “;
- ” . $module_information[$j]->discipline . “
$j = $i;
$discipline_check = array();
do {
if (!in_array($module_information[$j]->discipline_sku, $discipline_check)) { //check for duplication
if ($module_information[$j]->discipline_sku != 0) {
echo “
“;
}
}
array_push($discipline_check, $module_information[$j]->discipline_sku);
$j++;
} while ($module_information[$j]->sku == $module_information[$j-1]->sku);
echo “
“;
// ——–AUDIENCE/GRADE——– //
echo “
- ” . $grade . “
“;
// ——–MEDIA TYPE——– //
echo “
- ” . $media_type . “
“;
// ——–RATING——– //
echo “
- ” . $rating . “
“;
// ——–KEYWORD(S)——– //
echo “
- “;
- ” . $module_information[$x]->keyword . “
$x = $i;
$keyword_check = array();
do {
if (!in_array($module_information[$x]->keyword_sku, $keyword_check)) { //check for duplication
if ($module_information[$x]->keyword_sku != 0) {
echo “
“;
}
}
array_push($keyword_check, $module_information[$x]->keyword_sku);
$x++;
} while ($module_information[$x]->sku == $module_information[$x-1]->sku);
echo “
“;
// ——–RELATED ABET CRITERIA——– //
echo “
- ” . $abet . “
“;
// ——–PUBLICATION DATE——– //
echo “
- ” . $pubdate . “
“;
// ——–COST——– //
//echo “
- ” . $cost . “
“;
// ——–DOWNLOAD URL——– //
echo “