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:
  • ” . $description . “

“;

// ——–AUTHOR(S)——- //

echo “

Author(s):
    “;

    $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 “

  • ” . $module_information[$k]->author . “

    • “;

    }
    }
    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 “

Learning Resource Type:
  • ” . $resourceType . “

“;

// ——–DISCIPLINE(S)——– //

echo “

Discipline(s):
    “;

    $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 “

  • ” . $module_information[$j]->discipline . “

    • “;

    }
    }
    array_push($discipline_check, $module_information[$j]->discipline_sku);
    $j++;
    } while ($module_information[$j]->sku == $module_information[$j-1]->sku);

    echo “

“;

// ——–AUDIENCE/GRADE——– //

echo “

Audience/Grade:
  • ” . $grade . “

“;

// ——–MEDIA TYPE——– //

echo “

Media Type:
  • ” . $media_type . “

“;

// ——–RATING——– //

echo “

Rating:
  • ” . $rating . “

“;

// ——–KEYWORD(S)——– //

echo “

Keywords:
    “;

    $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 “

  • ” . $module_information[$x]->keyword . “

    • “;

    }
    }
    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 “

Related ABET Criteria:
  • ” . $abet . “

“;

// ——–PUBLICATION DATE——– //

echo “

Publication Date:
  • ” . $pubdate . “

“;

// ——–COST——– //

//echo “

Cost
  • ” . $cost . “

“;

// ——–DOWNLOAD URL——– //

echo “

Documentation:
    “;

    $b = $i;
    $url_check = array();

    do {

    if (!in_array($module_information[$b]->url_sku, $url_check)) { //check for duplication

    if ($module_information[$b]->url_sku != 0) {

    echo “