<?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(); ?>