function proj_get_best() { global $db; $query = "SELECT id\n\t\t\t\tFROM (SELECT recog, grade,dateAdded\n\t\t\t\t\t\tFROM (SELECT recog,grade,MAX(A.dateAdded) dateAdded\n\t\t\t\t\t\t\t\tFROM (SELECT name, class, abstract, description\n\t\t\t\t\t\t\t\t\t\t\t\t, AVG(grade) AS grade, recog\n\t\t\t\t\t\t\t\t\t\t\t\t, P.dateAdded\n\t\t\t\t\t\t\t\t\t\tFROM pq_project P \n\t\t\t\t\t\t\t\t\t\tINNER JOIN pq_project_grades PG \n\t\t\t\t\t\t\t\t\t\t\tON P.id = PG.id AND P.status = 1 \n\t\t\t\t\t\t\t\t\t\t\t\tAND PG.status = 1 \n\t\t\t\t\t\t\t\t\t\t\t\tAND P.forJudging = 0\n\t\t\t\t\t\t\t\t\t\tINNER JOIN pq_project_recogs PR \n\t\t\t\t\t\t\t\t\t\t\tON P.id = PR.id\n\t\t\t\t\t\t\t\t\t\tWHERE forJudging = 0\n\t\t\t\t\t\t\t\t\t\tGROUP BY P.id) A\n\t\t\t\t\t\tGROUP BY recog, grade) B NATURAL JOIN \n\t\t\t\t\t\t(SELECT recog,MAX(grade) as grade\n\t\t\t\t\t\t\tFROM (SELECT name, class, abstract, description\n\t\t\t\t\t\t\t\t\t\t\t, AVG(grade) AS grade, recog\n\t\t\t\t\t\t\t\t\t\t\t, P.dateAdded\n\t\t\t\t\t\t\t\t\tFROM pq_project P \n\t\t\t\t\t\t\t\t\tINNER JOIN pq_project_grades PG \n\t\t\t\t\t\t\t\t\t\tON P.id = PG.id AND P.status = 1 \n\t\t\t\t\t\t\t\t\t\t\tAND PG.status = 1\n\t\t\t\t\t\t\t\t\t\t\tAND P.forJudging = 0\n\t\t\t\t\t\t\t\t\tINNER JOIN pq_project_recogs PR \n\t\t\t\t\t\t\t\t\t\tON P.id = PR.id\n\t\t\t\t\t\t\t\t\tWHERE forJudging = 0\n\t\t\t\t\t\t\t\t\tGROUP BY P.id) A\n\t\t\t\t\t\t\tGROUP BY recog)C)A2\n\t\t\t\t\t\tNATURAL JOIN \n\t\t\t\t (SELECT P.id,AVG(grade) AS grade, recog, P.dateAdded\n\t\t\t\t\t\t\t\tFROM pq_project P \n\t\t\t\t\t\t\t\tINNER JOIN pq_project_grades PG \n\t\t\t\t\t\t\t\t\tON P.id = PG.id AND P.status = 1 \n\t\t\t\t\t\t\t\t\t\tAND PG.status = 1\n\t\t\t\t\t\t\t\t\t\tAND P.forJudging = 0\n\t\t\t\t\t\t\t\tINNER JOIN pq_project_recogs PR \n\t\t\t\t\t\t\t\t\tON P.id = PR.id\n\t\t\t\t\t\t\t\tWHERE forJudging = 0\n\t\t\t\t\t\t\t\tGROUP BY P.id)B\n\t\t\t\tORDER BY B.grade DESC"; $res = $db->query("SELECT", $query); if ($res['status']) { $projects = array(); foreach ($res['data'] as $project) { $projects[] = proj_get($project['id']); } return $projects; } else { return false; } }
<?php /** * Developed and designed by: Laurenz T. * email me @: laurenz@outlook.ph * COLLEGE OF COMPUTER STUDIES * COMPUTER SCIENCE - SOFTWARE TECHNOLOGY * "Ang pusong nabiyak, madalas naninindak" #uselessQuotesNgBagongTaon #2016 */ require_once "includes/project-functions.php"; if (!isset($_GET['id'])) { header("Location: ./"); } $project = proj_get($_GET['id']); ?> <html> <head> <title>Quiver | Sample </title> <!-- Google icons --> <link href="https://fonts.googleapis.com/icon?family=Material+Icons" rel="stylesheet"/> <!-- Fonts up up and away --> <link type="text/css" rel="stylesheet" href="css/fontpack.css"/> <!-- Materialize CSS Import --> <link type="text/css" rel="stylesheet" href="css/materialize.css" media="screen,projection"/> <!-- Custom Stylesheet --> <link type="text/css" rel="stylesheet" href="css/styles-2.css"/> <!-- PLEASE UPDATE THE FAVICON FFS --> <link rel="icon" type="image/png" href="assets/img/hack2015-favicon.png"> <!--