[Zombie-F]

Originally posted by LangTuDaTinh
search for

PHP Code:

    $quizzes = $DB_site->query("SELECT q.quizid, q.quiztitle, q.description, q.timestamp,
                                       SUM(r.totalcorrect) AS correct, COUNT(r.resultid) AS total
                                FROM quiz q
                                LEFT JOIN quiz_results r
                                  ON (q.quizid = r.quizid)
                                WHERE q.approve  = 1
                                  $clause
                                GROUP BY q.quizid ORDER BY q.timestamp DESC
                                LIMIT $start, $per_page"); 


change to

PHP Code:

    $quizzes = $DB_site->query("SELECT q.quizid, q.quiztitle, q.description, q.timestamp,
                                       SUM(r.totalcorrect) AS correct, COUNT(r.resultid) AS total
                                FROM quiz q
                                LEFT JOIN quiz_results r
                                  ON (q.quizid = r.quizid)
                                WHERE q.approve  = 1
                                  $clause
                                GROUP BY q.quizid ORDER BY q.quiztitle ASC
                                LIMIT $start, $per_page"); 


Thanks man. You rock! This will make finding a particular quiz to take 10x easier.