'; $order = ''; switch ($sort) { case '!status': $order = '`checkStatusCode` DESC, `websiteName` ASC'; break; case 'datum': $order = '`checkDate` ASC, `websiteName` ASC'; break; case '!datum': $order = '`checkDate` DESC, `websiteName` ASC'; break; case 'website': $order = '`websiteName` ASC'; break; case '!website': $order = '`websiteName` DESC'; break; default: $order = '`checkStatusCode` ASC, `websiteName` ASC'; } $statement = $_DATABASE->getConnection()->prepare(' SELECT `website`.*, `check`.* FROM `' . MYSQL_PREFIX . 'website` AS `website` LEFT JOIN `' . MYSQL_PREFIX . 'check` AS `check` ON `check`.`websiteID` = `website`.`websiteID` WHERE `website`.`websiteRemoved` = :removed AND ( `check`.`checkID` IS NULL OR `check`.`checkID` = (SELECT `checkID` FROM `' . MYSQL_PREFIX . 'check` WHERE `websiteID` = `website`.`websiteID` ORDER BY `checkID` DESC LIMIT 1) ) ORDER BY ' . $order . ' '); $statement->execute(array(':removed' => 0)); $websiteList = $statement->fetchAll(); foreach ($websiteList as $website) { echo ' '; } echo '

Website' . ($sort == 'website' ? ' ' : ($sort == '!website' ? ' ' : '')) . '	Status' . ($sort == 'status' ? ' ' : ($sort == '!status' ? ' ' : '')) . '	Laatste controle' . ($sort == 'datum' ? ' ' : ($sort == '!datum' ? ' ' : '')) . '
' . $website['websiteName'] . ' ' . stripUrl($website['websiteUrl']) . '	' . (isset($website['checkStatusCode']) ? '' : '') . '	' . (isset($website['checkDate']) ? date(FORMAT_DATE_TIME, $website['checkDate']) : 'Niet gecontroleerd') . '