<?php get_header('allcourses');
global $wpdb;
$results = $wpdb->get_results(
"
SELECT * FROM
( Select * FROM allcourses as ac JOIN completedcourses as cc ON ac.id=cc.courseid WHERE 1 ) as T12
JOIN wp_users as u ON T12.courseid=u.ID WHERE 1
"
);
$tbl = new HTML_TABLE(null, 'display', 1, 0, 4);
$tbl->addRow();
$tbl->addCell('Course Name', 'first', 'header');
$tbl->addCell('Course Value', 'first', 'header');
//ADD NAME COLUMNS
foreach ($results as $result)
{
$tbl->addCell($result->display_name, 'first', 'header');
}
//ADD COURSE ROWS
$courses = $wpdb->get_results(
"
SELECT * FROM allcourses
", OBJECT_K
);
foreach ( $courses as $course )
{
$tbl->addRow();
$tbl->addCell($course->coursename);
$tbl->addCell($course->coursevalue);
//ADD COMPLETED MATRIX
if ($result->completed){
while (($result->completed = 'y'))
$tbl->addCell($result->completed, 'greenbg');
} else {
$tbl->addCell($result->completed, 'redbg');
}
}
//DISPLAY TABLE
echo $tbl->display();
get_footer(); ?>